Click here to Skip to main content
Click here to Skip to main content
Articles » Database » Database » Databases » Downloads
 
Add your own
alternative version

PostgreSQL & PostGis Operations

, 10 Jun 2009
In this article, I would like to show you how to (backup, restore) DB & converting between PostGIS & Esri shape file
postgreSqlThaboot.zip
postgreSqlThaboot
postgreSqlThaboot
bin
Debug
de
Npgsql.resources.dll
es
Npgsql.resources.dll
fi
Npgsql.resources.dll
fr
Npgsql.resources.dll
ja
Npgsql.resources.dll
Mono.Security.dll
Npgsql.dll
postgreSqlThaboot.exe
postgreSqlThaboot.vshost.exe
postgreSqlThaboot.vshost.exe.manifest
zh-CN
Npgsql.resources.dll
Properties
Settings.settings
postgreSqlThaboot.suo
postgreSqlThaboot_Image.zip
postgreSqlThaboot_Project.zip
Npgsql.resources.dll
Npgsql.resources.dll
Npgsql.resources.dll
Npgsql.resources.dll
Npgsql.resources.dll
Mono.Security.dll
Npgsql.dll
postgreSqlThaboot.exe
postgreSqlThaboot.vshost.exe
postgreSqlThaboot.vshost.exe.manifest
Npgsql.resources.dll
Settings.settings
postgreSqlThaboot.suo
postgreSqlThaboot_Source.zip
Npgsql.resources.dll
Npgsql.resources.dll
Npgsql.resources.dll
Npgsql.resources.dll
Npgsql.resources.dll
Mono.Security.dll
Npgsql.dll
postgreSqlThaboot.exe
postgreSqlThaboot.vshost.exe
postgreSqlThaboot.vshost.exe.manifest
Npgsql.resources.dll
Settings.settings
postgreSqlThaboot.suo
postgreSqlThaboot_Source_code.zip
Npgsql.resources.dll
Npgsql.resources.dll
Npgsql.resources.dll
Npgsql.resources.dll
Npgsql.resources.dll
Mono.Security.dll
Npgsql.dll
pgsql2shp.exe
pg_dump.exe
pg_restore.exe
postgreSqlThaboot.exe
postgreSqlThaboot.vshost.exe
postgreSqlThaboot.vshost.exe.manifest
shp2pgsql.exe
Npgsql.resources.dll
Settings.settings
postgreSqlThaboot.suo
namespace postgreSqlThaboot
{
    partial class Form1
    {
        /// <summary>
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary>
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Windows Form Designer generated code

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.btnCreateBackup = new System.Windows.Forms.Button();
            this.statusStrip1 = new System.Windows.Forms.StatusStrip();
            this.toolStripStatusLabel1 = new System.Windows.Forms.ToolStripStatusLabel();
            this.groupBox1 = new System.Windows.Forms.GroupBox();
            this.btnRestoreDB = new System.Windows.Forms.Button();
            this.groupBox3 = new System.Windows.Forms.GroupBox();
            this.btnShp2Pgsql = new System.Windows.Forms.Button();
            this.groupBox4 = new System.Windows.Forms.GroupBox();
            this.lstAvailbeLayers = new System.Windows.Forms.ListBox();
            this.btnPgsql2Shp = new System.Windows.Forms.Button();
            this.groupBox5 = new System.Windows.Forms.GroupBox();
            this.DB = new System.Windows.Forms.Label();
            this.txtDB = new System.Windows.Forms.TextBox();
            this.label8 = new System.Windows.Forms.Label();
            this.txtHost = new System.Windows.Forms.TextBox();
            this.label7 = new System.Windows.Forms.Label();
            this.txtPort = new System.Windows.Forms.TextBox();
            this.label6 = new System.Windows.Forms.Label();
            this.txtPass = new System.Windows.Forms.TextBox();
            this.txtConnect = new System.Windows.Forms.Button();
            this.label5 = new System.Windows.Forms.Label();
            this.txtUserName = new System.Windows.Forms.TextBox();
            this.label1 = new System.Windows.Forms.Label();
            this.label2 = new System.Windows.Forms.Label();
            this.label3 = new System.Windows.Forms.Label();
            this.label4 = new System.Windows.Forms.Label();
            this.statusStrip1.SuspendLayout();
            this.groupBox1.SuspendLayout();
            this.groupBox3.SuspendLayout();
            this.groupBox4.SuspendLayout();
            this.groupBox5.SuspendLayout();
            this.SuspendLayout();
            // 
            // btnCreateBackup
            // 
            this.btnCreateBackup.Location = new System.Drawing.Point(51, 37);
            this.btnCreateBackup.Name = "btnCreateBackup";
            this.btnCreateBackup.Size = new System.Drawing.Size(137, 23);
            this.btnCreateBackup.TabIndex = 0;
            this.btnCreateBackup.Text = "Create Backup of DB";
            this.btnCreateBackup.UseVisualStyleBackColor = true;
            this.btnCreateBackup.Click += new System.EventHandler(this.btnCreateBackup_Click);
            // 
            // statusStrip1
            // 
            this.statusStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.toolStripStatusLabel1});
            this.statusStrip1.Location = new System.Drawing.Point(0, 297);
            this.statusStrip1.Name = "statusStrip1";
            this.statusStrip1.Size = new System.Drawing.Size(535, 22);
            this.statusStrip1.TabIndex = 3;
            this.statusStrip1.Text = "statusStrip1";
            // 
            // toolStripStatusLabel1
            // 
            this.toolStripStatusLabel1.Name = "toolStripStatusLabel1";
            this.toolStripStatusLabel1.Size = new System.Drawing.Size(0, 17);
            // 
            // groupBox1
            // 
            this.groupBox1.Controls.Add(this.label2);
            this.groupBox1.Controls.Add(this.label1);
            this.groupBox1.Controls.Add(this.btnRestoreDB);
            this.groupBox1.Controls.Add(this.btnCreateBackup);
            this.groupBox1.Enabled = false;
            this.groupBox1.Location = new System.Drawing.Point(11, 169);
            this.groupBox1.Name = "groupBox1";
            this.groupBox1.Size = new System.Drawing.Size(261, 115);
            this.groupBox1.TabIndex = 4;
            this.groupBox1.TabStop = false;
            this.groupBox1.Text = "DB Operations";
            // 
            // btnRestoreDB
            // 
            this.btnRestoreDB.Location = new System.Drawing.Point(49, 87);
            this.btnRestoreDB.Name = "btnRestoreDB";
            this.btnRestoreDB.Size = new System.Drawing.Size(137, 23);
            this.btnRestoreDB.TabIndex = 5;
            this.btnRestoreDB.Text = "Restore DB";
            this.btnRestoreDB.UseVisualStyleBackColor = true;
            this.btnRestoreDB.Click += new System.EventHandler(this.btnRestoreDB_Click);
            // 
            // groupBox3
            // 
            this.groupBox3.Controls.Add(this.label3);
            this.groupBox3.Controls.Add(this.btnShp2Pgsql);
            this.groupBox3.Enabled = false;
            this.groupBox3.Location = new System.Drawing.Point(276, 20);
            this.groupBox3.Name = "groupBox3";
            this.groupBox3.Size = new System.Drawing.Size(247, 74);
            this.groupBox3.TabIndex = 9;
            this.groupBox3.TabStop = false;
            this.groupBox3.Text = "Shape 2 PostGIS(Loader)";
            // 
            // btnShp2Pgsql
            // 
            this.btnShp2Pgsql.Location = new System.Drawing.Point(53, 39);
            this.btnShp2Pgsql.Name = "btnShp2Pgsql";
            this.btnShp2Pgsql.Size = new System.Drawing.Size(137, 23);
            this.btnShp2Pgsql.TabIndex = 5;
            this.btnShp2Pgsql.Text = "Convert .shp 2 postGIS";
            this.btnShp2Pgsql.UseVisualStyleBackColor = true;
            this.btnShp2Pgsql.Click += new System.EventHandler(this.btnShp2Pgsql_Click);
            // 
            // groupBox4
            // 
            this.groupBox4.Controls.Add(this.label4);
            this.groupBox4.Controls.Add(this.lstAvailbeLayers);
            this.groupBox4.Controls.Add(this.btnPgsql2Shp);
            this.groupBox4.Enabled = false;
            this.groupBox4.Location = new System.Drawing.Point(278, 98);
            this.groupBox4.Name = "groupBox4";
            this.groupBox4.Size = new System.Drawing.Size(247, 186);
            this.groupBox4.TabIndex = 10;
            this.groupBox4.TabStop = false;
            this.groupBox4.Text = "PostGIS 2 Shape(Dumper)";
            // 
            // lstAvailbeLayers
            // 
            this.lstAvailbeLayers.FormattingEnabled = true;
            this.lstAvailbeLayers.Location = new System.Drawing.Point(6, 47);
            this.lstAvailbeLayers.Name = "lstAvailbeLayers";
            this.lstAvailbeLayers.Size = new System.Drawing.Size(234, 108);
            this.lstAvailbeLayers.TabIndex = 8;
            // 
            // btnPgsql2Shp
            // 
            this.btnPgsql2Shp.Location = new System.Drawing.Point(53, 158);
            this.btnPgsql2Shp.Name = "btnPgsql2Shp";
            this.btnPgsql2Shp.Size = new System.Drawing.Size(137, 23);
            this.btnPgsql2Shp.TabIndex = 5;
            this.btnPgsql2Shp.Text = "Convert postGIS 2 .shp";
            this.btnPgsql2Shp.UseVisualStyleBackColor = true;
            this.btnPgsql2Shp.Click += new System.EventHandler(this.btnPgsql2Shp_Click);
            // 
            // groupBox5
            // 
            this.groupBox5.Controls.Add(this.DB);
            this.groupBox5.Controls.Add(this.txtDB);
            this.groupBox5.Controls.Add(this.label8);
            this.groupBox5.Controls.Add(this.txtHost);
            this.groupBox5.Controls.Add(this.label7);
            this.groupBox5.Controls.Add(this.txtPort);
            this.groupBox5.Controls.Add(this.label6);
            this.groupBox5.Controls.Add(this.txtPass);
            this.groupBox5.Controls.Add(this.txtConnect);
            this.groupBox5.Controls.Add(this.label5);
            this.groupBox5.Controls.Add(this.txtUserName);
            this.groupBox5.Location = new System.Drawing.Point(13, 17);
            this.groupBox5.Name = "groupBox5";
            this.groupBox5.Size = new System.Drawing.Size(259, 153);
            this.groupBox5.TabIndex = 11;
            this.groupBox5.TabStop = false;
            this.groupBox5.Text = "Login to postgreSQL";
            // 
            // DB
            // 
            this.DB.AutoSize = true;
            this.DB.Location = new System.Drawing.Point(12, 107);
            this.DB.Name = "DB";
            this.DB.Size = new System.Drawing.Size(83, 13);
            this.DB.TabIndex = 15;
            this.DB.Text = "Database Name";
            // 
            // txtDB
            // 
            this.txtDB.Location = new System.Drawing.Point(130, 104);
            this.txtDB.Name = "txtDB";
            this.txtDB.Size = new System.Drawing.Size(100, 20);
            this.txtDB.TabIndex = 14;
            // 
            // label8
            // 
            this.label8.AutoSize = true;
            this.label8.Location = new System.Drawing.Point(14, 19);
            this.label8.Name = "label8";
            this.label8.Size = new System.Drawing.Size(72, 13);
            this.label8.TabIndex = 13;
            this.label8.Text = "Host name/IP";
            // 
            // txtHost
            // 
            this.txtHost.Location = new System.Drawing.Point(129, 11);
            this.txtHost.Name = "txtHost";
            this.txtHost.Size = new System.Drawing.Size(100, 20);
            this.txtHost.TabIndex = 12;
            // 
            // label7
            // 
            this.label7.AutoSize = true;
            this.label7.Location = new System.Drawing.Point(14, 41);
            this.label7.Name = "label7";
            this.label7.Size = new System.Drawing.Size(27, 13);
            this.label7.TabIndex = 11;
            this.label7.Text = "Port";
            // 
            // txtPort
            // 
            this.txtPort.Location = new System.Drawing.Point(129, 34);
            this.txtPort.Name = "txtPort";
            this.txtPort.Size = new System.Drawing.Size(100, 20);
            this.txtPort.TabIndex = 10;
            // 
            // label6
            // 
            this.label6.AutoSize = true;
            this.label6.Location = new System.Drawing.Point(11, 86);
            this.label6.Name = "label6";
            this.label6.Size = new System.Drawing.Size(53, 13);
            this.label6.TabIndex = 9;
            this.label6.Text = "Password";
            // 
            // txtPass
            // 
            this.txtPass.Location = new System.Drawing.Point(130, 81);
            this.txtPass.Name = "txtPass";
            this.txtPass.Size = new System.Drawing.Size(100, 20);
            this.txtPass.TabIndex = 8;
            // 
            // txtConnect
            // 
            this.txtConnect.Location = new System.Drawing.Point(50, 126);
            this.txtConnect.Name = "txtConnect";
            this.txtConnect.Size = new System.Drawing.Size(137, 23);
            this.txtConnect.TabIndex = 5;
            this.txtConnect.Text = "Connect";
            this.txtConnect.UseVisualStyleBackColor = true;
            this.txtConnect.Click += new System.EventHandler(this.txtLogin_Click);
            // 
            // label5
            // 
            this.label5.AutoSize = true;
            this.label5.Location = new System.Drawing.Point(12, 64);
            this.label5.Name = "label5";
            this.label5.Size = new System.Drawing.Size(55, 13);
            this.label5.TabIndex = 6;
            this.label5.Text = "Username";
            // 
            // txtUserName
            // 
            this.txtUserName.Location = new System.Drawing.Point(130, 57);
            this.txtUserName.Name = "txtUserName";
            this.txtUserName.Size = new System.Drawing.Size(100, 20);
            this.txtUserName.TabIndex = 7;
            // 
            // label1
            // 
            this.label1.AutoSize = true;
            this.label1.ForeColor = System.Drawing.Color.Red;
            this.label1.Location = new System.Drawing.Point(10, 20);
            this.label1.Name = "label1";
            this.label1.Size = new System.Drawing.Size(221, 13);
            this.label1.TabIndex = 6;
            this.label1.Text = "You can create .backup file from PostgreSQL";
            // 
            // label2
            // 
            this.label2.AutoSize = true;
            this.label2.ForeColor = System.Drawing.Color.Red;
            this.label2.Location = new System.Drawing.Point(16, 65);
            this.label2.Name = "label2";
            this.label2.Size = new System.Drawing.Size(223, 13);
            this.label2.TabIndex = 7;
            this.label2.Text = "You can load your .backup file to PostgreSQL";
            // 
            // label3
            // 
            this.label3.AutoSize = true;
            this.label3.ForeColor = System.Drawing.Color.Red;
            this.label3.Location = new System.Drawing.Point(11, 18);
            this.label3.Name = "label3";
            this.label3.Size = new System.Drawing.Size(171, 13);
            this.label3.TabIndex = 8;
            this.label3.Text = "You can load shape file to PostGIS";
            // 
            // label4
            // 
            this.label4.AutoSize = true;
            this.label4.ForeColor = System.Drawing.Color.Red;
            this.label4.Location = new System.Drawing.Point(10, 23);
            this.label4.Name = "label4";
            this.label4.Size = new System.Drawing.Size(210, 13);
            this.label4.TabIndex = 9;
            this.label4.Text = "You can create shape file from PostGIS DB";
            // 
            // Form1
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.ClientSize = new System.Drawing.Size(535, 319);
            this.Controls.Add(this.groupBox5);
            this.Controls.Add(this.groupBox4);
            this.Controls.Add(this.groupBox3);
            this.Controls.Add(this.groupBox1);
            this.Controls.Add(this.statusStrip1);
            this.Name = "Form1";
            this.Text = "PostgreSql Thaboot";
            this.statusStrip1.ResumeLayout(false);
            this.statusStrip1.PerformLayout();
            this.groupBox1.ResumeLayout(false);
            this.groupBox1.PerformLayout();
            this.groupBox3.ResumeLayout(false);
            this.groupBox3.PerformLayout();
            this.groupBox4.ResumeLayout(false);
            this.groupBox4.PerformLayout();
            this.groupBox5.ResumeLayout(false);
            this.groupBox5.PerformLayout();
            this.ResumeLayout(false);
            this.PerformLayout();

        }

        #endregion

        private System.Windows.Forms.Button btnCreateBackup;
        private System.Windows.Forms.StatusStrip statusStrip1;
        private System.Windows.Forms.ToolStripStatusLabel toolStripStatusLabel1;
        private System.Windows.Forms.GroupBox groupBox1;
        private System.Windows.Forms.Button btnRestoreDB;
        private System.Windows.Forms.GroupBox groupBox3;
        private System.Windows.Forms.Button btnShp2Pgsql;
        private System.Windows.Forms.GroupBox groupBox4;
        private System.Windows.Forms.Button btnPgsql2Shp;
        private System.Windows.Forms.ListBox lstAvailbeLayers;
        private System.Windows.Forms.GroupBox groupBox5;
        private System.Windows.Forms.Button txtConnect;
        private System.Windows.Forms.Label label5;
        private System.Windows.Forms.TextBox txtUserName;
        private System.Windows.Forms.Label label6;
        private System.Windows.Forms.TextBox txtPass;
        private System.Windows.Forms.Label label7;
        private System.Windows.Forms.TextBox txtPort;
        private System.Windows.Forms.Label label8;
        private System.Windows.Forms.TextBox txtHost;
        private System.Windows.Forms.Label DB;
        private System.Windows.Forms.TextBox txtDB;
        private System.Windows.Forms.Label label1;
        private System.Windows.Forms.Label label2;
        private System.Windows.Forms.Label label3;
        private System.Windows.Forms.Label label4;
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Thabet Tech
Web Developer HP Enterprise Services , Egypt
Egypt Egypt
My name is Mohammed Thabet Zaky
I have graduated from faculty of Computer & Information system at Helwan Universty since 2007
I worked as GIS developer and .Net developer since Feb-2009 until now
Follow on   Twitter

| Advertise | Privacy | Mobile
Web01 | 2.8.140721.1 | Last Updated 11 Jun 2009
Article Copyright 2009 by Thabet Tech
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid