Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-cygwin by date

Next:From: Christof GlaserDate: 2004-03-26 10:53:08
Subject: Re: createdb fails
Previous:From: Meena PatelDate: 2004-03-25 23:18:08
Subject: No Subject

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group