Re: createdb fails

--- Christof Glaser <gcg@gl.aser.de> wrote:
> 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

Yes, my pg_hba.conf contains both these lines.

> - Did you try
>    psql -h localhost -l  # list all databases:
> template0 and template1
> should show up

This gives me the message:

  Could not receive server response to SSL negotiation
  packet: Resource temporarily unavailable

At this point I tried starting postmaster directly
with SSL connection enabled using the command:

  postmaster -l -D /usr/local/pgsql/data &

This failed with the log message:

  FATAL:  could not load server certificate file
  "/usr/local/pgsql/data/server.crt": No such file
  or directory

>          connecting using TCP/IP instead of socket?
>
>    In postgresql.conf then there must be
>    tcpip_socket = true

Yes, I have this line in postgresql.conf.

> - Perhaps you have another copy of PostgreSQL
> installed?
> Mixing the client of one version with the server of
> another gives
> mostly unexpected results.

Nope, this is the only version I've ever installed.

Could I have installed it wrong somehow?  I followed
the instructions here:

http://www.postgresql.org/docs/faqs/text/FAQ_MSWIN

The only thing I did differently (I'm pretty sure --
it's been a couple of weeks) was that when I first
attempted to run initdb I got an error about not
having an encryption package installed.  I did some
research on the web and found others solved the
problem by installing the cygwin package:

  Libs -> "crypt: Encryption / Decryption utility
  and library

Could it be a config problem on my XP box?  Is there
something I need to change in my networking
configuration?

Thanks again.

Bill

__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html