Re: Not Finding password for Postgres user on linux

From: Dmitry Alyabyev <dimitry(at)al(dot)org(dot)ua>
To: "Nandu Garg" <focussed(at)rediffmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Not Finding password for Postgres user on linux
Date: 2002-01-24 08:19:26
Message-ID: 4048440659.20020124101926@al.org.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thursday, January 24, 2002, 9:13:22 AM, Nandu Garg wrote:

> Hi All

> I have just now got the Postgresql installed again. But again before connecting it it requires me to connect to Postgres user. Now how could I get connected. There is nothing mentioned in Postgre
> documentation about the default password. Is the password allocated dynamically?
> My linux administrator says he could not find the password. Do I have to create a new user where it's group is pg_database or what?

Take a look at data/pg_hba.conf file.
By default postgres allow connect without password for user 'postgres'
so you can type: psql -U postgres template1

--
Dimitry

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2002-01-24 08:52:29 Re: postgresql 7.2b5 and vserver: statistics sockets
Previous Message Holger Krug 2002-01-24 08:15:40 Re: Not Finding password for Postgres user on Linux