Postgres Pro
Downloads
Home   >   mailing lists

Thread: postmaster won't start under cygwin after password change

postmaster won't start under cygwin after password change

From
Bill Harris
Date:
I asked on cygwin but no answer yet; maybe someone here knows.

I've been running PostgreSQL 7.4.1 successfully for a few weeks under an
updated cygwin, but it stopped working over the weekend.  That happened
to be the time XP Pro decided my postgres password should expire.  I
gave it a new password, as requested, but postmaster still won't start.
ipc-daemon2.exe is running.

When I tried to start the postmaster as postgres and not as a service
using

postmaster -D /var/postgresql/data

I got

LOG: shmdt(0xf90000) failed: invalid argument
LOG: database system was shut down at 2004-03-21 09:04:56 PST
LOG: checkpoint record is at 0/1DB0E00
LOG: redo record is at 0/1DB0E00; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 3987; next OID: 18937
LOG: database system is ready

but when I try cygrunsrv -S postmaster

I get a Windows error 5 (logon).

Suggestions?  I do have a backup of the database, so I guess I could
start over.  I guess I'm trying to figure out where to start in
/cygwin/usr/share/doc/Cygwin/postgresql-7.4.1.README.

Thanks,

Bill

Re: postmaster won't start under cygwin after password change

From
Bill Harris
Date:
Bill Harris <bill_harris@facilitatedsystems.com> writes:

> I asked on cygwin but no answer yet; maybe someone here knows.
>
> I've been running PostgreSQL 7.4.1 successfully for a few weeks under an
> updated cygwin, but it stopped working over the weekend.  That happened
> to be the time XP Pro decided my postgres password should expire.  I
> gave it a new password, as requested, but postmaster still won't start.
> ipc-daemon2.exe is running.

This is now an item of mostly intellectual curiousity, for I reset my
password to the old value and told XP to leave it alone, and it again
works (duh!).

Bill
--
Bill Harris                                  3217 102nd Place SE
Facilitated Systems                          Everett, WA 98208 USA
http://facilitatedsystems.com/               phone: +1 425 337-5541

Re: postmaster won't start under cygwin after password change

From
Shelby Cain
Date:
You have to update the credentials stored in the
service configuration.

Start->Run->services.msc->[service name]->Logon

Regards,

Shelby Cain


--- Bill Harris <bill_harris@facilitatedsystems.com>
wrote:
> I asked on cygwin but no answer yet; maybe someone
> here knows.
>
> I've been running PostgreSQL 7.4.1 successfully for
> a few weeks under an
> updated cygwin, but it stopped working over the
> weekend.  That happened
> to be the time XP Pro decided my postgres password
> should expire.  I
> gave it a new password, as requested, but postmaster
> still won't start.
> ipc-daemon2.exe is running.
>
> When I tried to start the postmaster as postgres and
> not as a service
> using
>
> postmaster -D /var/postgresql/data
>
> I got
>
> LOG: shmdt(0xf90000) failed: invalid argument
> LOG: database system was shut down at 2004-03-21
> 09:04:56 PST
> LOG: checkpoint record is at 0/1DB0E00
> LOG: redo record is at 0/1DB0E00; undo record is at
> 0/0; shutdown TRUE
> LOG: next transaction ID: 3987; next OID: 18937
> LOG: database system is ready
>
> but when I try cygrunsrv -S postmaster
>
> I get a Windows error 5 (logon).
>
> Suggestions?  I do have a backup of the database, so
> I guess I could
> start over.  I guess I'm trying to figure out where
> to start in
>
/cygwin/usr/share/doc/Cygwin/postgresql-7.4.1.README.
>
>
> Thanks,
>
> Bill
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)


__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html