pg_restore unexpected end of file

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

Responses

Browse pgsql-general by date

  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