pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedper-database logging
6+ messages / 5 participants
[nested] [flat]
* per-database logging
@ 2004-03-02 16:05 bkim <bkim@coe.tamu.edu>
2004-03-06 03:24 ` Re: per-database logging Bruce Momjian <pgman@candle.pha.pa.us>
2004-03-06 05:49 ` Re: per-database logging Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 6+ messages in thread
From: bkim @ 2004-03-02 16:05 UTC (permalink / raw)
To: pgsql-admin
Dear list,
Is it possible to use a dedicated log file for each database? I think
it's possible in other database servers, but couldn't find the same from
postgresql documents or web search.
Regards,
Ben
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: per-database logging
2004-03-02 16:05 per-database logging bkim <bkim@coe.tamu.edu>
@ 2004-03-06 03:24 ` Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2004-03-06 03:24 UTC (permalink / raw)
To: bkim <bkim@coe.tamu.edu>; +Cc: pgsql-admin
bkim wrote:
> Dear list,
>
> Is it possible to use a dedicated log file for each database? I think
> it's possible in other database servers, but couldn't find the same from
> postgresql documents or web search.
No, it is not. 7.5 will have the ability to add the database name as a
prefix to ever log line, but that's about all we have.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: per-database logging
2004-03-02 16:05 per-database logging bkim <bkim@coe.tamu.edu>
@ 2004-03-06 05:49 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-03-10 14:43 ` Re: per-database logging Ben Kim <bkim@coe.tamu.edu>
1 sibling, 1 reply; 6+ messages in thread
From: Tom Lane @ 2004-03-06 05:49 UTC (permalink / raw)
To: bkim <bkim@coe.tamu.edu>; +Cc: pgsql-admin
bkim <bkim@coe.tamu.edu> writes:
> Is it possible to use a dedicated log file for each database?
Sure, if you run a separate postmaster for each database.
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: per-database logging
2004-03-02 16:05 per-database logging bkim <bkim@coe.tamu.edu>
2004-03-06 05:49 ` Re: per-database logging Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-03-10 14:43 ` Ben Kim <bkim@coe.tamu.edu>
2004-03-10 15:08 ` Re: per-database logging Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Ben Kim @ 2004-03-10 14:43 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-admin
Thanks. Is there a disadvantage of running separate postmaster compared to
running one postmaster with multiple databases?
Regards,
Ben
On Sat, 6 Mar 2004, Tom Lane wrote:
> bkim <bkim@coe.tamu.edu> writes:
> > Is it possible to use a dedicated log file for each database?
>
> Sure, if you run a separate postmaster for each database.
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: per-database logging
2004-03-02 16:05 per-database logging bkim <bkim@coe.tamu.edu>
2004-03-06 05:49 ` Re: per-database logging Tom Lane <tgl@sss.pgh.pa.us>
2004-03-10 14:43 ` Re: per-database logging Ben Kim <bkim@coe.tamu.edu>
@ 2004-03-10 15:08 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-03-10 16:00 ` Re: per-database logging scott <scott@QNET.COM>
0 siblings, 1 reply; 6+ messages in thread
From: Tom Lane @ 2004-03-10 15:08 UTC (permalink / raw)
To: Ben Kim <bkim@coe.tamu.edu>; +Cc: pgsql-admin
Ben Kim <bkim@coe.tamu.edu> writes:
> Thanks. Is there a disadvantage of running separate postmaster compared to
> running one postmaster with multiple databases?
More resource consumption, since each postmaster needs its own
shared-memory area. Also possibly confusion, since you have to remember
which port number to connect to for each database.
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: per-database logging
2004-03-02 16:05 per-database logging bkim <bkim@coe.tamu.edu>
2004-03-06 05:49 ` Re: per-database logging Tom Lane <tgl@sss.pgh.pa.us>
2004-03-10 14:43 ` Re: per-database logging Ben Kim <bkim@coe.tamu.edu>
2004-03-10 15:08 ` Re: per-database logging Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-03-10 16:00 ` scott <scott@QNET.COM>
0 siblings, 0 replies; 6+ messages in thread
From: scott @ 2004-03-10 16:00 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: tgl@sss.pgh.pa.us; To: \"Ben Kim\" <bkim@coe.tamu.edu>; pgsql-admin
Take me off your silly list or address book!
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Ben Kim" <bkim@coe.tamu.edu>
Cc: <pgsql-admin@postgresql.org>
Sent: Wednesday, March 10, 2004 7:08 AM
Subject: Re: [ADMIN] per-database logging
> Ben Kim <bkim@coe.tamu.edu> writes:
> > Thanks. Is there a disadvantage of running separate postmaster compared
to
> > running one postmaster with multiple databases?
>
> More resource consumption, since each postmaster needs its own
> shared-memory area. Also possibly confusion, since you have to remember
> which port number to connect to for each database.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2004-03-10 16:00 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-02 16:05 per-database logging bkim <bkim@coe.tamu.edu>
2004-03-06 03:24 ` Bruce Momjian <pgman@candle.pha.pa.us>
2004-03-06 05:49 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-03-10 14:43 ` Ben Kim <bkim@coe.tamu.edu>
2004-03-10 15:08 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-03-10 16:00 ` scott <scott@QNET.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