Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cDydU-0001Y5-PP for pgsql-admin@arkaria.postgresql.org; Mon, 05 Dec 2016 19:09:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cDydU-0006Jd-By for pgsql-admin@arkaria.postgresql.org; Mon, 05 Dec 2016 19:09:12 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cDySk-0003vA-I8 for pgsql-admin@postgresql.org; Mon, 05 Dec 2016 18:58:06 +0000 Received: from mail02.usask.ca ([128.233.195.238] helo=mail.usask.ca) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cDySg-0004Lg-0T for pgsql-admin@postgresql.org; Mon, 05 Dec 2016 18:58:05 +0000 Received: from Mail02.usask.ca (192.168.228.183) by Mail02.usask.ca (192.168.228.183) with Microsoft SMTP Server (TLS) id 15.0.1178.4; Mon, 5 Dec 2016 12:57:59 -0600 Received: from Mail02.usask.ca ([fe80::c882:6a42:306d:186b]) by Mail02.usask.ca ([fe80::c882:6a42:306d:186b%14]) with mapi id 15.00.1178.000; Mon, 5 Dec 2016 12:57:59 -0600 From: "Tharmarajah, Sam" To: "pgsql-admin@postgresql.org" Subject: Req. for some help with resolving the error "pg_basebackup: could not get WAL end position from server: FATAL: requested WAL segment" Thread-Topic: Req. for some help with resolving the error "pg_basebackup: could not get WAL end position from server: FATAL: requested WAL segment" Thread-Index: AdJPKGiY2+ZkFcDjQTKi0ZqKXwhZkA== Date: Mon, 5 Dec 2016 18:57:59 +0000 Message-ID: <873181a7a9164ffe8b74c6e425a1a724@Mail02.usask.ca> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.80.30.37] Content-Type: multipart/alternative; boundary="_000_873181a7a9164ffe8b74c6e425a1a724Mail02usaskca_" MIME-Version: 1.0 X-Pg-Spam-Score: -7.2 (-------) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_000_873181a7a9164ffe8b74c6e425a1a724Mail02usaskca_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi I am a newbie to postgres. We are on postgres 9.1 running on RedHat 6. Whe= n we do the postgres backups we are noticing the following errors pg_basebackup: could not get WAL end position from server: FATAL: requeste= d WAL segment 000000010000020B00000040 has already been removed But when I look into pg_xlog, I notice 000000010000020B00000040.00000118.backup May I know how to resolve this error? Are the backups done with these error= s, recoverable? Thanks in advance for your support. Thanx, Sam --_000_873181a7a9164ffe8b74c6e425a1a724Mail02usaskca_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi

 

I am a newbie to postgres. We are on postgres 9.1 ru= nning on RedHat 6.  When we do the postgres backups we are noticing th= e following errors

 

pg_basebackup: could not get WAL end position from s= erver: FATAL:  requested WAL segment  000000010000020B00000040 ha= s already been removed

 

But when I look into pg_xlog, I notice

 

000000010000020B00000040.00000118.backup<= /p>

 

 

May I know how to resolve this error? Are the backup= s done with these errors, recoverable?

 

 

Thanks in advance for your support.

 

Thanx,

Sam

 

 

 

 

--_000_873181a7a9164ffe8b74c6e425a1a724Mail02usaskca_--