how do i log events for postgresql 7.0.3

[Shivaprasad Pavoor]

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

[Peter Eisentraut]

Post by Shivaprasad Pavoor
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.

Configuration was different back in those days. You need to look it up
in the documentation that accompanied that version. Or as long as
you're still configuring -- upgrade.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Shivaprasad Pavoor]

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" <***@dellmail.com>
Date: Sat, 29 May 2004 04:23:14 +0800
To: pgsql-***@postgresql.org
Subject: [ADMIN] how do i log events for postgresql 7.0.3

Post by Shivaprasad Pavoor
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