Re: [ADMIN] Trouble with postgres user's password on Windows

2009-08-26 Thread Jan-Peter Seifert
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? Everybod

Re: [ADMIN] Trouble with postgres user's password on Windows

2009-08-26 Thread Oliveiros
Thanks for the tips, Jan-Peter. 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 worki

Re: [ADMIN] Trouble with postgres user's password on Windows

2009-08-20 Thread Jan-Peter Seifert
Oliveiros wrote: > 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 pro

[ADMIN] Trouble with postgres user's password on Windows

2009-08-20 Thread Oliveiros
Dear List, This is my first post, I hope I am asking it on the correct list. I changed the password for user postgres and I completely forgot about the previous one. The main problem is that now the postgres server fails to start when I turn on the machine. It used to start automatically. To s