PostgreSQL understanding, Installation and Use

Detailed analysis of postgresql yesterday today and tomorrow http://database.51cto.com/art/200708/53762.htm

Evaluate the advantages and disadvantages of MySQL and PostgreSQL http://database.51cto.com/art/200612/36844.htm

PostgreSQL installation and easy to use http://www.linuxsir.org/main/node/275? Q = node/275 #2.1

Http://wiki.ubuntu.org.cn/PostgreSQL

PostgreSQL Chinese Document http://www.pgsqldb.org/pgsqldoc-8.1c/

 

1.InstallSudo apt-Get install postgresql-8.4

2. After the installation is complete, a post Administrator account named Postgres will be automatically generated. You need to set a password for it: passwd Postgres

3. Log On with the Postgres account: su Postgres

4. Service Startup:/etc/init. d/postgresql-8.2Start/Stop/restart/Status (Status)

5. Create and delete databases: Create Database

DROP DATABASE

6. Connect to the database: Psql dbname

When connecting: \ c dbname (switch to another database)

7.Exit\ Q exit

 

You can also use this graphic interface pgadmin3

1. Install: sudo apt-Get install pgadmin3

2. Start: pgadmin3