hello 2009/8/26 Anze Cevka <anzece...@hotmail.com>: > Hello! > > I am wondering where can I found out what is my postgre SQL password, > because I forgot it. >
you have to add line to pg_hba.conf file for postgresql user. from local change authentication method to trust (attention - from this moment, your database is unsecured!!!). Reload, then you can login to database as postgres - password will be ignored. execute SQL: ALTER USER postgres PASSWORD 'newpaswd'; change authentication back for local (ident or md5)!!!! reload regards Pavel Stehule > Thanks for your help. > > Best regards > > Anze > > ________________________________ > Share your memories online with anyone you want anyone you want. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
