Re: BUG #17156: pg_restore: [custom archiver] WARNING: ftell mismatch with expected position -- ftell used

On Mon, Aug 23, 2021 at 7:31 PM PG Bug reporting form
<noreply(at)postgresql(dot)org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference: 17156
> Logged by: Ashutosh Kumar
> Email address: ashutosh(dot)kumar(at)morningstar(dot)com
> PostgreSQL version: 10.18
> Operating system: RHEL
> Description:
>
> Getting below warning when I am restoring the backup file :
>
> Warning Message : pg_restore: [custom archiver] WARNING: ftell mismatch with
> expected position -- ftell used
>
> Backup was taken with below command :
>
> pg_dump -h'127.0.0.1' -p 5432 -U (username) -Fc databasename >
> backupfile.sql
>
> I am restoring it with pg_restore when i got the above warning.

Could you share the exact pg_restore command with the arguments you executed?

What's is the size of the backup? Are both Postgres servers that you
took/restored the backup from/to are RHEL?

Could you try to execute pg_dump without a pipe and restore it and see
the same error happens? That is, please execute "pg_dump -h'127.0.0.1'
-p 5432 -U (username) -Fc databasename -f backupfile.sql".

Regards,

--
Masahiko Sawada
EDB: https://www.enterprisedb.com/