From: | Les <nagylzs(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | pg_restore unexpected end of file |
Date: | 2023-09-08 06:29:34 |
Message-ID: | CAKXe9UDLADZT-uqRpJk319m2frYOuxkNpQ3JoVxrufxWhba7-g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm trying to migrate a database from version 11 to version 15.
I have created a dump file on v11:
pg_dump --dbname=not_telling -Fc --no-owner > dump
Then I was trying to import it on v15:
pg_restore -v --dbname=not_telling --no-user /restore/dump
pg_restore: error: could not read from input file: end of file
The file is 525MB. First I thought that maybe the dump is corrupt, so I
re-dumped the db again, but I got the same results. pg_dump does not report
any error, but pg_restore cannot import it.
I can try to export into SQL format, but there is another (much larger)
database that I need to migrate, and it has large binary blobs inside. I
would prefer the custom format.
Is the custom dump format of v11 compatible with v15?
Thank you,
Laszlo
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2023-09-08 06:40:32 | Re: ERROR: stack depth limit exceeded |
Previous Message | Sai Teja | 2023-09-08 05:51:13 | Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL |