On Wed, Nov 12, 2003 at 12:07:23 -0800,
ow <[EMAIL PROTECTED]> 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?
You could shut the database down, change pg_hba.conf to only let in
the postgres user, bring the system back up. Once you finish your restore
you can repeat the procedure, this time change pg_hba.conf to let everyone
back in.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
