Search Postgresql Archives

Re: Problem loading pg_dump file

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

 



"Mason Hale" <masonhale@xxxxxxxxx> writes:
> I'm having a problem loading a recent pg_dump of our production database.

> However, when trying to load the file for this month's snapshot, we are (for
> the first time) seeing a slew of errors, such as:

> invalid command \N
> invalid command \N
> ERROR:  syntax error at or near ""/>\n  <img alt="" style="" at character 1
> LINE 1: "/>\n  <img alt="" style="border: 0;
>         ^

You need to look at the very first error, and ignore the slew following
it.  What seems to have happened here is that an error in the COPY command
caused psql to fall out of copy mode (or perhaps never enter it in the
first place) and start trying to treat lines of COPY data as SQL
commands.  So, tons of noise.  What was the first error?

			regards, tom lane


[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