Re: PG dump and restore

From: Dennis C <dcswest(at)gmail(dot)com>
To: adrian(dot)klaver(at)gmail(dot)com
Cc: questions(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: PG dump and restore
Date: 2010-06-28 20:01:05
Message-ID: AANLkTinkRtjLN4OkvjhuHFte5MSbYW-gOCcngI9pxaKc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)gmail(dot)com>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(dot)klaver(at)gmail(dot)com
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey 2010-06-28 20:38:16 Re: weird initdb output
Previous Message Igor Neyman 2010-06-28 19:58:58 Re: postgres user password: Log on failure