Re: Trouble with postgres user's password on Windows

Hello Oliveiros,

I'm glad that your server is working smoothly now.

> 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.

Do you still have trust enabled? Everybody who can logon to a system
whose ip address is matched by the 'trust'-entry and listen_addresses in
postgresql.conf could logon to your PostgreSQL server then - if there's
no more restriction (firewall etc.). So you should restrict it to the
server machine or totally switch it off if you haven't already.

I forgot this link:
http://www.postgresql.org/docs/8.3/static/app-pg-ctl.html

Under windows you have to specify the password for the
Windows-postgres-user when registering the server as a service ...

regards,

Peter

> > To start it, I have to login as postgres and manually start it with
> > postgres -D etc.
>
> You should make a backup first (users and databases ...) .
> 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".
>
> > Also, on PGAdmin ||| I cannot log in as administrator user , no
> longer.
> > Even the new password doesn't seem to work...
>
> Did you save the password in the past? Check the pgpass file which is
> 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
>
>