| From: | Shaun Thomas <sthomas(at)optionshouse(dot)com> |
|---|---|
| To: | David Fetter <david(at)fetter(dot)org> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Moving from Java 1.5 to Java 1.6 |
| Date: | 2012-10-04 15:45:43 |
| Message-ID: | 506DAF27.9010208@optionshouse.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/04/2012 10:13 AM, David Fetter wrote:
> For each database on the 7.4 machine, run the following on the 9.2
> machine:
>
> pg_dump -h name.of.7.4.machine.com -U postgres -Fc --file=mydb.dump mydb
Don't forget the global settings:
pg_dumpall -g -U postgres -f globals.sql
And you should probably restore it *before* the rest of the databases,
since it contains users, groups, and so on, necessary for permissions to
be correct following the database restore.
pg_restore -U postgres globals.sql
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas(at)optionshouse(dot)com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2012-10-04 16:17:34 | Re: Thousands of schemas and ANALYZE goes out of memory |
| Previous Message | Pavel Stehule | 2012-10-04 15:39:21 | Re: Return dynamic columns of a temporary table |