Обсуждение: Restore postgres database problem

Поиск
Список
Период
Сортировка

Restore postgres database problem

От
Inpreet Singh
Дата:
Hello,
I am using postgres 7.3.4. I am trying to restore database dump using psql command but getting following error.
 
Taken Dump :   /usr/bin/pg_dumpall > /home/inpreet/postgres.sql
Restoring Dump :   su - postgres
/usr/local/pgsql/bin/psql -d template1 < /home/inpreet/postgres.sql
 
but getting error
ERROR:  copy: line 32, Bad date external representation '\N
lost synchronization with server, resetting connection
 
Please tell me which way to go.
 
Thanks and Regards
Inpreet Singh