postgresql: getting it to work (?)

postgresql: getting it to work (?)

[Neil Zanella]

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/

Re: postgresql: getting it to work (?)

[tsmets]

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/

Re: postgresql: getting it to work (?)

[Jason Tishler]

Neil,

On Tue, Mar 19, 2002 at 08:12:42PM -0330, Neil Zanella wrote:
> 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"?

Did you read the README?

    http://www.tishler.net/jason/software/postgresql/postgresql-7.2.README.txt

Jason

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