This is the mail archive of the
mailing list for the Cygwin project.
Re: postgres help
- From: "Jonathan Simms" <jonathan at embassynetworks dot com>
- To: <cygwin at cygwin dot com>
- Date: Sat, 23 Aug 2003 13:20:44 -0400
- Subject: Re: postgres help
- References: <3F46A361.email@example.com>
Hey, i just went through this myself.
When you start the service make sure you give the argument "-i", it'll turn
on TCP/IP networking.
next set the environment variables:
PGDATABASE = "your_dbname"
PGHOST = "localhost"
PGPASSWORD = password
PGPORT = "5432"
PGUSER = username
that worked for me.
Also, I know this may be a security-related Bad Thing (which wasn't much of
an issue for me), it seemed to work a lot smoother skipping over the
"postgres" user setup and just running the service under my username. Just
make sure you're an Administrator, and under start > run > secpol.msc > "Log
on as a service" your username is listed.
oh, and for some weird reason (i know it's gonna sound stupid), but I had to
reboot after install for it to work. I sat there for an hour trying to
troubleshoot it, got fed up, rebooted, and it worked itself out...
Anyway, hope this is of some assistance...
----- Original Message -----
From: "Jason House" <firstname.lastname@example.org>
To: <email@example.com>; <firstname.lastname@example.org>
Sent: Friday, August 22, 2003 7:12 PM
Subject: postgres help
> I've gone through all the steps to set up postgreSQL on windows XP. I
> have updated permissions (to /tmp /usr/bin /usr/bin/*), verified the
> system path variable, and verified that ipc and postmaster services have
> been started. I don't understand why I'm getting the following error:
> $ psql -U postgres template1
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> The error does not change if I log in as myself or as postgres.
> Any hints as to what to try would be greatly appreciated.
> Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
> Problem reports: http://cygwin.com/problems.html
> Documentation: http://cygwin.com/docs.html
> FAQ: http://cygwin.com/faq/
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Problem reports: http://cygwin.com/problems.html