--- 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