Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42621=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1X6VgX-0004K2-1B
 for pgsql-admin@arkaria.postgresql.org; Mon, 14 Jul 2014 02:08:09 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42621=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1X6VgV-0004e8-NU
 for pgsql-admin@arkaria.postgresql.org; Mon, 14 Jul 2014 02:08:07 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <craig@2ndquadrant.com>)
 id 1X6VgU-0004e0-KZ
 for pgsql-admin@postgresql.org; Mon, 14 Jul 2014 02:08:06 +0000
Received: from mout.kundenserver.de ([212.227.17.24])
 by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <craig@2ndquadrant.com>)
 id 1X6VgR-00053z-Hy
 for pgsql-admin@postgresql.org; Mon, 14 Jul 2014 02:08:04 +0000
Received: from ayaki.localdomain (58-7-95-106.dyn.iinet.net.au [58.7.95.106])
 by mrelayeu.kundenserver.de (node=mreue103) with ESMTP (Nemesis)
 id 0MJEQE-1X89J7208g-002mwU; Mon, 14 Jul 2014 04:08:00 +0200
Message-ID: <53C33B7B.30003@2ndquadrant.com>
Date: Mon, 14 Jul 2014 10:07:55 +0800
From: Craig Ringer <craig@2ndquadrant.com>
Organization: 2nd Quadrant
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:24.0) Gecko/20100101 Thunderbird/24.4.0
MIME-Version: 1.0
To: mail list <mailist@milidonis.com>, pgsql-admin@postgresql.org
Subject: Re: wal archive showing zero size
References: <53BEF3A6.20403@milidonis.com> <86egxtosgl.fsf@jerry.enova.com>
 <53BFA3F6.6000401@milidonis.com>
In-Reply-To: <53BFA3F6.6000401@milidonis.com>
X-Enigmail-Version: 1.6
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Provags-ID: V02:K0:uqCH4k2HqbiZn5AjLrqG/ifRqZ8JziZo1F4K0xyOgng
 UWqF5SsTZpcRnyRBX9KvQNxrMImXlYbheNiqbEJ36EoS5oHZcA
 AC4aFbS82KSZjO+iMU7dw4OPAyhLyyF8BPjSS4tQ5HUW3H+54z
 FK048qs0LeaEa4i/MBo5J3ejx4U95p2bLKHYh/NAOWPUgMsXWl
 67e5FAKYeMwuC4MfgvoCToBd9pdx8rm9dXs7HflYH5pJxzGcxY
 dEdEfyzA8V00RBaDbPtlX7+c/NH8LRXvafwxhOMUvWIhdZs7QB
 wqg4T8PPMwFqgkUA3mGM5uIeIuyw43hPKhz11vaPpYqbMMPtw1
 ClmZhbOx8XvOkJBtl8ZN+qV/u2l8AtaED4vpGCEYw
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On 07/11/2014 04:44 PM, mail list wrote:
> I no longer have pg_xlog so dont know this information .Is there a ways
> to repair wal archives?

If it's zero size then there's no data there to repair. You can't create
data out of nothing.

What happened to the original pg_xlog directory you "no longer have"?

What archive_command were you using?


-- 
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin