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: (view raw or whole thread)
Lists: pgsql-cygwin

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 

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
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

Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.


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-2015 The PostgreSQL Global Development Group