Re: [ADMIN] Log File Maintainance

2005-04-12 Thread Scott Marlowe
A followup, there was a type in my last post, shoulda been: su - postgres -c 'pg_ctl start | /usr/sbin/rotatelogs $PGDATA/logs/pgsql 86400 2>&1 &' Note that change in the 2>&1... ---(end of broadcast)--- TIP 9: the planner will ignore your desire

Re: [ADMIN] Log File Maintainance

2005-04-12 Thread Scott Marlowe
On Mon, 2005-04-11 at 00:20, Inpreet Singh wrote: > Hello, > > I am working on live server where we have installed postgres database > as our back end. But now the problem is due to continues work on > postgres, size of log files has become problem for us. And the > partition where our postgres e

[ADMIN] Log File Maintainance

2005-04-11 Thread Inpreet Singh
Hello,   I am working on live server where we have installed postgres database as our back end. But now the problem is due to continues work on postgres, size of log files has become problem for us. And the partition where our postgres exists is full. Postmaster is not working now. I tried