Re: [ADMIN] Log File

2007-07-13 Thread Vishal Arora
Do you have pgpass.conf file in place? it shows the password authentication failed for that particular user. On Microsoft Windows the file is named %APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the Application Data subdirectory in the user’s profile). Could you also send the ev

Re: [ADMIN] Log file Query

2005-09-13 Thread Tom Lane
"Yogvinder Singh" <[EMAIL PROTECTED]> writes: > I am using postgres7.3 version. I am unable to find any log. = In 7.3 your best bet is to log via syslog. Set syslog to 2 in postgresql.conf and adjust the other settings if needed, then make sure your syslog daemon is configured to put

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