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
From: <tsmets AT lautre DOT net>
Message-ID: <008c01c1cfe0$ef1aa7d0$6501a8c0@calvin>
To: "Neil Zanella" <nzanella AT cs DOT mun DOT ca>, <cygwin AT sources DOT redhat DOT com>
References: <Pine DOT LNX DOT 4 DOT 44 DOT 0203192008170 DOT 6640-100000 AT garfield DOT cs DOT mun DOT ca>
Subject: Re: postgresql: getting it to work (?)
Date: Wed, 20 Mar 2002 08:11:18 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2462.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2462.0000



Gee Neil,

Have you checked that postmaster is up & running ... ?
Do a
            ps -ef | grep postmaster

Have you tried to use the "-d" option ?
<snip>
        [root AT stackanov root]# postmaster --help
        postmaster is the PostgreSQL server.

        Usage:
          postmaster [options...]

        Options:
          -B NBUFFERS     number of shared buffers (default 64)
          -c NAME=VALUE   set run-time parameter
          -d 1-5          debugging level
          -D DATADIR      database directory
          -F              turn fsync off
          -h HOSTNAME     host name or IP address to listen on
          -i              enable TCP/IP connections
          -k DIRECTORY    Unix-domain socket location
          -N MAX-CONNECT  maximum number of allowed connections (1..1024,
default 32)
          -o OPTIONS      pass 'OPTIONS' to each backend server
          -p PORT         port number to listen on (default 5432)
          -S              silent mode (start in background without logging
output)

        Developer options:
          -n              do not reinitialize shared memory after abnormal
exit
          -s              send SIGSTOP to all backend servers if one dies

        Please read the documentation for the complete list of run-time
        configuration settings and how to set them on the command line or in
        the configuration file.

        Report bugs to <pgsql-bugs AT postgresql DOT org>.
        [root AT stackanov root]#
</snip>

If you can tell us that, you may expect a decent answer...
Don't just complain that smthg is WRONG, will you ?

You can also see on the PostgresQL ML....


thomas,


--
Thomas SMETS
rue J. Wytsmanstraat 62
1050 Bruxelles
yahoo-id : smetsthomas
----- Original Message -----
From: "Neil Zanella" <nzanella AT cs DOT mun DOT ca>
To: <cygwin AT sources DOT redhat DOT com>
Sent: 20 March, 2002 12:42 AM
Subject: postgresql: getting it to work (?)


>
> Hello,
>
> I have the lastest cygwin with postgresql installed.
> It seems like there is no $PGDATA directory. Anyone
> know how to properly start the postmaster so that
> the psql utility works properly:
>
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socked "/tmp/.s.PGSQL.5432"?
>
> Thanks,
>
> Neil
>
>
> --
> Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
> Bug reporting:         http://cygwin.com/bugs.html
> Documentation:         http://cygwin.com/docs.html
> FAQ:                   http://cygwin.com/faq/
>
>



--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/