how to install PostgreSQL on ubuntu

前端之家收集整理的这篇文章主要介绍了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/

原文链接:https://www.f2er.com/postgresql/196309.html

猜你在找的Postgre SQL相关文章