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
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/

- Raw text -