Skip site navigation (1) Skip section navigation (2)

Re: Backup of users and groups?

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bjørn T Johansen <btj(at)havleik(dot)no>,"pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Backup of users and groups?
Date: 2004-03-10 19:15:39
Message-ID: 1078946139.2418.159.camel@localhost.localdomain (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
My first line should have  been pg_dumpall, at any rate, the command tom
is referring to is

pg_dumpall --globals_only

make sure you do this before you upgrade.

On Wed, 2004-03-10 at 11:21, Tom Lane wrote:
> Dave Cramer <pg(at)fastcrypt(dot)com> writes:
> > You should do a pg_dump all of your database(s) if you want to restore
> > them on to a 7.4 instance.
> > At a minimum, do a pg_dump -s db for the schema, I believe it will dump
> > the users and groups.
> No, pg_dump only dumps what is in a single database.  Users and groups
> span all databases in a cluster, so they are outside the purview of
> pg_dump.  You *must* use pg_dumpall to dump user and group info.
> There is an option to pg_dumpall to dump only this info, and not invoke
> pg_dump on each individual database as it normally would do.
> 			regards, tom lane
Dave Cramer
519 939 0336
ICQ # 14675561

In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2004-03-11 05:55:20
Subject: Re: Register arbitrary types Framework
Previous:From: Markus SchaberDate: 2004-03-10 16:49:58
Subject: Register arbitrary types Framework

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group