how to install PostgreSQL on ubuntu

1. This installs the database server/client,some extra utility scripts and the pgAdmin GUI application for working with the database.

$ sudo apt-get install postgresql postgresql-client postgresql-contrib
$ sudo apt-get install pgadmin3

2. Now we need to reset the password for the ‘postgres’ admin account for the server,substitute in the password you want to use for your administrator account.

$ sudo su postgres -c psql template1
template1=# ALTER USER postgres WITH PASSWORD 'password';
template1=# \q

3. That alters the password for within the database,now we need to do the same for the unix user ‘postgres’.

$ sudo passwd -d postgres
$ sudo su postgres -c passwd

4. Set-up the Postgresql admin pack that enables better logging and monitoring within pgAdmin.

$ sudo su postgres -c psql < /usr/share/postgresql/9.1/extension/adminpack--1.0.sql

5. Edit the postgresql.conf file.

$ sudo gedit /etc/postgresql/9.1/main/postgresql.conf

Change the line:
#listen_addresses = 'localhost'
to
listen_addresses = '*'
and also change the line:
#password_encryption = on
to
password_encryption = on

6. Define who can access the server. This is all done using the pg_hba.conf.

$ sudo gedit /etc/postgresql/8.3/main/pg_hba.conf

add this text to the bottom of the file:
host all all [ip address] [subnet mask] md5
add in your subnet mask (i.e. 255.255.255.0) and the IP address of your server (i.e. 138.250.192.115).
Note:if you have some password error,please change all "md5" to "trust" in this file.

7. Now all you have to do is restart the server.

$ sudo /etc/init.d/postgresql restart

Reference:
http://hocuspokus.net/2008/05/install-postgresql-on-ubuntu-804/

相关文章

来源:http://www.postgres.cn/docs/11/ 4.1.1.&#160;标识符和关键词 SQL标识符和关键词必须以一个...
来源:http://www.postgres.cn/docs/11/ 8.1.&#160;数字类型 数字类型由2、4或8字节的整数以及4或8...
来源:http://www.postgres.cn/docs/11/ 5.1.&#160;表基础 SQL并不保证表中行的顺序。当一个表被读...
来源:http://www.postgres.cn/docs/11/ 6.4.&#160;从修改的行中返回数据 有时在修改行的操作过程中...
来源:http://www.postgres.cn/docs/11/ 13.2.1.&#160;读已提交隔离级别 读已提交是PostgreSQL中的...
来源:http://www.postgres.cn/docs/11/ 9.7.&#160;模式匹配 PostgreSQL提供了三种独立的实现模式匹...