Keeping only one postgres.exe instance running

Started by Pierre Racineabout 17 years ago3 messagesgeneral
Jump to latest
#1Pierre Racine
Pierre.Racine@sbf.ulaval.ca

Hi,

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

Thanks,

Pierre

#2Scott Marlowe
scott.marlowe@gmail.com
In reply to: Pierre Racine (#1)
Re: Keeping only one postgres.exe instance running

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?

#3John R Pierce
pierce@hogranch.com
In reply to: Pierre Racine (#1)
Re: Keeping only one postgres.exe instance running

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.