Re: Backup of users and groups? - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Backup of users and groups?
Date
Msg-id 1078924476.3488.147.camel@localhost.localdomain
Whole thread Raw
In response to Backup of users and groups?  (Bjørn T Johansen <btj@havleik.no>)
Responses Re: Backup of users and groups?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Backup of users and groups?  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Bjorn,

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.

Dave
On Wed, 2004-03-10 at 07:59, Bjørn T Johansen wrote:
> Is it enough to just copy pg_group and pg_pwd to backup users and groups
> and to copy those files back to restore?
> Will this also work from 7.3.x to 7.4.x?
>
>
> Regards,
>
> BTJ
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>
--
Dave Cramer
519 939 0336
ICQ # 14675561


pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: two dimensional arrays supported?
Next
From: Oliver Jowett
Date:
Subject: Re: Upgrading from 7.3.4 til 7.4.x?