Showing posts with label pgadmin. Show all posts
Showing posts with label pgadmin. Show all posts

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.