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@yahoo.com
__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html