Re: PG dump and restore

[Dennis C <dcswest@xxxxxxxxx>]

That was it exactly as I just tested the entire process and it all worked fine again.  For some reason, I inadvertently replaced the "-Fc" part with a "-c" somewhere along the way.  Thanks again!

On Fri, Jun 25, 2010 at 5:18 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:

On Friday 25 June 2010 4:59:17 pm Dennis C wrote:
> OK well the gunzip seemed to "do the trick," but I don't recall before
> having to do anything other than run the pg_restore command.  Anyway,
> thanks to everyone for all your help!

My guess is that previously the dump command was actually:

/opt/local/lib/postgresql84/bin/pg_dump -Fc -f ./Trading-Access -Z 5
Trading-Access




--

Adrian Klaver
adrian.klaver@xxxxxxxxx