CODEWITHSUNDEEP
postgresqldatabase-restore
Sangram Anand
Sangram Anand

Reputation: 10844

Error restoring database in Postgresql

I have taken a backup of database using pgAdmin of a postgresql DB. I am trying to restore it on to an another system using

D:\OB_dependencies\DB_Backup>psql -U postgres OpenBravo < OBPOS_DB_BACKUP_23MAY_2013

Some of the tables are created, but script stops with a error

ERROR:  literal carriage return found in data
HINT:  Use "\r" to represent carriage return.
CONTEXT:  COPY ad_session_usage_audit, line 2355

Please suggest me a solutions for this issue. Thanks!!!

Upvotes: 1

Views: 1382

Answers (1)

Gopinagh.R
Gopinagh.R

Reputation: 4916

From postgreSQL mailing list it is stated that:

I'd only expect this if an old pg_dumpall was being used

It occurs, when dealing with a version so old that the behavior of COPY itself was different.

One possible workaround is to use the --inserts option of pg_dump. That will mean slower dump and restore, though.

refer here .

Also worth referring here.

Upvotes: 3

Related Questions