On 2009-02-13, Kusuma Pabba wrote:
> i don't know y am i getting this problem
>
> when i try to start off postgres
> it asks me for password:
what OS.
what command are you using?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:
-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 USE
On Friday 13 February 2009 2:18:32 am Kusuma Pabba wrote:
> i don't know y am i getting this problem
>
> when i try to start off postgres
> it asks me for password:
Are trying to start the Postgres program or are you trying to connect to an
already running server?
>
>
> i did not set any passwo
Kindly let me know two things to answer you. First, Are you trying to start
postgres service or psql prompt? second, what OS is in your use.
The command goes through fine, but the next time I log into postgres using
the command,
>>psql mydb postgres
>>it logs in, and doesnt ask me for a password at all. If I issue a command
like,
This is because you have trust in pg_hba.conf file, change it to md5 so it
asks for password every time y
