Saturday, 27 June 2009

Adding local postgres database to PgAdmin in ubuntu

Synaptic makes both (posgres & pgadmin) installations trivial. After installation you must change password of 'postgres' user:
sudo -u postgres psql postgres
ALTER USER postgres WITH PASSWORD 'secret';
\q
Now add local database in PgAdmin, which shouldn't cause any problems.

No comments:

Post a Comment