X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 43E6ED1B4BF for ; Wed, 10 Mar 2004 15:08:17 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 10101-01 for ; Wed, 10 Mar 2004 11:08:10 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 2B485D1B461 for ; Wed, 10 Mar 2004 11:08:09 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2AF84mP006587; Wed, 10 Mar 2004 10:08:04 -0500 (EST) To: Ben Kim Cc: pgsql-admin@postgresql.org Subject: Re: per-database logging In-reply-to: References: Comments: In-reply-to Ben Kim message dated "Wed, 10 Mar 2004 08:43:35 -0600" Date: Wed, 10 Mar 2004 10:08:04 -0500 Message-ID: <6586.1078931284@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/183 X-Sequence-Number: 12752 Ben Kim 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