| From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
|---|---|
| To: | Bjørn T Johansen <btj(at)havleik(dot)no> |
| Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: Backup of users and groups? |
| Date: | 2004-03-10 13:14:37 |
| Message-ID: | 1078924476.3488.147.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Jowett | 2004-03-10 13:15:50 | Re: Upgrading from 7.3.4 til 7.4.x? |
| Previous Message | Oliver Jowett | 2004-03-10 13:09:53 | Re: two dimensional arrays supported? |