Re: Retoring non-administrative user databases

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Keith C(dot) Perry" <netadmin(at)vcsn(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Retoring non-administrative user databases
Date: 2003-11-16 16:46:42
Message-ID: Pine.LNX.4.44.0311161745300.5327-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martin Marques 2003-11-16 18:14:23 Re: Error on initdb with 7.4RC2
Previous Message Tom Lane 2003-11-16 14:58:29 Re: Retoring non-administrative user databases