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
change postgresql root password
under ubuntu it is very easy to change postgresql database root password:
su -
su – postgres
psql -d template1
template1=# ALTER USER postgres WITH PASSWORD ‘NEW_PASSWORD’;
\q