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 > > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
