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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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/
