This is the mail archive of the mailing list for the Cygwin project.

Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Re: postgres help

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:

PGDATA= "/path/to/data/folder/"
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" <>
To: <>; <>
Cc: <>
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:
> Problem reports:
> Documentation:
> FAQ:         

Unsubscribe info:
Problem reports:

Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]