pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedhow do i log events for postgresql 7.0.3
3+ messages / 2 participants
[nested] [flat]
* how do i log events for postgresql 7.0.3
@ 2004-05-28 20:23 Shivaprasad Pavoor <shivaprasadp@dellmail.com>
2004-05-28 21:25 ` Re: how do i log events for postgresql 7.0.3 Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 3+ messages in thread
From: Shivaprasad Pavoor @ 2004-05-28 20:23 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: how do i log events for postgresql 7.0.3
2004-05-28 20:23 how do i log events for postgresql 7.0.3 Shivaprasad Pavoor <shivaprasadp@dellmail.com>
@ 2004-05-28 21:25 ` Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2004-05-28 21:25 UTC (permalink / raw)
To: Shivaprasad Pavoor <shivaprasadp@dellmail.com>; pgsql-admin
Shivaprasad Pavoor wrote:
> 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: how do i log events for postgresql 7.0.3
@ 2004-05-31 12:24 Shivaprasad Pavoor <shivaprasadp@dellmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Shivaprasad Pavoor @ 2004-05-31 12:24 UTC (permalink / raw)
To: 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 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-05-31 12:24 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-28 20:23 how do i log events for postgresql 7.0.3 Shivaprasad Pavoor <shivaprasadp@dellmail.com>
2004-05-28 21:25 ` Peter Eisentraut <peter_e@gmx.net>
2004-05-31 12:24 Re: how do i log events for postgresql 7.0.3 Shivaprasad Pavoor <shivaprasadp@dellmail.com>
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