On Wed, 12 Nov 2003, ow wrote:
> Hi,
>
> Is there a way to take the database offline to keep users out?
> Is there a way to take the database offline but still allowing pg_restore to
> run against it?
Yes, as of 7.3 you can create entries in pg_hba.conf that control who can
connect to what database. Just make a backup of the original pg_hba.conf,
and set up your copy to have only the postgres (or other) superuser be
allowed to connect. Then, swap the two hba files and restart the server.