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 1oFIEX-0005zo-3R for pgsql-bugs@arkaria.postgresql.org; Sat, 23 Jul 2022 16:44:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oFIEV-0002SK-Br for pgsql-bugs@arkaria.postgresql.org; Sat, 23 Jul 2022 16:44:03 +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 1oFIEV-0002SB-3U for pgsql-bugs@lists.postgresql.org; Sat, 23 Jul 2022 16:44:03 +0000 Received: from mail.thelabyrinth.net ([45.56.70.56]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oFIES-0005zV-Ii for pgsql-bugs@lists.postgresql.org; Sat, 23 Jul 2022 16:44:02 +0000 Received: from [172.20.20.20] (c-24-126-12-186.hsd1.wv.comcast.net [24.126.12.186]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: dsteele) by mail.thelabyrinth.net (Postfix) with ESMTPSA id 2DD2C54664; Sat, 23 Jul 2022 16:43:58 +0000 (UTC) Message-ID: <1bbb2f44-fdf8-71ef-a8f7-24b3fadb3176@pgmasters.net> Date: Sat, 23 Jul 2022 12:43:57 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.11.0 Subject: Re: could not link file in wal restore lines Content-Language: en-US To: Zsolt Ero Cc: pgsql-bugs@lists.postgresql.org, Michael Paquier References: From: David Steele In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/23/22 12:39, Zsolt Ero wrote: >> On 23. Jul 2022 at 15:20:32, David Steele > > wrote: >> Zsolt, can you add --log-level-console=info to your archive_command so >> we can see what parameters are being passed to pgbackrest? > > archive_command = 'pgbackrest --stanza=app --log-level-console=info > archive-push %p' > > on the destination server (where the restore happens). There are no > changes in the log, only 3 lines appear once everything is done. I've > attached the log. Do I need to change this command on the source server? Oops, sorry, I meant the restore_command on the server where you do the restore. You'll need to edit this in postgresql.auto.conf after the pgbackrest restore but before starting PostgreSQL. Regards, -David