My first line should have been pg_dumpall, at any rate, the command tom
is referring to is
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
519 939 0336
ICQ # 14675561
In response to
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2004-03-11 05:55:20|
|Subject: Re: Register arbitrary types Framework|
|Previous:||From: Markus Schaber||Date: 2004-03-10 16:49:58|
|Subject: Register arbitrary types Framework|