Re: cant get pg_dump/pg_restore to behave

"Mike Frysinger"  writes:
> On 4/20/07, Tom Lane  wrote:
>> Hmph.  It should pretty much just work ... and there is *definitely* not
>> any update command visible in the source code.

> i dug deeper (like i should have in the first place) and the UPDATEs
> are ok ... they're inside of functions which get triggered on events

Doh, I should have thought of that.

>> If there's not anything confidential about your schema, could you send
>> me the output of "pg_dump -s" on the problem database?  Maybe seeing a
>> fuller picture will yield a clue.

> the schema shouldnt be a problem ... just the data :)

Well, I loaded and dumped and reloaded this schema in 8.1 without any
problem, so I'm still baffled.

Looking back at your original message, you say

>> $ pg_dump -F c -s -d database-server mydb > mydb.schema
>> $ psql -d mydb < mydb.schema
>> 

There are several obvious things wrong with that (eg, psql cannot read
-Fc format dumps) so I suppose it's an editorialization on what you
really typed.  Perhaps the problem is hidden there.  Can you show us an
*exact* transcript of a failing session?

			regards, tom lane