Re: pg_dump: [archiver] -C and -c are incompatible options

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump: [archiver] -C and -c are incompatible options
Date: 2014-09-24 12:15:02
Message-ID: 13695.1411560902@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> Tom Lane-2 wrote
>> Like it says, you should not use both the -C and -c command-line options
>> to pg_dump. I'm not sure how that translates to what you're doing in
>> pgAdmin3, but presumably you're selecting some incompatible options there.
>>
>> You might want to gripe about it on the pgadmin mailing list (not here),
>> as it seems like they could provide a more user-friendly complaint.

> What version of PostgreSQL?
> 9.3 documentation indicates that using both together should work.

Oh, I'd forgotten that, but you're right. A quick test shows that it
changed in 9.2.

> Are you maybe hitting an older database with a newer version of pgadmin?

Older pg_dump in particular. Seems like a good bet.

A gripe to the pgadmin folks might still be in order; I'd think it was
within their charter to shield users from this sort of version
compatibility consideration.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Bandy 2014-09-24 12:45:27 Custom type literal conversion
Previous Message Thomas Kellerer 2014-09-24 08:08:59 Synchronous replication + pgPool: not all transactions immediately visible on standby