Postmaster Service Fails

From: Mary-Catherine Gerrey <mcgerrey(at)yahoo(dot)com>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Postmaster Service Fails
Date: 2003-03-02 00:37:07
Message-ID: 20030302003707.53571.qmail@web41401.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin


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

Browse pgsql-cygwin by date

  From Date Subject
Next Message Nyo Maw 2003-03-02 08:45:12 unexpected protocol charactor during authentication
Previous Message laurenm1 2003-02-27 09:41:55 Re: Need Postgre 7.1.2