On Thu, Dec 29, 2011 at 10:20 AM, Greg Donald <gdonald(at)gmail(dot)com> wrote:
> On Wed, Dec 28, 2011 at 4:57 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> < SELECT pg_catalog.setval('cp_state_id_seq', 52, true);
>>> > SELECT pg_catalog.setval('cp_state_id_seq', 1, false);
>> These "grep" calls are showing just exactly not enough to prove
> Those grep calls prove my old backups with 8.4 pg_dump were good to go
> and now they are not with 9.1 pg_dump.
>> I remain unclear as to what state is actually in the
>> database, or what is being dumped,
> The whole thing is being dumped. One command /usr/bin/pg_dump cp,
> that's it, nothing special.
if you take a bzipped schema only dump (pg_dump -s), I'd be happy to
look it over and eliminate the 'operator error' class of issues that
Tom is thinking might be happening. private mail is ok.
In response to
pgsql-general by date
|Next:||From: David Salisbury||Date: 2011-12-29 16:33:58|
|Subject: Re: Refine Form of My querry|
|Previous:||From: Greg Donald||Date: 2011-12-29 16:20:34|
|Subject: Re: PostgreSQL 9.1 pg_dump setval() sets wrong value|