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@optionshouse.com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email