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

Problems getting started: createdb fails

From: billybobc1210(at)yahoo(dot)com (Bill C(dot))
To: "pgsql-general(at)postgresql(dot)org(dot)pgsql-novice"(at)postgresql(dot)org
Subject: Problems getting started: createdb fails
Date: 2004-03-24 05:48:23
Message-ID: 1e75a833.0403232148.207e2acc@posting.google.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
Hi,

Installed cygwin & postgreSQL 7.4.1 on my XP machine.  Ran
command:

  initdb -D /usr/local/pgsql/data -W -E LATIN1

Next, ran command:

  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/9EAB40
LOG:  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" so
I proceeded to try and run creatdb as follows:

  createdb -U "My User Name" mydb

Got message:

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

Things I've tried:

- changed "tcpip_socket = true" in postgresql.conf, ran "pg_ctl
restart ..."
- added line to pg_hba.conf with IP-ADDRESS=0.0.0.0,
IP-MASK=255.255.255.255,  ran "pg_ctl restart ..."
- used -W option on createdb command, entered superuser password that
I specified on initdb command

Nothing seems to work.  Any ideas?

Thanks in advance,

Bill

pgsql-novice by date

Next:From: MagnuMDate: 2004-03-24 10:35:08
Subject: Re: Upgrading PostgreSQL
Previous:From: Joe BordesDate: 2004-03-23 22:33:19
Subject: how to test string against regular expression contained in postgresql database field?

pgsql-general by date

Next:From: Tom LaneDate: 2004-03-24 06:10:20
Subject: Re: linked list rewrite
Previous:From: Neil ConwayDate: 2004-03-24 05:37:49
Subject: Re: linked list rewrite

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