pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
per-database logging
6+ messages / 5 participants
[nested] [flat]

* per-database logging
@ 2004-03-02 16:05  bkim <bkim@coe.tamu.edu>
  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-06 03:24  Bruce Momjian <pgman@candle.pha.pa.us>
  parent: bkim <bkim@coe.tamu.edu>
  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-06 05:49  Tom Lane <tgl@sss.pgh.pa.us>
  parent: bkim <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-10 14:43  Ben Kim <bkim@coe.tamu.edu>
  parent: 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-10 15:08  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Ben Kim <bkim@coe.tamu.edu>
  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-10 16:00  scott <scott@QNET.COM>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  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