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 wrote:
> On Friday 25 June 2010 4:59:17 pm Dennis C w
On 26 June 2010 00:59, 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!
>
>
> On Fri, Jun 25, 2010 at 11:29 AM, Adrian Klaver
> wrote:
>>
>> On 0
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:
/op
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!
On Fri, Jun 25, 2010 at 11:29 AM, Adrian Klaver wrote:
> On 06/25/2010 09:04 AM, Dennis C wrote:
>
>> It says "Tradin
On 06/25/2010 09:04 AM, Dennis C wrote:
It says "Trading-Access: gzip compressed data, from Unix"
About the idea of not using pg_restore for these dumps, what I'm still
missing is how it's worked for all these years before. Are there now more
stringent standards being enforced?
You have res
It says "Trading-Access: gzip compressed data, from Unix"
About the idea of not using pg_restore for these dumps, what I'm still
missing is how it's worked for all these years before. Are there now more
stringent standards being enforced?
On Fri, Jun 25, 2010 at 8:37 AM, Thom Brown wrote:
> O
On Fri, 2010-06-25 at 08:28 -0700, Dennis C wrote:
> Greetings;
>
>
> As I've been doing for quite some time, backed up my database as
> such: /opt/local/lib/postgresql84/bin/pg_dump -c -f ./Trading-Access
> -Z 5 Trading-Access
>
>
> But then when I tried restoring it my usual way as
> such: /o
On 25 June 2010 16:28, Dennis C wrote:
> Greetings;
> As I've been doing for quite some time, backed up my database as
> such: /opt/local/lib/postgresql84/bin/pg_dump -c -f ./Trading-Access -Z 5
> Trading-Access
> But then when I tried restoring it my usual way as
> such: /opt/local/lib/postgresql
Greetings;
As I've been doing for quite some time, backed up my database as
such: /opt/local/lib/postgresql84/bin/pg_dump -c -f ./Trading-Access -Z 5
Trading-Access
But then when I tried restoring it my usual way as
such: /opt/local/lib/postgresql84/bin/pg_restore -d Trading-Access
./Trading-Acce
