[newbie] Postmaster service on W2K
От | Terry Branscombe |
---|---|
Тема | [newbie] Postmaster service on W2K |
Дата | |
Msg-id | 413AB56D.5080207@telus.net обсуждение исходный текст |
Список | 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
В списке pgsql-cygwin по дате отправления:
Следующее
От: "Jean-Pierre Pelletier"Дата:
Сообщение: All Production releases of PostgreSQL hung because of bugs in cygserver