Hello,
I am using PostgreSQL 14.5
I tried to move a Linux database to Windows. Both identical version.
Linux dump successfully loaded on Windows system.
Reason for changing system didn’t work out and now I am trying to move it back because it has some modifications.
I just dumped a database backup on windows to a dump file. I see dump file contains “\r\n” as new line identifier (hence windows dump). Just to clarify, this is not \N character I am mixing.
When I try to restore windows dump on regular Linux system, I get a lot of errors and it stops at this one below where this is a pure data load position.
ERROR: syntax error at or near "43589"
LINE 1: 43589 7102e523-f401-4cce-852d-e537f863886f…
I also tried to stop at first error when restoring, in this case it stops at below error
root@app:/home/ek# psql -v ON_ERROR_STOP=1 -U myuser -d mydb < last_backup.bak
SET
SET
SET
SET
SET
set_config
------------
(1 satır)
SET
SET
SET
SET
ERROR: index "ix_xrates_date" does not exist
I searched the internet and I could not solve my problem.
How can I successfully dump on Widnows and restore on Linux?
Any help is appreciated.
Thanks & Regards,
Ertan