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