From: | Bill Chandler <billybobc1210(at)yahoo(dot)com> |
---|---|
To: | pgsql-cygwin(at)postgresql(dot)org |
Subject: | Re: createdb fails |
Date: | 2004-03-27 03:58:54 |
Message-ID: | 20040327035854.11573.qmail@web12906.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
--- Christof Glaser <gcg(at)gl(dot)aser(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Chandler | 2004-03-27 04:27:44 | Re: [GENERAL] Problems getting started: createdb fails |
Previous Message | Jason Tishler | 2004-03-27 03:27:34 | Re: Win32 error 126 |