-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thu, 10 Jan 2008 19:08:57 -0500 Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > "Andy Shellam" <andy.shellam-lists@xxxxxxxxxxxxxxxxx> writes: > > What I want PostgreSQL to do is put a log file "postgresql.log" in > > "/var/log/pgsql" - I have an application that handles log > > rotations, so would prefer to do it with that, rather than have > > PostgreSQL do the rotation. > > You don't really have any choice about the matter --- Postgres will > not use a single fixed filename because that would be guaranteed to > lose log entries across a rotation. Unless he is using syslog? Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD' -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHhrbjATb/zqfZUUQRAkN+AKCY+dQ9+zExF5Yx9BST22hgxVUzMQCdFqZd 0fqVMpSh9pGkLqeDvG+LTL8= =XsVx -----END PGP SIGNATURE----- ---------------------------(end of broadcast)---------------------------TIP 6: explain analyze is your friend