Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V7kX9-0005uB-1D for pgsql-admin@arkaria.postgresql.org; Fri, 09 Aug 2013 11:07:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1V7kX8-0006RJ-Gj for pgsql-admin@arkaria.postgresql.org; Fri, 09 Aug 2013 11:07:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V7kX6-0006RA-F1 for pgsql-admin@postgresql.org; Fri, 09 Aug 2013 11:07:00 +0000 Received: from mail-lb0-x235.google.com ([2a00:1450:4010:c04::235]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V7kX3-0000Pm-ES for pgsql-admin@postgresql.org; Fri, 09 Aug 2013 11:06:59 +0000 Received: by mail-lb0-f181.google.com with SMTP id o10so3117757lbi.26 for ; Fri, 09 Aug 2013 04:06:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:content-type:subject:message-id:date:to:mime-version; bh=3Tf3h8SenpuESM4azKmLXU+8NeklbQRJWyNg8e9KpL0=; b=JmLo5D6AbiJtbjY58yCeRjmD3X6XzvNwg1SJHAC8ikceQaCkPsJS0hvA2N6QcIssSk mOCR4WcY/Bv4GDqjBlldEyZf8liJnv4ne5l/e/01nnQlixsqyP8U6zNfkDFVZEXKAV6y d6LcDRhfK0A4vXRZH+uTZeG6skrdQsHZFcH5G7AygjYnTjjNh2ZcxjKpMZEsfb+4dY1+ 6XbBZyfIuH9hEnuXt/ygymxmq+5EHQ4gfK11nsjyJv8O+M7HaBOPT7un0A6q7NNBIaUQ gBxGh+bS+MdaRz1Er74rWLWJApJlZpD7octVMwULgKQeqOzPr8YECo9ujqJf7a4pFm7z hHJA== X-Received: by 10.112.55.173 with SMTP id t13mr4340824lbp.39.1376046416541; Fri, 09 Aug 2013 04:06:56 -0700 (PDT) Received: from [192.168.1.200] ([188.134.10.29]) by mx.google.com with ESMTPSA id db5sm6459727lac.10.2013.08.09.04.06.53 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Fri, 09 Aug 2013 04:06:55 -0700 (PDT) From: Sergey Arlashin Content-Type: multipart/alternative; boundary="Apple-Mail=_D9FB408F-ACE4-4563-A3D2-67F5648E7D6C" Subject: Only WAL archive left. Need to restore data. Message-Id: Date: Fri, 9 Aug 2013 15:06:52 +0400 To: pgsql-admin@postgresql.org Mime-Version: 1.0 (Mac OS X Mail 6.5 \(1508\)) X-Mailer: Apple Mail (2.1508) X-Pg-Spam-Score: -2.0 (--) 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 --Apple-Mail=_D9FB408F-ACE4-4563-A3D2-67F5648E7D6C Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi, I have 2GB backup of WAL archive folder but the backup of postgres = database cluster directory is lost.=20 However I need to restore any data possible from these WAL logs.=20 Is that possible? What do I do to get the data.=20 Thanks in advance.=20 -- Best regards, Sergey Arlashin= --Apple-Mail=_D9FB408F-ACE4-4563-A3D2-67F5648E7D6C Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii database cluster directory is = lost.

However = I need to restore any data possible from these WAL = logs.

Is that possible? What do = I do to get the data.

Thanks = in advance.

Best = regards,

Sergey = Arlashin

= --Apple-Mail=_D9FB408F-ACE4-4563-A3D2-67F5648E7D6C--