autovacuum vs. createdb - Mailing list pgsql-general

From Ben
Subject autovacuum vs. createdb
Date
Msg-id Pine.LNX.4.64.0801151528350.30810@localhost.localdomain
Whole thread Raw
Responses Re: autovacuum vs. createdb  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I'm noticing a problem where autovacuum touching template1 when createdb
is run is making createdb fail. That's easy to work around when doing
things by hand (just run it again), but when running createdb with a
script, it's not so clear to me how to keep things working all the time.

One thought I had was having my script insert rows into pg_autovacuum
temporarily (I assume in template1) but I'm not sure what tables I need to
tell the autovacuum daemon to keep away from. Is that a reasonable idea,
or is there a better one?

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: Clearing old user ids completely
Next
From: Tom Lane
Date:
Subject: Re: Clearing old user ids completely