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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]