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

Re: createdb fails

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 (view raw or flat)
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


In response to

Responses

pgsql-cygwin by date

Next:From: Jason TishlerDate: 2004-03-27 03:24:15
Subject: Re: Postgres crashes on cygserver
Previous:From: Bill ChandlerDate: 2004-03-26 05:11:03
Subject: createdb fails

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