Search Postgresql Archives

Re: Frustrated...pg_dump/restore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Oct 6, 2008, at 9:11 AM, Jeff Amiel wrote:


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.




I think you want top use pg_restore, the default of pg_dump is a binary output and you cannot pipe it to psql

Ries









[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux