createdb fails - Mailing list pgsql-cygwin

From Bill Chandler
Subject createdb fails
Date
Msg-id 20040326051103.69916.qmail@web12907.mail.yahoo.com
Whole thread Raw
Responses Re: createdb fails
List pgsql-cygwin
Hi,

My first post so I hope this isn't too much of a
beginner question for this list.

Installed cygwin & postgreSQL 7.4.1 on my XP machine.
Ran ipc-daemon2, initdb, pg_ctl as per
instructions.  A few questionable log messages (see
below) but postmaster appeared to have started ok.

However, when I try to create a database with

  createdb -U "My User Name" mydb

or even:

  createdb mydb

I get the following error:

  createdb: could not connect to database template1:
  expected authentication request from server but
  received

Here is the initdb command I ran:

  initdb -D /usr/local/pgsql/data

Here is the pg_ctl command I ran:

  pg_ctl -D /usr/local/pgsql/data -l /tmp/pg.log start

Got the following in log file:

LOG:  shmdt(0x1b40000) failed: Invalid argument
LOG:  database system was shut down at 2004-03-23
22:35:41 EST
LOG:  checkpoint record is at 0/9EAB40LOG:  redo
record is at 0/9EAB40; undo record is at 0/0; shutdown
TRUE
LOG:  next transaction ID: 541; next OID: 17142
LOG:  database system is ready

Despite the first few lines, it does say "database
system ready".  "pg_ctl ... status" says that
postmaster is up and running.

I've tried lots of different variations on .conf
files, etc.  Nothing seems to work.

Anybody have any ideas?  Getting desparate. Thanks
in advance.

Bill Chesky
billybobc1210@yahoo.com

__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

pgsql-cygwin by date:

Previous
From: Oscar Pearce
Date:
Subject: Postmaster receives signal 11 on Windows 98 SE
Next
From: Christof Glaser
Date:
Subject: Re: createdb fails