pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedArchive command failed - WAL SEGMENT
3+ messages / 2 participants
[nested] [flat]
* Archive command failed - WAL SEGMENT
@ 2016-01-04 20:09 drum.lucas@gmail.com <drum.lucas@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: drum.lucas@gmail.com @ 2016-01-04 20:09 UTC (permalink / raw)
To: pgsql-admin
Hi guys!
I've configured a new SLAVE Hot Standby server to my production.
The problem is that, I've got some errors on Master:
archive command failed with exit code 4
Failed to archive WAL segment `pg_xlog/0000000100000C2100000029` on host
`db-02`
Do you guys know what I may be doing wrong?
Thanks!
Lucas
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Archive command failed - WAL SEGMENT
@ 2016-01-04 20:31 Stephen Frost <sfrost@snowman.net>
parent: drum.lucas@gmail.com <drum.lucas@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Stephen Frost @ 2016-01-04 20:31 UTC (permalink / raw)
To: drum.lucas@gmail.com <drum.lucas@gmail.com>; +Cc: pgsql-admin
Drum,
* drum.lucas@gmail.com (drum.lucas@gmail.com) wrote:
> I've configured a new SLAVE Hot Standby server to my production.
>
> The problem is that, I've got some errors on Master:
>
> archive command failed with exit code 4
> Failed to archive WAL segment `pg_xlog/0000000100000C2100000029` on host
> `db-02`
>
> Do you guys know what I may be doing wrong?
Whatever you have set as your archive_command in postgresql.conf is
returning exit code 4. It's either broken, and you need to fix it, or,
if it's working, you need to change it to return error code 0
(indicating success).
Thanks!
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Archive command failed - WAL SEGMENT
@ 2016-01-04 21:21 drum.lucas@gmail.com <drum.lucas@gmail.com>
parent: Stephen Frost <sfrost@snowman.net>
0 siblings, 0 replies; 3+ messages in thread
From: drum.lucas@gmail.com @ 2016-01-04 21:21 UTC (permalink / raw)
To: Stephen Frost <sfrost@snowman.net>; +Cc: pgsql-admin
Yep.. found the problem!
It was on my key_host file!
Cheers;
On 5 January 2016 at 09:31, Stephen Frost <sfrost@snowman.net> wrote:
> Drum,
>
> * drum.lucas@gmail.com (drum.lucas@gmail.com) wrote:
> > I've configured a new SLAVE Hot Standby server to my production.
> >
> > The problem is that, I've got some errors on Master:
> >
> > archive command failed with exit code 4
> > Failed to archive WAL segment `pg_xlog/0000000100000C2100000029` on host
> > `db-02`
> >
> > Do you guys know what I may be doing wrong?
>
> Whatever you have set as your archive_command in postgresql.conf is
> returning exit code 4. It's either broken, and you need to fix it, or,
> if it's working, you need to change it to return error code 0
> (indicating success).
>
> Thanks!
>
> Stephen
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2016-01-04 21:21 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-01-04 20:09 Archive command failed - WAL SEGMENT drum.lucas@gmail.com <drum.lucas@gmail.com>
2016-01-04 20:31 ` Stephen Frost <sfrost@snowman.net>
2016-01-04 21:21 ` drum.lucas@gmail.com <drum.lucas@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