[GENERAL] is it possible to delete the psql log while psql is running?

2005-12-08 Thread Gábor Farkas
hi, i'd like to delete the postgresql log file (resides in /var/log/pgsql/postgres), because it has become too big. can i simply delete the file while postres is running? or do i have to stop postgres first, and only delete the logfile after that? thanks, gabor

Re: [GENERAL] is it possible to delete the psql log while psql is

2005-12-08 Thread Csaba Nagy
Gabor, Short answer: you'll have to restart. Long answer: It depends a lot on your OS... on windows I bet you can't delete it, the OS will prevent you to do it (you'll get some error). On Linux you can delete it, but the postgres server will still use it even if you can't access it anymore

Re: [GENERAL] is it possible to delete the psql log while psql is

2005-12-08 Thread Martijn van Oosterhout
On Thu, Dec 08, 2005 at 02:43:44PM +0100, Csaba Nagy wrote: Gabor, Short answer: you'll have to restart. Long answer: It depends a lot on your OS... on windows I bet you can't delete it, the OS will prevent you to do it (you'll get some error). Note: on Linux I've had success with simply

Re: [GENERAL] is it possible to delete the psql log while psql is

2005-12-08 Thread Csaba Nagy
[snip] Note: on Linux I've had success with simply truncating the file using: : [filename] This does free up the space used straightaway. Depending on the mode the file was opened with it may also reset the position the postmaster writes at. Interesting hint, I'll try it next time I'll

[GENERAL] is it possible to delete the psql log while psql is running?

2005-12-08 Thread gabor
hi, i'd like to delete the postgresql log file (resides in /var/log/pgsql/postgres), because it has become too big. can i simply delete the file while postgresql is running? or do i have to stop postgresql first, and only delete the logfile after that? thanks, gabor -- That's life for

Re: [GENERAL] is it possible to delete the psql log while psql is

2005-12-08 Thread Tino Wildenhain
gabor schrieb: hi, i'd like to delete the postgresql log file (resides in /var/log/pgsql/postgres), because it has become too big. can i simply delete the file while postgresql is running? or do i have to stop postgresql first, and only delete the logfile after that? echo -n postgresql.log

Re: [GENERAL] is it possible to delete the psql log while psql is

2005-12-08 Thread Oleg Bartunov
I'd do echo pgql.log Oleg On Thu, 8 Dec 2005, gabor wrote: hi, i'd like to delete the postgresql log file (resides in /var/log/pgsql/postgres), because it has become too big. can i simply delete the file while postgresql is running? or do i have to stop postgresql first, and only

Re: [GENERAL] is it possible to delete the psql log while psql is running?

2005-12-08 Thread Cook, Steve
cat /dev/null name_of_log_to_truncate -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of gabor Sent: Thursday, December 08, 2005 6:21 AM To: pgsql-general@postgresql.org Subject:[GENERAL] is it possible to delete the psql log while psql

Re: [GENERAL] is it possible to delete the psql log while psql is

2005-12-08 Thread Ed L.
On Thursday December 8 2005 9:19 am, Oleg Bartunov wrote: I'd do echo pgql.log That won't free any space from an open file. You have to stop postgresql first in order to close the file, or use log file rotation and wait until it rotates out to a closed state. Ed Oleg On Thu, 8 Dec

Re: [GENERAL] is it possible to delete the psql log while psql is

2005-12-08 Thread Thies C. Arntzen
hi, use cp /dev/null pqsql.log to truncate the logfile in place and free some space. re, thies Am 08.12.2005 um 23:26 schrieb Ed L.: On Thursday December 8 2005 9:19 am, Oleg Bartunov wrote: I'd do echo pgql.log That won't free any space from an open file. You have to stop