Reeving an error while taking the backup using "pg_basebackup" utility.

From: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Reeving an error while taking the backup using "pg_basebackup" utility.
Date: 2018-08-28 01:49:12
Message-ID: CAEHH7R5M6Fy-8uNxfsHP4MDMSVHaJpjP=YKrQmMcQw2v_8LeUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra Rao J S V 2018-08-28 02:27:09 How to search particular line/text code in all Postgres all database object's
Previous Message Alvaro Herrera 2018-08-28 00:49:41 Re: Will there ever be support for Row Level Security on Materialized Views?