Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sources.redhat.com/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com
Message-ID: <003201c3699a$e2f31f50$3701a8c0@williethepimp>
From: "Jonathan Simms" <jonathan AT embassynetworks DOT com>
To: <cygwin AT cygwin DOT com>
References: <3F46A361 DOT 7090603 AT mitre DOT org>
Subject: Re: postgres help
Date: Sat, 23 Aug 2003 13:20:44 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106

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 AT mitre DOT org>
To: <cygwin AT cygwin DOT com>; <pgsql-cygwin AT postgresql DOT org>
Cc: <jason AT tishler DOT 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/