Re: pg_basebackup fails: could not receive data from WAL stream: server closed the connection unexpectedly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks Stephen,

Is there any relation/dependency between status-interval  and wal_sender_timeot.?


I  am asking this because even if I set  status-interval for pg_basebackup to 1 second( the most frequent feedback) I get the same error:
pg_basebackup: could not receive data from WAL stream: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
pg_basebackup: child process exited with error 1

because the server terminates wal_sender due to replication timeout.

Best regards,
Andrei



From:        Stephen Frost <sfrost@xxxxxxxxxxx>
To:        AYahorau@xxxxxxxxxxx,
Cc:        Shreeyansh Dba <shreeyansh2014@xxxxxxxxx>, MikalaiKeida@xxxxxxxxxxx, pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
Date:        04/12/2018 17:05
Subject:        Re: pg_basebackup fails: could not receive data from WAL stream: server closed the connection unexpectedly




Greetings,

* AYahorau@xxxxxxxxxxx (AYahorau@xxxxxxxxxxx) wrote:
> I reckon we can return to more conventional approach of postgres db
> synchronization:
> 1) SELECT pg_start_backup('label', true);
> 2) rsync/cp  $PGDATA directory;
> 3) SELECT pg_stop_backup();

It doesn't seem clear what the goal here is- if you are looking to have
two DB servers that are synchronized, then using pg_basebackup to get
the initial copy and then running PostgreSQL as a replica would be the
right approach.

I certainly wouldn't recommend trying to hack together something with
rsync or cp or using the exclusive backup mode at all- if the system
crashes when that exclusive backup is happening, the database won't come
back up.

> I have a question. What is your opinion about pg_basebackup utility and
> its behaviour for this condition?  Is it a bug? Should it be fixed?

No, I don't see any bug here, but if you adjust the timeout values on
the server then you need to tell pg_basebackup to send messages to the
server more frequently or it's going to get timed out.  That's what the
--status-interval option in pg_basebackup is for.

Thanks!

Stephen
[attachment "signature.asc" deleted by Andrei Yahorau/IBA]


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux