hi all, following are the stpe thru which i cud log postgres's activity to a log file. however, it is not final....coz whn i restarted my linux box, it was no more logging. so anyone idea to overcome this is most welcome...
here are the steps, 1. Create a file name postgres.log in /var/log (or wherever you want to create) and change ownership to postgres:postgres (thinking that postgres is using the file to log events. if i'm worng PLZ correct me) 2. stop postgresql server 3.login as root and su – postgres 4. postmaster -D /var/lib/pgsql/data >/var/log/postgres.log 2>&1 & 5. CTRL+D and restart postgresql server (why restart becoz, when i issued postmaster command in step 4 the ostgres server has started....any comments..?) any comments...? rgds, sHIVAPRASADp ----- Original Message ----- From: "Shivaprasad Pavoor" <[EMAIL PROTECTED]> Date: Sat, 29 May 2004 04:23:14 +0800 To: [EMAIL PROTECTED] Subject: [ADMIN] how do i log events for postgresql 7.0.3 > hi all, > > i have RH7.1 box with postgres 7.0.3. i searched the internet for above mentioned > subject in vain. now i'm totally confused about postgres.conf (i'm not able to find > in my installation) and pg_options. cud anybody let me know how do i setup logging > of postgres. > > thanks in advance. > > Shivaprasad P > -- > _______________________________________________ > Get your free email from http://www.dellmail.com > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > -- _______________________________________________ Get your free email from http://www.dellmail.com ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
