Skip site navigation (1) Skip section navigation (2)

[newbie] Postmaster service on W2K

From: Terry Branscombe <tbransco(at)telus(dot)net>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: [newbie] Postmaster service on W2K
Date: 2004-09-05 06:42:53
Message-ID: 413AB56D.5080207@telus.net (view raw or flat)
Thread:
Lists: pgsql-cygwin
Hi,

I'm new to PostgreSQL and the list so please bear with me a bit.

I want to install PG as a service on my W2K system running the latest 
Cygwin packages and have run up against some problems.  I followed the 
instructions in the /usr/share/doc/Cygwin/postgresql-7.4.5.README file 
to install the service and adjusted a few things to suit my setup.  
Here's the command I used to install the service:

cygrunsrv -I postmaster -p /usr/bin/postmaster -d "CYGWIN postmaster" \
-f "PostgreSQL server" -t manual -u postgres -y cygserver \
-a "-D /var/postgresql/data -i" -s INT -o -1 /var/log/postmaster.log \
-2 /var/log/postmaster.err

I'm not sure if I'm seeing the expected results: I have three 'postgres' 
processes running under the 'postgres' account, an error in the Windows 
Event Viewer console, and a 'postmaster' service that is not listed as 
'started' in the Windows Services console even though I can connect with 
the newly created Template1 database with PgAdmin III for Windows.

The 'postgres' processes appear like this:

$ ps -eaf | grep postgres
     UID     PID    PPID TTY     STIME COMMAND
postgres    2268    2296   ?  20:48:13 /usr/bin/postgres
postgres    2264    2268   ?  20:48:14 /usr/bin/postgres
postgres    1552    2264   ?  20:48:14 /usr/bin/postgres


The error logged in the Event Viewer is:
-----------------------------------------------------------------
System Log:

Event Type:    Error
Event Source:    Service Control Manager
Event Category:    None
Event ID:    7031
Date:        02/09/2004
Time:        8:47:14 PM
User:        N/A
Computer:    KIRALY
Description:
The postmaster service terminated unexpectedly.  It has done this 1 
time(s).  The following corrective action will be taken in 0 
milliseconds: No action.
-----------------------------------------------------------------

In the /var/log/postmaster.log file, I see the following errors:

-----------------------------------------------------------------
WARNING:  dup(0) failed after 3195 successes: Bad file descriptor
LOG:  database system was shut down at 2004-09-04 18:58:21 PDT
LOG:  checkpoint record is at 0/9E4758
LOG:  redo record is at 0/9E4758; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 898; next OID: 17148
LOG:  database system is read
-----------------------------------------------------------------

 >From other posts in this and other lists all the above points to 
misconfigured file permissions, so I've adjusted a few things in an 
attempt to 'fix' what might not be broken.  Here's a summary of my file 
and directory permissions as they stand now:

$ id Manager
uid=500(Manager) gid=544(Administrators) groups=544(Administrators)
$ id Users
uid=545(Users) gid=545(Users) groups=545(Users)
$ id postgres
uid=1007(postgres) gid=513(None) groups=513(None)

$ ls -ld /var/postgresql
drwxr-xr-x+   3 Manager  root            0 Sep  4 17:23 /var/postgresql/

$ ls -ld /var/postgresql/data (and all subdirectories and files)
drwxrwx---+   6 postgres Users        4096 Sep  4 19:00 
/var/postgresql/data/

$ ls -ld /var/log
drwxrwxrwx+   4 Manager  Users        4096 Sep  4 18:38 /var/log/

$ ls -ld /tmp
drwxrwxrwx+  40 Manager  Users       12288 Sep  4 23:31 /tmp/

The lock files appear as follows:
srwxrwxrwx    1 postgres Users          51 Sep  4 23:33 .s.PGSQL.5432=
-rw-------    1 postgres Users          26 Sep  4 23:33 .s.PGSQL.5432.lock

If someone has PG running as a service under W2K, it would be most 
appreciated if you could look at these permissions and compare them with 
those that work.  Does anything appear that would suggest a reason for 
the error I see in the Event Viewer and in the postmaster error log?

Thanks,

Alder

Responses

pgsql-cygwin by date

Next:From: Gaetano MendolaDate: 2004-09-05 09:40:05
Subject: Re: Developers page is down
Previous:From: Shahbaz JaveedDate: 2004-09-05 03:24:23
Subject: Re: Developers page is down

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group