createdb fails

From: Bill Chandler <billybobc1210(at)yahoo(dot)com>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: createdb fails
Date: 2004-03-26 05:11:03
Message-ID: 20040326051103.69916.qmail@web12907.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)yahoo(dot)com

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

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Christof Glaser 2004-03-26 10:53:08 Re: createdb fails
Previous Message Meena Patel 2004-03-25 23:18:08 No Subject