This is the mail archive of the cygwin mailing list for the Cygwin project.
Index Nav: | [Date Index] [Subject Index] [Author Index] [Thread Index] | |
---|---|---|
Message Nav: | [Date Prev] [Date Next] | [Thread Prev] [Thread Next] |
Other format: | [Raw text] |
I'd like to get PostgreSQL running on my Vista machine. I've been following the "impatient" instructions at the end of /usr/share/doc/Cygwin/postgresql-8.2.11.README as shown below: 1 Installation: 2 3 For the impatient: install as service (hard) 4 5 # save old database (optional) 6 pg_dumpall -g /tmp/$$pgdump-globals.sql 7 pg_dumpall > /tmp/$$pgdump.sql 8 # adjust the settings in /etc/rc.d/init.d/postgresql 9 nano /etc/rc.d/init.d/postgresql 10 sysbash # /etc/rc.d/init.d/postgresql initdb 11 /etc/rc.d/init.d/postgresql install 12 /etc/rc.d/init.d/postgresql start Below is a screen capture showing what transpired: Tue Jan 27 06:04:36 (keith@tycho) ~>rm -rf /usr/share/postgresql/data/ ########## (Line 9 above) - What settings should be adjusted in /etc/rc.d/init.d/postgresql for a starting Cygwin installation??? ########## (Line 10 above) - What is the meaning of "sysbash? Tue Jan 27 06:06:04 (keith@tycho) ~>/etc/rc.d/init.d/postgresql initdb The files belonging to this database system will be owned by user "keith". This user must also own the server process. The database cluster will be initialized with locale C. creating directory /usr/share/postgresql/data ... ok creating subdirectories ... ok selecting default max_connections ... 40 selecting default shared_buffers/max_fsm_pages ... 32MB/204800 creating configuration files ... ok creating template1 database in /usr/share/postgresql/data/base/1 ... ok initializing pg_authid ... ok initializing dependencies ... ok creating system views ... ok loading system objects' descriptions ... ok creating conversions ... ok setting privileges on built-in objects ... ok creating information schema ... ok vacuuming database template1 ... ok copying template1 to template0 ... ok copying template1 to postgres ... ok WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the -A option the next time you run initdb. Success. You can now start the database server using: /usr/sbin/postgres -D /usr/share/postgresql/data (AAAAA) or /usr/sbin/pg_ctl -D /usr/share/postgresql/data -l logfile start (BBBBB) done. ########## Confusion here - The previous lines at the end of initdb (labeled AAAAA and BBBBB above) instruct the user to try one of two command lines to start Postgres. In the README file there are two lines following "initdb", one ending with "install" and the other ending with "start." How should the user proceed at this point? Tue Jan 27 06:10:26 (keith@tycho) ~>echo $CYGWIN ntsec binmode codepage:oem server tty Tue Jan 27 06:10:30 (keith@tycho) ~>/etc/rc.d/init.d/postgresql install - cygserver OK - ERROR CYGWIN must contain server for cygserver to work properly ########## Something wrong with the error message above - CYGWIN does indeed contain "server", see above ^^^^^ Tue Jan 27 06:11:30 (keith@tycho) ~>/etc/rc.d/init.d/postgresql start Starting PostgreSQL: - cygserver OK - ERROR CYGWIN must contain server for cygserver to work properly Tue Jan 27 06:11:40 (keith@tycho) ~>psql -U keith -d postgres psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? *************************************************** ** SECTIONS OF POSTGRESQL'S LOGFILE APPEAR BELOW ** *************************************************** Tue Jan 27 06:13:51 (keith@tycho) ~>ls -l logfile -rw------- 1 keith None 297212 Jan 27 06:13 logfile Tue Jan 27 06:13:55 (keith@tycho) ~>cat -n logfile 1 LOG: database system was shut down at 2009-01-27 06:08:33 MST 2 LOG: checkpoint record is at 0/485AD0 3 LOG: redo record is at 0/485AD0; undo record is at 0/0; shutdown TRUE 4 LOG: next transaction ID: 0/593; next OID: 10820 5 LOG: next MultiXactId: 1; next MultiXactOffset: 0 6 LOG: database system is ready 7 3 [main] postgres 4352 _cygtls::handle_exceptions: Error while dumping state (probably corrupt ed stack) 8 21805 [main] postgres 4352 _cygtls::handle_exceptions: Error while dumping state (probably corrupt ed stack) 9 22208 [main] postgres 4352 _cygtls::handle_exceptions: Error while dumping state (probably corrupt ed stack) 10 22543 [main] postgres 4352 _cygtls::handle_exceptions: Error while dumping state (probably corrupt ed stack) ************************************ ** LINES CLIPPED FROM LOG ** ************************************ 2696 1961785 [main] postgres 4352 _cygtls::handle_exceptions: Error while dumping state (probably corrupt ed stack) 2697 1962167 [main] postgres 4352 _cygtls::handle_exceptions: Error while dumping state (probably corrupt ed stack) 2698 1962554 [main] postgres 4352 _cygtls::handle_exceptions: Error while dumping state (probably corrupt ed stack) 2699 19 [main] postgres 5624 fork: child 4352 - died waiting for dll loading, errno 11 2700 LOG: could not fork background writer process: Resource temporarily unavailable 2701 LOG: server process (PID 4352) exited with exit code 5 2702 LOG: terminating any other active server processes 2703 LOG: all server processes terminated; reinitializing 2704 LOG: database system was interrupted at 2009-01-27 06:13:41 MST 2705 LOG: checkpoint record is at 0/485AD0 2706 LOG: redo record is at 0/485AD0; undo record is at 0/0; shutdown TRUE 2707 LOG: next transaction ID: 0/593; next OID: 10820 2708 LOG: next MultiXactId: 1; next MultiXactOffset: 0 2709 LOG: database system was not properly shut down; automatic recovery in progress 2710 LOG: record with zero length at 0/485B20 2711 LOG: redo is not required 2712 LOG: database system is ready Tue Jan 27 06:14:00 (keith@tycho) ~>psql -U keith -d postgres psql: FATAL: role "keith" does not exist What other steps should I take? What other information should I provide to help troubleshoot this problem? ==========Keith
Attachment:
cygcheck.out
Description: Binary data
-- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/
Index Nav: | [Date Index] [Subject Index] [Author Index] [Thread Index] | |
---|---|---|
Message Nav: | [Date Prev] [Date Next] | [Thread Prev] [Thread Next] |