Re: Retoring non-administrative user databases - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Retoring non-administrative user databases
Date
Msg-id Pine.LNX.4.44.0311161745300.5327-100000@peter.localdomain
Whole thread Raw
In response to Re: Retoring non-administrative user databases  ("Keith C. Perry" <netadmin@vcsn.com>)
List pgsql-general
Keith C. Perry writes:

> What is a method of dumping and restoring a complete database cluster when that
> cluster contains users that are NOT allowed to create databases.

There is nothing special you need to do, except of course not actually
restoring the dump as one of those unprivileged users.  A pg_dumpall dump
must be restored as a superuser.

--
Peter Eisentraut   peter_e@gmx.net


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Retoring non-administrative user databases
Next
From: Martin Marques
Date:
Subject: Re: Error on initdb with 7.4RC2