From: | Erik Wienhold <ewie(at)ewie(dot)name> |
---|---|
To: | ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Cannot restore windows dump on linux |
Date: | 2022-10-19 21:14:17 |
Message-ID: | 974394104.123281.1666214057437@office.mailbox.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On 19/10/2022 17:43 CEST ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr wrote:
>
> 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(at)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?
On Windows, did you run pg_dump with --file option or redirect the output to
a file?
pg_dump --file last_backup.bak -U myuser mydb
vs.
pg_dump -U myuser mydb > last_backup.bak
The redirect variant tripped me up before because Windows 10 writes the file as
UTF-16 which is not expected by psql. I don't know if psql can be configured
to handle UTF-16. The redirect is also the cause for CRLF line endings.
--
Erik
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2022-10-19 21:30:58 | Re: Postgres 15 upgrades and template1 public schema |
Previous Message | Ravi Krishna | 2022-10-19 20:44:53 | Re: Speeding up adding fky on a very large table |