Connect to PostgreSql as Postgres user (default database user):
psql yourdb -U Postgres
then you will be asked for password selected during the installation.
Hope this will help.
JB
- Original Message -
From: Suresh Nimbalkar
To: pgsql-general@postgresql.org
Sent: Tuesday, M
On Tue, Jun 07, 2005 at 11:17:52AM -0400, Robert Fitzpatrick wrote:
>
> I have a database that is used every day for the past year and all of a
> sudden, this morning, I get a report that a user cannot login. I have
> doubled checked the pg_hba.conf file, which has not been changed in
> several mon
Doug McNaught <[EMAIL PROTECTED]> writes:
> "Manu M P" <[EMAIL PROTECTED]> writes:
>> I then created the "passwords" file in $PGDATA using pg_pasword and
>> added entries for the two users "test1" and "test2".
> I've never heard of a 'pg_password' program and it is not part of the
> standard distr
"Manu M P" <[EMAIL PROTECTED]> writes:
> Hi
>
> I have the data base "test" and two users "test1" "test2". I added the following
> record to pg_hba.conf
>
> local test password passwords
>
> I then created the "passwords" file in $PGDATA using pg_pasword and
> added entries for the two users "tes
Phuong Ma wrote:
>Hi,
>
> I was wondering what the different methods of creating a password
>accomplish because I created a password for a test user using the
>command WITH PASSWORD. I tried testing to see if I could log on without
>a password, and it worked. Is there anything else
