I backed up the db, but fortunately, there was n't any problem.
I 've once edited the hba file, but it was to allow remote connections, I
didn't know it could be used to allow "trust" connections. Learned
many things from the links you sent me.
Everything is working smoothly now.
Again, Thank you a million,
Best,
Oliveiros
2009/8/21 Jan-Peter Seifert <Jan-Peter.Seifert@xxxxxx>
Oliveiros wrote:You should make a backup first (users and databases ...) .
> To start it, I have to login as postgres and manually start it with
> postgres -D etc.
Try unregistering/registering the service with pg_ctl.
First copy the pg_ctl command used during installation from the
service's properties. You get the service overview with executing the
command "services.msc".
Did you save the password in the past? Check the pgpass file which is
> Also, on PGAdmin ||| I cannot log in as administrator user , no longer.
> Even the new password doesn't seem to work...
usually located within the current windows user's Home directory:
http://www.postgresql.org/docs/8.3/interactive/libpq-pgpass.html
Or change the auth-method in pg_hba.conf to trust and reset the password(s):
http://www.postgresql.org/docs/8.3/interactive/auth-pg-hba-conf.html
Don't forget to change the auth-option back.
Good luck,
Peter
