This is the mail archive of the
cygwin@cygwin.com
mailing list for the Cygwin project.
Re: postgresql: getting it to work (?)
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@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@postgresql.org>.
[root@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@cs.mun.ca>
To: <cygwin@sources.redhat.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/