Re: password for postgres

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: Kusuma Pabba <kusumap(at)ncoretech(dot)com>
Subject: Re: password for postgres
Date: 2009-02-15 06:07:32
Message-ID: 4997B124.1030208@compulab.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Herouth Maoz 2009-02-15 09:48:42 Re: Slow update
Previous Message Fernando Moreno 2009-02-15 05:05:32 Re: Array in nested query