Vista - postgresql 8.2.11 - won't start, psql FATAL role does not exist

[Keith Christian <keith1christian at gmail dot com>]

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/