From: | Christof Glaser <gcg(at)gl(dot)aser(dot)de> |
---|---|
To: | Bill Chandler <billybobc1210(at)yahoo(dot)com> |
Cc: | pgsql-cygwin(at)postgresql(dot)org |
Subject: | Re: createdb fails |
Date: | 2004-03-26 10:53:08 |
Message-ID: | C45D984F-7F13-11D8-9389-000A957E650E@gl.aser.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
Hi Bill,
Am 26.03.2004 um 06:11 schrieb Bill Chandler:
> 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
This message looks incomplete to me somehow.
Some ideas though:
- Perhaps the pg_hba.conf settings don't allow to connect to template1?
It should contain lines like
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
- Did you try
psql -h localhost -l # list all databases: template0 and template1
should show up
^^^^^^^^^^^
connecting using TCP/IP instead of socket?
In postgresql.conf then there must be
tcpip_socket = true
- Perhaps you have another copy of PostgreSQL installed?
Mixing the client of one version with the server of another gives
mostly unexpected results.
> Got the following in log file:
>
> LOG: shmdt(0x1b40000) failed: Invalid argument
This is "normal" on cygwin, I heard (my log has it too, but PG works
well).
The other messages are even more normal, documenting ordinary server
operation.
Hope it helps a bit,
Best regards,
Christof Glaser
--
-- gl.aser . software engineering . internet service
-- Doelitzer Strasse 37 . D-04277 Leipzig . fon +49-341-303 20 51
-- http://gl.aser.de/ . sms +49-177-779 28 43 . fax +49-0341-303 20 52
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Tishler | 2004-03-27 03:24:15 | Re: Postgres crashes on cygserver |
Previous Message | Bill Chandler | 2004-03-26 05:11:03 | createdb fails |