| 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: | Whole Thread | Raw Message | 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
| 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 |