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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-03-24 06:10:20 | Re: linked list rewrite |
Previous Message | Neil Conway | 2004-03-24 05:37:49 | Re: linked list rewrite |
From | Date | Subject | |
---|---|---|---|
Next Message | MagnuM | 2004-03-24 10:35:08 | Re: Upgrading PostgreSQL |
Previous Message | Joe Bordes | 2004-03-23 22:33:19 | how to test string against regular expression contained in postgresql database field? |