first install python-software-properties:
sudo apt-get install python-software-properties
now add repository and update apt.
sudo add-apt-repository ppa:pitti/postgresql
sudo apt-get update
now instal postgresql
sudo apt-get install postgresql-9.1 libpq-dev
Now change the postgres user password (still running as root):
su postgres
psql -d postgres -U postgres
alter user postgres with password 'a';
\q
To install GUI client pgsql
sudo apt-get install pgadmin3
sudo apt-get install python-software-properties
now add repository and update apt.
sudo add-apt-repository ppa:pitti/postgresql
sudo apt-get update
now instal postgresql
sudo apt-get install postgresql-9.1 libpq-dev
Now change the postgres user password (still running as root):
su postgres
psql -d postgres -U postgres
alter user postgres with password 'a';
\q
To install GUI client pgsql
sudo apt-get install pgadmin3
wanted to thank you for posting this. worked like a charm
ReplyDeleteSomehow still asking for password for postgres but does not accept any password, maybe it is still somewhere as some default password.
ReplyDeleteThere are two passwords for user postgres, one for the database and one for the system in general. If you don't change the default authentication mode in pg_hba.conf you always have to be the postgres user to be able to connect to the database. Or you could pass in the command line argument to ask for the password, I think is -w.
DeleteThis comment has been removed by the author.
DeleteThanks a lot, this helped me >]
ReplyDeleteVery handy - cheers mate :-)
ReplyDeleteThanks a lot. :)
ReplyDeleteThanks a lot ....really really help me
ReplyDeleteСпасибо, друг!
ReplyDeleteThanks a lot. very useful post
ReplyDelete