Posts filed under ‘database’

install postgresql 8.2 under ubuntu with adminpack

1. basic installation of postgresql server (contrib is needed for adminpack)

apt-get install postgresql postgresql-contrib

2. optional install pdadmin GUI

apt-get install pgadmin3

3. Now reset the password for the ‘postgres’ admin account for the server:

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

4. now change the password for the unix user ‘postgres’:

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

5. install adminpack
Before you use pgAdmin you should setup the PostgreSQL adminpack that enables better logging and monitoring within pgAdmin:

$ sudo su postgres -c psql < /usr/share/postgresql/8.2/contrib/adminpack.sql

Tuesday, 24 June 2008 at 16:00 UTC 1 comment

change postgresql root password

under ubuntu it is very easy to change postgresql database root password:

su -

su – postgres

psql  -d template1



Monday, 23 June 2008 at 13:12 UTC 3 comments