[SL] Restoring from a pg_dump

[Glen M. <gl...@au...>]

I have a script that backs up my psql databases each night (SL 2.6.27). 
For the first time I tried to restore (because of failed 2.8.0 upgrade) 
from one but it failed. I used this command to create the backup:

    pg_dump -U sql-ledger dea > /spare/backup/postgresql/pgsql-dea_`date
    +%G%m%d`.sql

And then tried to restore as per the manual with:

    psql -U sql-ledger dea < pgsql-dea_20070402.sql


gives lots of:

    invalid command \N
    invalid command \N
    invalid command \N
    invalid command \N
    ERROR:  syntax error at or near "10078" at character 1
    LINE 1: 10078 johne

Restoring from a SL backup works fine but I don't have one that's as 
current as the pg_dump.

Regards Glen


-- 
Glen Morris: Arachnoid Australia
613 90175780 Melbourne | 612 90164032 Sydney
613 98961811 VoIP | Mbl 0419299140
Skype=glenmo. PO Box 214, Healesville VIC 3777, Australia