Re: Moving from Java 1.5 to Java 1.6

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