Re: password for postgres - Mailing list pgsql-general

From Sim Zacks
Subject Re: password for postgres
Date
Msg-id 4997B124.1030208@compulab.co.il
Whole thread Raw
In response to password for postgres  (Kusuma Pabba <kusumap@ncoretech.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You do not want to use the keyword encrypted.
To get in, go to your pg_hba file and set the security level to trust
for your account. Then go in as postgres without a password and change
it by:
alter role postgres with password 'welcome';


> ALTER USER postgres with encrypted password 'your_password';
> ALTER USER postgres with encrypted password 'welcome';
>
> but it is not accepting both the passwords
> i am getting incorrect password after three trials it is returning back
> to command prompt

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkmXsSQACgkQjDX6szCBa+poGACgxKo0aHk+7+XzsdlOLVnPD0zY
aJ8An0ArIlUvz19M3um4HS7wS1BW6ZC3
=sbx/
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Fernando Moreno
Date:
Subject: Re: Array in nested query
Next
From: Herouth Maoz
Date:
Subject: Re: Slow update