Re: [GENERAL] can't restore database created with pg_dump

2014-09-21 Thread Eric Smith
Thank you for the help! Regards, Eric On Sep 20, 2014, at 6:55 AM, Adrian Klaver wrote: > On 09/19/2014 07:51 PM, Eric Smith wrote: >> All, >> >> I created a backup using pg_dump, postgres 8.3. I'm trying to restore that >> into a new postgres 9.3.5 installation. I just created the default

Re: [GENERAL] can't restore database created with pg_dump

2014-09-20 Thread Adrian Klaver
On 09/20/2014 08:43 AM, Eric Smith wrote: Thank you for the help! For the archives, did you use the 9.3 pg_dump or change the string escaping? Regards, Eric -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] can't restore database created with pg_dump

2014-09-20 Thread Adrian Klaver
On 09/19/2014 07:51 PM, Eric Smith wrote: All, I created a backup using pg_dump, postgres 8.3. I'm trying to restore that into a new postgres 9.3.5 installation. I just created the default text format output with pg_dump, and am trying to restore using psql < dumpfile. First, you should us

[GENERAL] can't restore database created with pg_dump

2014-09-20 Thread Eric Smith
All, I created a backup using pg_dump, postgres 8.3. I'm trying to restore that into a new postgres 9.3.5 installation. I just created the default text format output with pg_dump, and am trying to restore using psql < dumpfile. I have images saved as bytea, and I get the following error when