Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gk4Xy-0002Uc-Nb for pgsql-admin@arkaria.postgresql.org; Thu, 17 Jan 2019 10:05:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gk4Xx-0007Gh-B0 for pgsql-admin@arkaria.postgresql.org; Thu, 17 Jan 2019 10:05:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gk4Xw-0007GZ-W4 for pgsql-admin@lists.postgresql.org; Thu, 17 Jan 2019 10:05:13 +0000 Received: from mail-pl1-x635.google.com ([2607:f8b0:4864:20::635]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gk4Xi-0002vO-GS for pgsql-admin@lists.postgresql.org; Thu, 17 Jan 2019 10:05:11 +0000 Received: by mail-pl1-x635.google.com with SMTP id t13so4509094ply.13 for ; Thu, 17 Jan 2019 02:04:57 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=message-id:mime-version:to:cc:from:subject:date:importance :in-reply-to:references; bh=9s6J6VFWUEMsUzepTXGjm8G5m1RPmdmbywFDCfAqXHA=; b=kJ+oDF3Fd6DGSSH3jsfQLpOiDE+kNfJWDNzNCvtc7ibfM1WEpUxxf/RSS9SnOHnEW7 +9HOGRQsBMiVz65dL7Z5t34ObchyKLQ1/lgQkDdlBPshqBIPJxNF98JaiSOWtKuz7uot A5eMV6V5PQOb6IeBGaWYqE+JTatPr7D61c9xZbVQnQlcczPCF2XrXcKC2yGADva9zW+k DRuv63Fj5BzSwwal10kCzlMB7CBl0xOB/l5EBEcPs1STLGWCIcTJMOP5b+0bVnSqusaZ FnxYvC7e5MzwGZWPufm+dAT31CC5F7MKpRTzMKV2Xu7FwXc6lyrb0Sc616ArXxIBshOZ HdSg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:mime-version:to:cc:from:subject:date :importance:in-reply-to:references; bh=9s6J6VFWUEMsUzepTXGjm8G5m1RPmdmbywFDCfAqXHA=; b=V+HCHzOrgkG29cI7UYNPnlucaWtYMZEo/I+6d69/KMfgfhorbISVhAZaMq2rlx+WxS /zu5eEfIydtymaJ0b6go6Xd2UNAs+xMAjR5oNtfjqSye3p5dIIy4Ih4x2nfNsFV8KLJs 8XP0gwYLHpjgB8AlUc0WaBKPe1XdpX5XA8omBg8u55RT4AOcfply/49OcrMP68AA7l40 FTvxEhS/N30CtcwDdUnwS4UMZNPOX51fOb6D3yIEBYsh1/DjttjTQvFno/jTHihSzzEU YpAbVhaO3YmSIOfKe/GIPl9DrumMbz2k3rx3ShRICtdQZQ3aHTECu7FDMhAfhHC/4y4e q/uQ== X-Gm-Message-State: AJcUukdgo8ceR26fwtsrYN86BdNWBSq5CtMeMEANIGSGi8swHG+ZJ70K UtNnQ9GEosefQdKRu9i6MbM= X-Google-Smtp-Source: ALg8bN5NEBAdbuwDZsY82ORVSLhgYzDh02oU7Zb3/eg/9sF06ujvu3cEIXvX02Kl5Zbm3jtJAzEMVA== X-Received: by 2002:a17:902:d68c:: with SMTP id v12mr14271239ply.4.1547719496001; Thu, 17 Jan 2019 02:04:56 -0800 (PST) Received: from ?IPv6:::ffff:192.168.0.5? ([103.255.145.162]) by smtp.gmail.com with ESMTPSA id h129sm3280342pfb.110.2019.01.17.02.04.53 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 17 Jan 2019 02:04:55 -0800 (PST) Message-ID: <5c405347.1c69fb81.97067.8090@mx.google.com> MIME-Version: 1.0 To: Fabio Pardi Cc: "pgsql-admin@lists.postgresql.org" From: malli Subject: RE: archive command failed with exit code 1 Date: Thu, 17 Jan 2019 15:34:52 +0530 Importance: normal X-Priority: 3 In-Reply-To: References: <81cf3210-69ba-cb62-6868-2995a75bf4c0@portavita.eu> Content-Type: multipart/alternative; boundary="_2DD0FD71-EF1E-4C1A-A01B-E6A62221D998_" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_2DD0FD71-EF1E-4C1A-A01B-E6A62221D998_ Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" Hi, >=20 > This is Mallikarjunarao. Currently I am using PostgreSQL 9.6.10 version. > In=C2=A0 SSL streaming replication I am facing following issues. >=20 > alter system set archive_command to 'scp %p > postgres@192.168.59.149:/home/postgres/data_archive/%f'; >=20 > <2019-01-15 21:38:38.648 IST [4599]>LOG:=C2=A0 connection received: > host=3D192.168.59.149 port=3D41464 > <2019-01-15 21:38:38.656 IST [4599]>LOG:=C2=A0 replication connection > authorized: user=3Dpostgres > Permission denied, please try again. > Permission denied, please try again. > Permission denied (publickey,gssapi-keyex,gssapi-with-mic,password). > lost connection > <2019-01-15 21:38:38.950 IST [4333]>LOG:=C2=A0 archive command failed wit= h > exit code 1 > <2019-01-15 21:38:38.950 IST [4333]>DETAIL:=C2=A0 The failed archive comm= and > was: scp pg_xlog/000000010000000000000001 > postgres@192.168.59.149:/home/postgres/data_archive/000000010000000000000= 001 >=20 >=20 > I am searching error information but I didn't know that? Could you > please help me out situation ? This is the primary server information =C2=A0 =C2=A0 =C2=A0 =C2=A0=C2=A0[postgres@localhost pg_xlog]$ scp 00000001= 0000000000000002 postgres@192.168.59.149:/home/postgres/data_archive/ postgres@192.168.59.149's password: Permission denied, please try again. postgres@192.168.59.149's password: 000000010000000000000002=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 100%=C2=A0= =C2=A0 16MB=C2=A0=C2=A0 8.0MB/s=C2=A0=C2=A0 00:02 [postgres@localhost pg_xlog]$ In primary server pg_log file I got the error msgs are above. Sent from Mail for Windows 10 From: Fabio Pardi Sent: Thursday, January 17, 2019 2:02 PM To: mallikarjun t Cc: pgsql-admin@lists.postgresql.org Subject: Re: archive command failed with exit code 1 Hi, please keep the list posted, it might help other people too. I m adding the= list in cc. from what=C2=A0 you posted here below, my initial guess was right. You need= to make sure the file copy is unattended.=20 regards, fabio pardi On 16/01/2019 16:53, mallikarjun t wrote: Hi, =C2=A0 =C2=A0 =C2=A0 =C2=A0=C2=A0[postgres@localhost pg_xlog]$ scp 00000001= 0000000000000002 postgres@192.168.59.149:/home/postgres/data_archive/ postgres@192.168.59.149's password: Permission denied, please try again. postgres@192.168.59.149's password: 000000010000000000000002=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 100%=C2=A0= =C2=A0 16MB=C2=A0=C2=A0 8.0MB/s=C2=A0=C2=A0 00:02 [postgres@localhost pg_xlog]$ On Wed, Jan 16, 2019 at 9:15 PM Fabio Pardi wrote: Hi Mallikarjunarao, Wild guess: you missed to exchange the SSH key between servers. To find out where the problem is, you can try to run the archive command by hand and see the output. As in: login on the master db as the user running postgres and try to scp a file to: postgres@192.168.59.149:/home/postgres/data_archive see what happens, and post it back here. regards, fabio pardi On 1/16/19 4:38 PM, mallikarjun t wrote: > Hi, >=20 > This is Mallikarjunarao. Currently I am using PostgreSQL 9.6.10 version. > In=C2=A0 SSL streaming replication I am facing following issues. >=20 > alter system set archive_command to 'scp %p > postgres@192.168.59.149:/home/postgres/data_archive/%f'; >=20 > <2019-01-15 21:38:38.648 IST [4599]>LOG:=C2=A0 connection received: > host=3D192.168.59.149 port=3D41464 > <2019-01-15 21:38:38.656 IST [4599]>LOG:=C2=A0 replication connection > authorized: user=3Dpostgres > Permission denied, please try again. > Permission denied, please try again. > Permission denied (publickey,gssapi-keyex,gssapi-with-mic,password). > lost connection > <2019-01-15 21:38:38.950 IST [4333]>LOG:=C2=A0 archive command failed wit= h > exit code 1 > <2019-01-15 21:38:38.950 IST [4333]>DETAIL:=C2=A0 The failed archive comm= and > was: scp pg_xlog/000000010000000000000001 > postgres@192.168.59.149:/home/postgres/data_archive/000000010000000000000= 001 >=20 >=20 > I am searching error information but I didn't know that? Could you > please help me out situation ? >=20 > ThanksAndRegards, > Mallikarjunarao. > **//___^ --_2DD0FD71-EF1E-4C1A-A01B-E6A62221D998_ Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="utf-8"

Hi,
>
> This is Mallika= rjunarao. Currently I am using PostgreSQL 9.6.10 version.
> In  = SSL streaming replication I am facing following issues.
>
> al= ter system set archive_command to 'scp %p
> postgres@192.168.59.149:= /home/postgres/data_archive/%f';
>
> <2019-01-15 21:38:= 38.648 IST [4599]>LOG:  connection received:
> host=3D192.168= .59.149 port=3D41464
> <2019-01-15 21:38:38.656 IST [4599]>LOG:=   replication connection
> authorized: user=3Dpostgres
> P= ermission denied, please try again.
> Permission denied, please try a= gain.
> Permission denied (publickey,gssapi-keyex,gssapi-with-mic,pas= sword).
> lost connection
> <2019-01-15 21:38:38.950 IST [43= 33]>LOG:  archive command failed with
> exit code 1
> &= lt;2019-01-15 21:38:38.950 IST [4333]>DETAIL:  The failed archive c= ommand
> was: scp pg_xlog/000000010000000000000001
> postgres@192.168.59.149:/home/postgres/data_archive/000000010000= 000000000001
>
>
> I am searching error information= but I didn't know that? Could you
> please help me out situation ?

This is the primar= y server information

 

        [postgres@localhost pg_= xlog]$ scp 000000010000000000000002 postgres@192.168.59.149:/home/postgres/dat= a_archive/
postgres@192.1= 68.59.149's password:
Permission denied, please try again.
postgres@192.168.59.149's password= :
000000010000000000000002       &nbs= p;            &= nbsp;           &nbs= p;            100%&n= bsp;  16MB   8.0MB/s   00:02
[postgres@localhos= t pg_xlog]$

 

In primary server pg_log file I got the error msgs are above.=

 

&nb= sp;

Sent from Mail for Windows 10

 

From: Fabio Pardi
Sent: Thursday, January 17, 20= 19 2:02 PM
To: mallikarjun= t
Cc: pg= sql-admin@lists.postgresql.org
Subject: Re: archive command f= ailed with exit code 1

 

<= p class=3DMsoNormal style=3D'margin-bottom:12.0pt'>Hi,

please keep the list posted, it mig= ht help other people too. I m adding the list in cc.


from= what  you posted here below, my initial guess was right. You need to = make sure the file copy is unattended.

regards,

fabio pardi<= br>

On 16/01/2019 16:53, mallik= arjun t wrote:

Hi,

 

        [postgres@localhost pg_xlog]$ scp = 000000010000000000000002 postgres@192.168.59.149:/home/postgres/data_archive/<= /a>
postgres@192.168.59.149's password:
Permission denied, please try again.
postgres@192.168.59.149's password:
000000= 010000000000000002         &nb= sp;            =             &nb= sp;          100%   = 16MB   8.0MB/s   00:02
[postgres@localhost pg_xlog]$=

 

=

On Wed, Jan 16, 2019 at 9:15 PM Fabio Pardi = <f.pardi@portavita.eu> wr= ote:

Hi Mallikarjunarao,
Wild guess: you missed to exchange the SSH key between servers.
To find out where the problem is, you can try to run the archive command<= br>by hand and see the output. As in:

login on the master db as the = user running postgres and try to scp a
file to:

postgres@192.168.59.1= 49:/home/postgres/data_archive

see what happens, and post it bac= k here.

regards,

fabio pardi



On 1/16/19 4:38 P= M, mallikarjun t wrote:
> Hi,
>
> This is Mallikarjunara= o. Currently I am using PostgreSQL 9.6.10 version.
> In  SSL str= eaming replication I am facing following issues.
>
> alter sys= tem set archive_command to 'scp %p
> postgres@192.168.59.149:/home/p= ostgres/data_archive/%f';
>
> <2019-01-15 21:38:38.648 = IST [4599]>LOG:  connection received:
> host=3D192.168.59.149= port=3D41464
> <2019-01-15 21:38:38.656 IST [4599]>LOG:  = replication connection
> authorized: user=3Dpostgres
> Permissi= on denied, please try again.
> Permission denied, please try again.> Permission denied (publickey,gssapi-keyex,gssapi-with-mic,password).=
> lost connection
> <2019-01-15 21:38:38.950 IST [4333]>= LOG:  archive command failed with
> exit code 1
> <2019= -01-15 21:38:38.950 IST [4333]>DETAIL:  The failed archive command<= br>> was: scp pg_xlog/000000010000000000000001
> postgres@192.168.59.149:/home/postgres/data_archive/0000000100000000000= 00001
>
>
> I am searching error information but I = didn't know that? Could you
> please help me out situation ?
> =
> ThanksAndRegards,
> Mallikarjunarao.
> **//___^

 

 

= --_2DD0FD71-EF1E-4C1A-A01B-E6A62221D998_--