Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lZ9fT-00030t-Mn for pgsql-bugs@arkaria.postgresql.org; Wed, 21 Apr 2021 10:01:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lZ9fS-00021T-MU for pgsql-bugs@arkaria.postgresql.org; Wed, 21 Apr 2021 10:01:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lZ8Fz-00022m-M2 for pgsql-bugs@lists.postgresql.org; Wed, 21 Apr 2021 08:30:47 +0000 Received: from mail-lf1-x131.google.com ([2a00:1450:4864:20::131]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lZ8Fv-0003lf-5Y for pgsql-bugs@lists.postgresql.org; Wed, 21 Apr 2021 08:30:46 +0000 Received: by mail-lf1-x131.google.com with SMTP id q22so3182513lfu.8 for ; Wed, 21 Apr 2021 01:30:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=5+9bCKpoAG5vjCQvJPx1jHIQfrTOBsGjLITbfTisC4o=; b=ZW1xwsrqnHn7gYYmTZSHWEnCvLQd9JhzRMBMVMFRRbhDwFAsH8WwgD+wQn+ZRGJtWA +WQNSxwhrNZX9kKIXP1NWBLrM3fzEVyQR2JR2bGveNbEOs3v3psLxfOlgG6Af9cRfK1b ryEsOWT7oPCQNJFD0ePqkaf56s8RqnJjiH5WBkTg8AaQeqhBGANnXpb/KHcPdF4t5258 vgW8ETMemqUWUOM7lxF7xnNNKeR6y2K+uvVPveNdOCTeaoxMuJuWsA6lHlD+wFzycgSi oDFpACw3VTIw5kqn23j6TJkZkerCYi4zd7d7QRgkfNZO1tXDioIy+/3i8vxzij+B91Bv iEIA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=5+9bCKpoAG5vjCQvJPx1jHIQfrTOBsGjLITbfTisC4o=; b=JWok4MgEOZyUyavDNfnzjPynwbobKWHZRh0Q25g1Pvki3vUAmG4Qcmz5gm3FO9FX/l tcMeokrUsa/lHCU1NEPmhrytdAB1+1fuHIyNp/QQ32ZIUN58W22vLAKwX/tQoSUChO/m RAr/xSD4aOOwRoIAoa77kDFK+q2fGxD/2SLLuM0Y7RMHnTnmVruqe1FhoHSWUlGgblsX JIr0sZr+NNffXHMT24zMPWCzsNcmuEgyfTdqpFg5q0h/tlBn6Qx1e9PppYYDwT4cHiJ6 HkS0HYPwyWXg3KIvy8iP1OWUDeh+5GfOPKUnmBUWor80hDzeWqbm9LqA/VrT8y04G4rX IXTA== X-Gm-Message-State: AOAM531hIAOEnT9NJH+zLsxYVsfpSd16b711AV5kVbd4sABVhPRUwlHA PVSwaBCLy8NmCAfhuODr76YcxHhHYU1r7w== X-Google-Smtp-Source: ABdhPJyM3kH8H9FScykOTkQUSzK9A+SmjdFPdIG6TJiYKZlqFlNvYNlgxc4hqJGKPEyHO8JiAyUx4A== X-Received: by 2002:a05:6512:2243:: with SMTP id i3mr14672404lfu.592.1618993842167; Wed, 21 Apr 2021 01:30:42 -0700 (PDT) Received: from [192.168.0.80] (89-74-134-5.dynamic.chello.pl. [89.74.134.5]) by smtp.gmail.com with ESMTPSA id v14sm143047lfg.56.2021.04.21.01.30.41 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 21 Apr 2021 01:30:41 -0700 (PDT) Subject: Re: BUG #16973: Backward compatibility: pg_restore: [archiver] unsupported version (1.14) in file header To: Tom Lane Cc: pgsql-bugs@lists.postgresql.org References: <16973-399e0677315a26a6@postgresql.org> <632958.1618944492@sss.pgh.pa.us> From: "Piotr F." Message-ID: Date: Wed, 21 Apr 2021 10:31:20 +0200 User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:78.0) Gecko/20100101 Thunderbird/78.9.1 MIME-Version: 1.0 In-Reply-To: <632958.1618944492@sss.pgh.pa.us> Content-Type: text/html; charset=utf-8 Content-Language: pl Content-Transfer-Encoding: 8bit X-Antivirus: AVG (VPS 210404-2, 2021-04-04), Outbound message X-Antivirus-Status: Clean List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Tom,

Thanks, thought the same, but the current pg_dump and pg_restore versions are as follows:

pg_restore -V
pg_restore (PostgreSQL) 10.16 (Ubuntu 10.16-1.pgdg20.04+1)
pg_dump -V
pg_dump (PostgreSQL) 10.16 (Ubuntu 10.16-1.pgdg20.04+1)

Nothing has been changed since the last week in the postgresql versions, including pg_dump and pg_restore.
I use default OpenProject settings, including PostgreSQL, now same 10.16 for the last couple of months.

Also, to make it more complex,
I have restored with no problem the dump from April 8 [that was a life-saver], made with the same pg_dump as this one used on April 12. The latest, however, cannot be restored.

Best,
Piotr

W dniu 2021-04-20 o 20:48, Tom Lane pisze:
PG Bug reporting form <noreply@postgresql.org> writes:
Full dump created on April 12, 2021, default Ubuntu 18.04 LTS, cannot be
restored on April 19, with the current output:

      
psql --version
psql (PostgreSQL) 10.16 (Ubuntu 10.16-1.pgdg20.04+1)

      
pg_restore returns:
pg_restore: [archiver] unsupported version (1.14) in file header
The most obvious explanation for this is that you made the dump
with a v12-or-later pg_dump, and are now trying to restore it
with a pre-v12 pg_restore.  If so, the failure is expected.

			regards, tom lane


Wolny od wirusów. www.avg.com