pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedarchive command failed with exit code 1
7+ messages / 4 participants
[nested] [flat]
* archive command failed with exit code 1
@ 2019-01-16 15:38 mallikarjun t <mallit333@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: mallikarjun t @ 2019-01-16 15:38 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi,
This is Mallikarjunarao. Currently I am using PostgreSQL 9.6.10 version.
In SSL streaming replication I am facing following issues.
alter 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=192.168.59.149 port=41464
<2019-01-15 21:38:38.656 IST [4599]>LOG: replication connection
authorized: user=postgres
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: archive command failed with exit
code 1
<2019-01-15 21:38:38.950 IST [4333]>DETAIL: The failed archive command
was: scp pg_xlog/000000010000000000000001 postgres@192.168.59.149:
/home/postgres/data_archive/000000010000000000000001
I am searching error information but I didn't know that? Could you please
help me out situation ?
ThanksAndRegards,
Mallikarjunarao.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: archive command failed with exit code 1
@ 2019-01-16 15:45 Fabio Pardi <f.pardi@portavita.eu>
parent: mallikarjun t <mallit333@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Fabio Pardi @ 2019-01-16 15:45 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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,
>
> This is Mallikarjunarao. Currently I am using PostgreSQL 9.6.10 version.
> In SSL streaming replication I am facing following issues.
>
> alter 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=192.168.59.149 port=41464
> <2019-01-15 21:38:38.656 IST [4599]>LOG: replication connection
> authorized: user=postgres
> 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: archive command failed with
> exit code 1
> <2019-01-15 21:38:38.950 IST [4333]>DETAIL: The failed archive command
> was: scp pg_xlog/000000010000000000000001
> postgres@192.168.59.149:/home/postgres/data_archive/000000010000000000000001
>
>
> I am searching error information but I didn't know that? Could you
> please help me out situation ?
>
> ThanksAndRegards,
> Mallikarjunarao.
> **//___^
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: archive command failed with exit code 1
@ 2019-01-17 08:32 Fabio Pardi <f.pardi@portavita.eu>
parent: Fabio Pardi <f.pardi@portavita.eu>
0 siblings, 1 reply; 7+ messages in thread
From: Fabio Pardi @ 2019-01-17 08:32 UTC (permalink / raw)
To: mallikarjun t <mallit333@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi,
please keep the list posted, it might 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
On 16/01/2019 16:53, mallikarjun t wrote:
> Hi,
>
> [postgres@localhost pg_xlog]$ scp 000000010000000000000002 postgres@192.168.59.149:/home/postgres/data_archive/
> postgres@192.168.59.149 <mailto:postgres@192.168.59.149>'s password:
> Permission denied, please try again.
> postgres@192.168.59.149 <mailto:postgres@192.168.59.149>'s password:
> 000000010000000000000002 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 <mailto:f.pardi@portavita.eu>> 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,
> >
> > This is Mallikarjunarao. Currently I am using PostgreSQL 9.6.10 version.
> > In SSL streaming replication I am facing following issues.
> >
> > alter 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=192.168.59.149 port=41464
> > <2019-01-15 21:38:38.656 IST [4599]>LOG: replication connection
> > authorized: user=postgres
> > 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: archive command failed with
> > exit code 1
> > <2019-01-15 21:38:38.950 IST [4333]>DETAIL: The failed archive command
> > was: scp pg_xlog/000000010000000000000001
> > postgres@192.168.59.149:/home/postgres/data_archive/000000010000000000000001
> >
> >
> > I am searching error information but I didn't know that? Could you
> > please help me out situation ?
> >
> > ThanksAndRegards,
> > Mallikarjunarao.
> > **//___^
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: archive command failed with exit code 1
@ 2019-01-17 10:04 malli <mallit333@gmail.com>
parent: Fabio Pardi <f.pardi@portavita.eu>
0 siblings, 0 replies; 7+ messages in thread
From: malli @ 2019-01-17 10:04 UTC (permalink / raw)
To: Fabio Pardi <f.pardi@portavita.eu>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi,
>
> This is Mallikarjunarao. Currently I am using PostgreSQL 9.6.10 version.
> In SSL streaming replication I am facing following issues.
>
> alter 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=192.168.59.149 port=41464
> <2019-01-15 21:38:38.656 IST [4599]>LOG: replication connection
> authorized: user=postgres
> 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: archive command failed with
> exit code 1
> <2019-01-15 21:38:38.950 IST [4333]>DETAIL: The failed archive command
> was: scp pg_xlog/000000010000000000000001
> postgres@192.168.59.149:/home/postgres/data_archive/000000010000000000000001
>
>
> I am searching error information but I didn't know that? Could you
> please help me out situation ?
This is the primary server information
[postgres@localhost pg_xlog]$ scp 000000010000000000000002 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 100% 16MB 8.0MB/s 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 you posted here below, my initial guess was right. You need to make sure the file copy is unattended.
regards,
fabio pardi
On 16/01/2019 16:53, mallikarjun t wrote:
Hi,
[postgres@localhost pg_xlog]$ scp 000000010000000000000002 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 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> 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,
>
> This is Mallikarjunarao. Currently I am using PostgreSQL 9.6.10 version.
> In SSL streaming replication I am facing following issues.
>
> alter 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=192.168.59.149 port=41464
> <2019-01-15 21:38:38.656 IST [4599]>LOG: replication connection
> authorized: user=postgres
> 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: archive command failed with
> exit code 1
> <2019-01-15 21:38:38.950 IST [4333]>DETAIL: The failed archive command
> was: scp pg_xlog/000000010000000000000001
> postgres@192.168.59.149:/home/postgres/data_archive/000000010000000000000001
>
>
> I am searching error information but I didn't know that? Could you
> please help me out situation ?
>
> ThanksAndRegards,
> Mallikarjunarao.
> **//___^
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: archive command failed with exit code 1
@ 2019-01-17 11:09 Shreeyansh Dba <shreeyansh2014@gmail.com>
parent: mallikarjun t <mallit333@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Shreeyansh Dba @ 2019-01-17 11:09 UTC (permalink / raw)
To: mallikarjun t <mallit333@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi Mallikarjunarao,
It looks ssh-keygen does not set between your postgres users and make sure
you are entering the correct password.
Also, verify postgres user owner permission for the target archive
directory if not.
Go through the below link for ssh-keygen.
https://www.digitalocean.com/community/tutorials/how-to-configure-ssh-key-based-authentication-on-a-...
Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com
On Wed, Jan 16, 2019 at 9:08 PM mallikarjun t <mallit333@gmail.com> wrote:
> Hi,
>
> This is Mallikarjunarao. Currently I am using PostgreSQL 9.6.10 version.
> In SSL streaming replication I am facing following issues.
>
> alter 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=192.168.59.149 port=41464
> <2019-01-15 21:38:38.656 IST [4599]>LOG: replication connection
> authorized: user=postgres
> 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: archive command failed with exit
> code 1
> <2019-01-15 21:38:38.950 IST [4333]>DETAIL: The failed archive command
> was: scp pg_xlog/000000010000000000000001 postgres@192.168.59.149:
> /home/postgres/data_archive/000000010000000000000001
>
>
> I am searching error information but I didn't know that? Could you please
> help me out situation ?
>
> ThanksAndRegards,
> Mallikarjunarao.
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: archive command failed with exit code 1
@ 2019-01-17 11:13 mallikarjun t <mallit333@gmail.com>
parent: Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: mallikarjun t @ 2019-01-17 11:13 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Thanks, I will check it out.
On Thu, Jan 17, 2019 at 4:39 PM Shreeyansh Dba <shreeyansh2014@gmail.com>
wrote:
> Hi Mallikarjunarao,
>
> It looks ssh-keygen does not set between your postgres users and make sure
> you are entering the correct password.
>
> Also, verify postgres user owner permission for the target archive
> directory if not.
>
> Go through the below link for ssh-keygen.
>
>
> https://www.digitalocean.com/community/tutorials/how-to-configure-ssh-key-based-authentication-on-a-...
>
> Thanks & Regards,
> *Shreeyansh DBA Team*
> www.shreeyansh.com
>
>
> On Wed, Jan 16, 2019 at 9:08 PM mallikarjun t <mallit333@gmail.com> wrote:
>
>> Hi,
>>
>> This is Mallikarjunarao. Currently I am using PostgreSQL 9.6.10 version.
>> In SSL streaming replication I am facing following issues.
>>
>> alter 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=192.168.59.149 port=41464
>> <2019-01-15 21:38:38.656 IST [4599]>LOG: replication connection
>> authorized: user=postgres
>> 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: archive command failed with
>> exit code 1
>> <2019-01-15 21:38:38.950 IST [4333]>DETAIL: The failed archive command
>> was: scp pg_xlog/000000010000000000000001 postgres@192.168.59.149:
>> /home/postgres/data_archive/000000010000000000000001
>>
>>
>> I am searching error information but I didn't know that? Could you please
>> help me out situation ?
>>
>> ThanksAndRegards,
>> Mallikarjunarao.
>>
>>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: archive command failed with exit code 1
@ 2019-01-17 14:42 mallikarjun t <mallit333@gmail.com>
parent: mallikarjun t <mallit333@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: mallikarjun t @ 2019-01-17 14:42 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi,
I resolved my issue. Everyone to thanks a lot.
ThanksAndRegards,
Mallikarjunarao.
On Thu, Jan 17, 2019 at 4:43 PM mallikarjun t <mallit333@gmail.com> wrote:
> Thanks, I will check it out.
>
> On Thu, Jan 17, 2019 at 4:39 PM Shreeyansh Dba <shreeyansh2014@gmail.com>
> wrote:
>
>> Hi Mallikarjunarao,
>>
>> It looks ssh-keygen does not set between your postgres users and make
>> sure you are entering the correct password.
>>
>> Also, verify postgres user owner permission for the target archive
>> directory if not.
>>
>> Go through the below link for ssh-keygen.
>>
>>
>> https://www.digitalocean.com/community/tutorials/how-to-configure-ssh-key-based-authentication-on-a-...
>>
>> Thanks & Regards,
>> *Shreeyansh DBA Team*
>> www.shreeyansh.com
>>
>>
>> On Wed, Jan 16, 2019 at 9:08 PM mallikarjun t <mallit333@gmail.com>
>> wrote:
>>
>>> Hi,
>>>
>>> This is Mallikarjunarao. Currently I am using PostgreSQL 9.6.10 version.
>>> In SSL streaming replication I am facing following issues.
>>>
>>> alter 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=192.168.59.149 port=41464
>>> <2019-01-15 21:38:38.656 IST [4599]>LOG: replication connection
>>> authorized: user=postgres
>>> 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: archive command failed with
>>> exit code 1
>>> <2019-01-15 21:38:38.950 IST [4333]>DETAIL: The failed archive command
>>> was: scp pg_xlog/000000010000000000000001 postgres@192.168.59.149:
>>> /home/postgres/data_archive/000000010000000000000001
>>>
>>>
>>> I am searching error information but I didn't know that? Could you
>>> please help me out situation ?
>>>
>>> ThanksAndRegards,
>>> Mallikarjunarao.
>>>
>>>
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2019-01-17 14:42 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-01-16 15:38 archive command failed with exit code 1 mallikarjun t <mallit333@gmail.com>
2019-01-16 15:45 ` Fabio Pardi <f.pardi@portavita.eu>
2019-01-17 08:32 ` Fabio Pardi <f.pardi@portavita.eu>
2019-01-17 10:04 ` malli <mallit333@gmail.com>
2019-01-17 11:09 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-17 11:13 ` mallikarjun t <mallit333@gmail.com>
2019-01-17 14:42 ` mallikarjun t <mallit333@gmail.com>
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