Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postmaster Service Fails

Postmaster Service Fails

From
Mary-Catherine Gerrey
Date:

Let me preface this with I am, in a sense, new to the *nix ways of the world; I left most of that back in college .  And server administration is not my forte either.  I am trying to install and set up Postgre on my Win2k server.  I got the latest version of things, and the cygpic zip file installed as well.  I updated the path in Windows, got the postgre user created and it has ownership of the data directory.  Both the ipc-daemon and postmaster service are there and the ipc-daemon service seems to work fine.  The initialized data directory seems to be happy too.

But that is about as far as it gets.  For the life of me I can't get the postmaster service to run, under any user.  Below is a cygwin piece of things:

$ postmaster -D /usr/share/postgresql/data
LOG:  database system was shut down at 2003-03-01 17:52:28 EST
LOG:  checkpoint record is at 0/83B1A8
LOG:  redo record is at 0/83B1A8; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 480; next oid: 16976
LOG:  database system is ready
LOG:  statistics collector process (pid 2196) exited with exit code 1
LOG:  statistics collector process (pid 2240) exited with exit code 1
LOG:  statistics collector process (pid 272) exited with exit code 1
LOG:  statistics collector process (pid 2212) exited with exit code 1

So I tried it again.....

$ postmaster -D /usr/share/postgresql/data
LOG:  database system was interrupted at 2003-03-01 18:47:19 EST
LOG:  checkpoint record is at 0/83B1A8
LOG:  redo record is at 0/83B1A8; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 480; next oid: 16976
LOG:  database system was not properly shut down; automatic recovery in progress

LOG:  ReadRecord: record with zero length at 0/83B1E8
LOG:  redo is not required
LOG:  database system is ready

Yes, it says it was shut down, 3 postgre.exe processes were created when I ran this (is this normal??) and it just seemed to sit there for a long time, so I gave up on it.  I closed one of the processes and it closed all 3.

If I try to start things from the Windows, I get the error:

The service did not return an error.This could be an internal Windows error or an internal services error. 

I am at a loss at this point.  I've read posts and docs and am not sure what to try next.  Any ideas would be wonderful!

TIA,

Mary-Catherine Gerrey


Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more