pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shivaprasad Pavoor <shivaprasadp@dellmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: how do i log events for postgresql 7.0.3
Date: Mon, 31 May 2004 20:24:17 +0800
Message-ID: <20040531122418.12AFC3740C4@ws3-2.us4.outblaze.com> (raw)

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" <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 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






view thread (3+ messages)

Message-ID: <20040531122418.12AFC3740C4@ws3-2.us4.outblaze.com>
Permalink:  ../20040531122418.12AFC3740C4@ws3-2.us4.outblaze.com/
Also on:    postgresql.org/message-id/20040531122418.12AFC3740C4@ws3-2.us4.outblaze.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: shivaprasadp@dellmail.com
  Subject: Re: how do i log events for postgresql 7.0.3
  In-Reply-To: <20040531122418.12AFC3740C4@ws3-2.us4.outblaze.com>
  References: <20040531122418.12AFC3740C4@ws3-2.us4.outblaze.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox