Forum OpenACS Q&A: Re: PG 7.2->7.3 upgrade gotcha?

Collapse
34: Re: PG 7.2->7.3 upgrade gotcha? (response to 1)
Posted by Richard Hamilton on 03/23/04 12:40 AM
For any intrepid traveller treading this treacherous path......this is how to get the data.

Since the schema restore worked:

pg_dump -avD yourdatabasename -t cr_revisions -f chooseafilename > chooseafilename.log

This outputs the data as SQL INSERTS. So to restore this you use psql in the normal way.