install postgresql 8.2 under ubuntu with adminpack

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

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

About these ads

Entry filed under: database. Tags: .

otrs ticket system installation under ubuntu hold your mac up to date with AppFresh

1 Comment Add your own

  • 1. KrusjMe  |  Monday, 26 December 2011 at 00:30 UTC

    Thanx. That was helpful!

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


Categories


Follow

Get every new post delivered to your Inbox.

%d bloggers like this: