Re: how do i log events for postgresql 7.0.3 - Mailing list pgsql-admin

From Shivaprasad Pavoor
Subject Re: how do i log events for postgresql 7.0.3
Date
Msg-id 20040531122418.12AFC3740C4@ws3-2.us4.outblaze.com
Whole thread Raw
In response to how do i log events for postgresql 7.0.3  ("Shivaprasad Pavoor" <shivaprasadp@dellmail.com>)
List pgsql-admin
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
restartedmy 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
serverhas started....any comments..?) 

any comments...?

rgds,
sHIVAPRASADp
----- Original Message -----
From: "Shivaprasad Pavoor" <shivaprasadp@dellmail.com>
Date: Sat, 29 May 2004 04:23:14 +0800
To: pgsql-admin@postgresql.org
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
confusedabout postgres.conf (i'm not able to find in my installation) and pg_options. cud anybody let me know how do i
setuplogging 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




pgsql-admin by date:

Previous
From: "Bhanu, Yogesh"
Date:
Subject: Database stat generation
Next
From: tatel@euskalnet.net
Date:
Subject: Re: ppp link activated on startup