Frustrated...pg_dump/restore

From: Jeff Amiel <becauseimjeff(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Frustrated...pg_dump/restore
Date: 2008-10-06 14:11:46
Message-ID: 481635.49973.qm@web65501.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I performed a pg_dump on a database and created a new schema-only database to copy that data into.

However trying to use psql -f to load the data in, I get a plethora of syntax errors including the dreaded "invalid command \N".

I even tried to pipe the pg_dump results directly into the psql command....

/usr/local/pgsql/bin/pg_dump -U pgsql --data-only db1 | /usr/local/pgsql/bin/psql -U pgsql db2

Same results.

Why?

using -d (switching to inserts instead of COPY) seems to work just fine but is so slow as to be unusable.

Is the COPY pg_dump method useful at all in ANY situation?

Do I have to do a pg_dump using a custom archive option and use pg_resore to make this work? (sounds silly to me).

Any help would be appreciated.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Amiel 2008-10-06 14:12:06 function returning setof..select versus select * from
Previous Message Raymond O'Donnell 2008-10-06 13:12:50 Re: restore a dump db from tar file