Re: pg_dump and ON DELETE CASCADE problem

From: John R Pierce <pierce(at)hogranch(dot)com>
To: cgg007(at)yahoo(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump and ON DELETE CASCADE problem
Date: 2009-12-10 20:29:33
Message-ID: 4B215A2D.10505@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

CG wrote:
> Thanks for the suggestion. I'm not sure what you mean when you say I should restore to a file. Do you mean I should dump the database to an SQL file instead of the "compressed" format?
>

he meant...

pg_restore -f outputfile.sql yourdumpfile

this will convert the dumpfile to SQL...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eric B. Ridge 2009-12-10 21:11:42 Postgres "locked up"
Previous Message CG 2009-12-10 20:21:44 Re: pg_dump and ON DELETE CASCADE problem