--000325554892683591047190cc12
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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 start it, I have to login as postgres and manually start it with postgres
-D etc.

Also, on PGAdmin ||| I cannot log in as administrator user , no longer. Even
the new password doesn't seem to work...

Can anyone please kindly help me on this issue?

I'd really appreciate it

Thanks a million in advance,
Best,
Oliveiros

--000325554892683591047190cc12
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Dear List,<br><br>This is my first post, I hope I am asking it on the corre=
ct list.<br><br>I changed the password for user postgres and I completely f=
orgot about the previous one.<br><br>The main problem is that now the postg=
res server fails to start when I turn on the machine.<br>
<br>It used to start automatically.<br><br>To start it, I have to login as =
postgres and manually start it with postgres -D etc.<br><br>Also, on PGAdmi=
n ||| I cannot log in as administrator user , no longer. Even the new passw=
ord doesn't seem to work...<br>
<br>Can anyone please kindly help me on this issue?<br><br>I'd really a=
ppreciate it<br><br>Thanks a million in advance,<br>Best,<br>Oliveiros<br>

--000325554892683591047190cc12--

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 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-c onf.html

Don't forget to change the auth-option back.

Good luck,

Peter

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--00032555472a9c50eb04720d03d8
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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 working smoothly now.

Again, Thank you a million,

Best,
Oliveiros


2009/8/21 Jan-Peter Seifert <Jan-Peter.Seifert [at] gmx.de>

> 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 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-c onf.html
>
> Don't forget to change the auth-option back.
>
> Good luck,
>
> Peter
>

--00032555472a9c50eb04720d03d8
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Thanks for the tips, Jan-Peter.<br><br>I backed up the db, but fortunately,=
there was n't any problem.<br><br>I 've once edited the hba file, =
but it was to allow remote connections, I<br>didn't know it could be us=
ed to allow "trust" connections. Learned <br>
many things from the links you sent me.<br><br>Everything is working smooth=
ly now.<br><br>Again, Thank you a million,<br><br>Best,<br>Oliveiros<br><br=
><br><div class=3D"gmail_quote">2009/8/21 Jan-Peter Seifert <span dir=3D"lt=
r"><<a href=3D"mailto:Jan-Peter.Seifert [at] gmx.de">Jan-Peter.Seifert [at] gmx.de=
</a>></span><br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class=3D"im"=
>Oliveiros wrote:<br>
<br>
> To start it, I have to login as postgres and manually start it with<br=
>
> postgres -D etc.<br>
<br>
</div>You should make a backup first (users and databases ...) .<br>
Try unregistering/registering the service with pg_ctl.<br>
First copy the pg_ctl command used during installation from the<br>
service's properties. You get the service overview with executing the<b=
r>
command "services.msc".<br>
<div class=3D"im"><br>
> Also, on PGAdmin ||| I cannot log in as administrator user , no longer=
..<br>
> Even the new password doesn't seem to work...<br>
<br>
</div>Did you save the password in the past? Check the pgpass file which is=
<br>
usually located within the current windows user's Home directory:<br>
<a href=3D"http://www.postgresql.org/docs/8.3/interactive/libpq-pgpass.html=
" target=3D"_blank">http://www.postgresql.org/docs/8.3/interac tive/libpq-pg=
pass.html</a><br>
<br>
Or change the auth-method in pg_hba.conf to trust and reset the password(s)=
:<br>
<a href=3D"http://www.postgresql.org/docs/8.3/interactive/auth-pg-hba-conf.=
html" target=3D"_blank">http://www.postgresql.org/docs/8.3/interac tive/auth=
-pg-hba-conf.html</a><br>
<br>
Don't forget to change the auth-option back.<br>
<br>
Good luck,<br>
<font color=3D"#888888"><br>
Peter<br>
</font></blockquote></div><br>

--00032555472a9c50eb04720d03d8--

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-c onf.html
>
> Don't forget to change the auth-option back.
>
> Good luck,
>
> Peter
>
>

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin