pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sergey KOPOSOV <Sergey.Koposov@ed.ac.uk>
To: tgl@sss.pgh.pa.us <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #16951: pg_restore segfaults on custom format piped from a different version of PG
Date: Wed, 31 Mar 2021 22:52:14 +0000
Message-ID: <d8930bce790cbe14f5efed8d5d42f296a1fe54fe.camel@ed.ac.uk> (raw)
In-Reply-To: <3338139.1617230824@sss.pgh.pa.us>
References: <16951-a4dd68cf0de23048@postgresql.org>
	<3331060.1617226031@sss.pgh.pa.us>
	<5d848bddbb3b6421af5a742e36ede542e719c492.camel@ed.ac.uk>
	<3338139.1617230824@sss.pgh.pa.us>

On Wed, 2021-03-31 at 18:47 -0400, Tom Lane wrote:
> This email was sent to you by someone outside the University.
> You should only click on links or attachments if you are certain that the email is genuine and the content is safe.
>
> Sergey KOPOSOV <Sergey.Koposov@ed.ac.uk> writes:
> > I also noticed when I tried to run pg_restore in the debugger the crash doesn't happen.
> > but it does if I pipe it...
>
> I wonder if your platform is helpfully inserting Windows newlines,
> or perhaps removing them, when the data goes through a pipe.

The platform doing the pg_dump (PG12) is debian
And the one doing pg_restore (PG10) is ubuntu.

Also I know for sure when I use pg_restore from postgresql 12 it works fine in the same configuration.
(And I've regularly transferred tables this way from one system to another, it's just I've recently
migrated the debian system from PG11 to PG12 which lead to this segfault.)

      S
The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336. Is e buidheann carthannais a th’ ann an Oilthigh Dhùn Èideann, clàraichte an Alba, àireamh clàraidh SC005336.


view thread (9+ messages)  latest in thread

Message-ID: <d8930bce790cbe14f5efed8d5d42f296a1fe54fe.camel@ed.ac.uk>
Permalink:  ../d8930bce790cbe14f5efed8d5d42f296a1fe54fe.camel@ed.ac.uk/
Also on:    postgresql.org/message-id/d8930bce790cbe14f5efed8d5d42f296a1fe54fe.camel@ed.ac.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: Sergey.Koposov@ed.ac.uk, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #16951: pg_restore segfaults on custom format piped from a different version of PG
  In-Reply-To: <d8930bce790cbe14f5efed8d5d42f296a1fe54fe.camel@ed.ac.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox