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.
i don't know y am i getting this problem
when i try to start off postgres
it asks me for password:
i did not set any password as such
except that when the first day i used template, i ahve used the below
two statements
ALTER USER postgres with encrypted password 'your_password';
ALTER USER
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
Hi all,
I am using a postgres database, and want to set a password for the account.
The default user name is 'postgres' and in order to set a password, I did an
alter user as below,
alter user postgres with password 'mypwd';
The command goes through fine, but the next time I log
