| 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: | Whole Thread | Raw Message | 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 |