Re: postgres help

["Jonathan Simms" <jonathan at embassynetworks dot 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:

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" <jhouse@mitre.org>
To: <cygwin@cygwin.com>; <pgsql-cygwin@postgresql.org>
Cc: <jason@tishler.net>
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
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/