Обсуждение: What is default password for user postgres
Hi all,
I installed version 9.1 in my Ubuntu OS, but not able to login.
What is default password for user Postgres?
Regards
Tarkeshwar
On 1 December 2014 at 09:08, M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com> wrote:
Hi all,
I installed version 9.1 in my Ubuntu OS, but not able to login.
What is default password for user Postgres?
The postgres user doesn't have a password by default, which is probably how you should keep it. Typically the pg_hba.conf file (which you'll find in /etc/postgresql/9.1/main/pg_hba.conf) contains an entry like:
local all all trust
So reading from left to right, this allows local connections to all databases for all users using trust authentication, meaning it will believe you're the postgres user if you say you are, and can be trusted, as long as you're connecting over a local connection (i.e. using a unix domain socket). So become the postgres user:
sudo su - postgres
sudo su - postgres
and then you should just be able to connect to the database without any issues:
postgres@swift:~$ psql postgres postgres
psql (9.3.1)
Type "help" for help.
postgres@swift:~$ psql postgres postgres
psql (9.3.1)
Type "help" for help.
Regards
Thom
On 12/01/2014 02:30 AM, Thom Brown wrote: > On 1 December 2014 at 09:08, M Tarkeshwar Rao > <m.tarkeshwar.rao@ericsson.com <mailto:m.tarkeshwar.rao@ericsson.com>> > wrote: > > Hi all,____ > > __ __ > > I installed version 9.1 in my Ubuntu OS, but not able to login.____ > > What is default password for user Postgres? > > > The postgres user doesn't have a password by default, which is probably > how you should keep it. Typically the pg_hba.conf file (which you'll > find in /etc/postgresql/9.1/main/pg_hba.conf) contains an entry like: > > local all all trust Actually my experience is that it is set to: local all postgres peer > > So reading from left to right, this allows local connections to all > databases for all users using trust authentication, meaning it will > believe you're the postgres user if you say you are, and can be trusted, > as long as you're connecting over a local connection (i.e. using a unix > domain socket). So become the postgres user: Also there is only a postgres system user created with no login shell. From Ubuntu: https://help.ubuntu.com/community/PostgreSQL Basic Server Setup To start off, we need to change the PostgreSQL postgres user password; we will not be able to access the server otherwise. As the “postgres” Linux user, we will execute the psql command. In a terminal, type: sudo -u postgres psql postgres Set a password for the "postgres" database role using the command: \password postgres and give your password when prompted. The password text will be hidden from the console for security purposes. > > sudo su - postgres > > and then you should just be able to connect to the database without any > issues: > > postgres@swift:~$ psql postgres postgres > psql (9.3.1) > Type "help" for help. > > Regards > > Thom -- Adrian Klaver adrian.klaver@aklaver.com