Обсуждение: Reeving an error while taking the backup using "pg_basebackup" utility.
Reeving an error while taking the backup using "pg_basebackup" utility.
От
Raghavendra Rao J S V
Дата:
Hi All,
We are using below command to take the backup of the database.
$PGHOME/bin/pg_basebackup -p 5433 -U postgres -P -v -x --format=tar --gzip --compress=1 --pgdata=- -D /opt/rao
While taking the backup we have received below error.
transaction log start point: 285/8F000080
pg_basebackup: could not get transaction log end position from server: FATAL: requested WAL segment 00000001000002850000008F has already been removed
Please guide me why and how to handle this error. Do you want me to change any of the option in my pg_basebackup command let me know.
Please clarify me what it means --pgdata=--D in my above pg_basebackup command.
--
Regards,
Raghavendra Rao J S V
Raghavendra Rao J S V
On Tue, Aug 28, 2018 at 07:19:12AM +0530, Raghavendra Rao J S V wrote: > pg_basebackup: could not get transaction log end position from server: > FATAL: requested WAL segment 00000001000002850000008F has already been > removed > > Please guide me why and how to handle this error. Do you want me to change > any of the option in my pg_basebackup command let me know. This means that while taking a backup, a checkpoint has come in and has recycled past segments. Lack of luck it is, as depending on the load you may see such failures. One way to correct the problem would be to take a base backup without WAL segments included and with a WAL archive used by the base backup taken. A second is to use a physical replication slot which guarantee the presence of the wanted segments. -- Michael
Вложения
On 08/27/2018 06:49 PM, Raghavendra Rao J S V wrote: > Hi All, > > We are using below command to take the backup of the database. > > *$PGHOME/bin/pg_basebackup -p 5433 -U postgres -P -v -x --format=tar > --gzip --compress=1 --pgdata=- -D /opt/rao * > > While taking the backup we have received below error. > > transaction log start point: 285/8F000080 > > ** > > pg_basebackup: could not get transaction log end position from server: > FATAL: requested WAL segment 00000001000002850000008F has already been > removed > > Please guide me why and how to handle this error. Do you want me to > change any of the option in my pg_basebackup command let me know. -X stream See link below. > > Please clarify me what it means *--pgdata=--D* in my above > *pg_basebackup *command. https://www.postgresql.org/docs/10/static/app-pgbasebackup.html > -- > Regards, > Raghavendra Rao J S V > -- Adrian Klaver adrian.klaver@aklaver.com