Thread: Keeping only one postgres.exe instance running

Keeping only one postgres.exe instance running

From
"Pierre Racine"
Date:
Hi,

Is there a way to tell PostgreSQL to keep only one instance of
postgres.exe running?

Thanks,

Pierre


Re: Keeping only one postgres.exe instance running

From
Scott Marlowe
Date:
On Thu, Mar 5, 2009 at 2:52 PM, Pierre Racine
<Pierre.Racine@sbf.ulaval.ca> wrote:
> Hi,
>
> Is there a way to tell PostgreSQL to keep only one instance of
> postgres.exe running?

Running it in single user non-server mode?

Is there some reason you're looking to do this?

Re: Keeping only one postgres.exe instance running

From
John R Pierce
Date:
Pierre Racine wrote:
> Hi,
>
> Is there a way to tell PostgreSQL to keep only one instance of
> postgres.exe running?
>

you  couldn't use it if that was the case.   at a minimum, there is the
postmaster process, the postgres writer, the postgres logger, the
postgres stats collector, and the postgres wal writter.  oh, and
autovacuum..   then, each user connection to postgres launches another
instance to service the queries of that connection.