Configure Different Databases on One Server

From: Jim Longwill <JLongwill(at)psmfc(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Configure Different Databases on One Server
Date: 2015-10-29 18:52:34
Message-ID: 56326AF2.9000903@psmfc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a question about Postgres management. Our situation is probably
similar to many data shops.

We have one (Linux) server, and one Postgres installation (v9.4), hence
one Postgres process-daemon set running on the server, but we have
multiple databases created: ddev1, ddev2, ddev3.

I would like to do a different vacuum configuration on ddev2 than on
ddev1, such as turning off autovacuum, etc. How do I do this? E.g. how
do I turn off autovacuum on one database .. using different
postgres.conf files(?) or within the database, without affecting the
other database(s) on the same localhost?

Is there a relatively easy way to do this?

--o--o--o--o--o--o--o--o--o--o--o--o--
Jim Longwill
JLongwill(at)psmfc(dot)org
--o--o--o--o--o--o--o--o--o--o--o--o--

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2015-10-29 19:01:38 Re: mysql_fdw trouble
Previous Message Eric Schwarzenbach 2015-10-29 18:29:34 Re: Domain check constraint not honored?