-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


This just in from a PostgreSQL discussion list. The normal behaviour for
PostgreSQL is to listen on unix sockets and write it's log to STDOUT.
In this case Mandrake turns on the internet sockets by default without SSL
or stunnel. It also does all of it's logging to /dev/null.

I'm just astonished.

Joshua b. Jore
http://www.greentechnologist.org

- ---------- Forwarded message ----------
Date: Wed, 13 Feb 2002 11:48:40 -0800
From: Patrick Hatcher <PHatcher at macys.com>
To: Patrick Hatcher <PHatcher at macys.com>
Cc: Josh Berkus <josh at agliodbs.com>, pgsql-novice at postgresql.org
Subject: Re: [NOVICE] Function Hangs


I found the Postmaster startup file.  Here is the start params:

su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -o "
- -i" start >/dev/null 2>&1"

would the name of the log file go where the /dev/null is?

- ---------- Forwarded message ----------

It was a Mandrake install, so it auto-starts during system start up.

- ---------- Forwarded message ----------

> Thanks.  Stupid question:  Where would I find the database log?

Wherever you put it in your startup options for Postmaster.  I usually
 put mine in /var/log/postgresql.  How do you start postmaster?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (OpenBSD)
Comment: For info see http://www.gnupg.org

iD8DBQE8astYfexLsowstzcRAsiBAJ91ee9v93dUie0ekH2kgrkPSmwWcACg3mDL
qxku8bvT5/f3FwvAVWEPtok=
=1M0h
-----END PGP SIGNATURE-----