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
