Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uyifi-00005k-Ou for pgsql-admin@arkaria.postgresql.org; Mon, 15 Jul 2013 13:18:34 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Uyifi-0006rz-6u for pgsql-admin@arkaria.postgresql.org; Mon, 15 Jul 2013 13:18:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uyifg-0006qn-Tf for pgsql-admin@postgresql.org; Mon, 15 Jul 2013 13:18:32 +0000 Received: from imx3.etecsa.cu ([200.55.152.137]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UyifY-0002FD-7X for pgsql-admin@postgresql.org; Mon, 15 Jul 2013 13:18:32 +0000 Received: from Unknown ([192.168.91.45] helo=mn3.etecsa.cu) by imx3.etecsa.cu with ESMTP id r9HmeWOi45297; Mon, 15 Jul 2013 09:17:48 -0500 Received: (qmail 29510 invoked by uid 11185); 15 Jul 2013 14:18:01 -0000 Received: from 192.168.91.6 by mn3.etecsa.cu (envelope-from , uid 502) with qmail-scanner-2.08 (spamassassin: 3.2.5. Clear:RC:1(192.168.91.6):. Processed in 0.0481549999999999 secs); 15 Jul 2013 14:18:01 -0000 Received: from unknown (HELO webmail.etecsa.cu) ([192.168.91.6]) (envelope-sender ) by mn2.etecsa.cu (qmail-ldap-1.03) with SMTP for ; 15 Jul 2013 14:18:00 -0000 Received: from 192.168.207.54 (SquirrelMail authenticated user gilberto.castillo) by webmail.etecsa.cu with HTTP; Mon, 15 Jul 2013 08:19:08 -0500 (GMT+5) Message-ID: <45443.192.168.207.54.1373894348.squirrel@webmail.etecsa.cu> In-Reply-To: References: Date: Mon, 15 Jul 2013 08:19:08 -0500 (GMT+5) Subject: Re: restoring a table after an online backup From: "Gilberto Castillo" To: "Bert" Cc: "pgsql-admin@postgresql.org" Reply-To: gilberto.castillo@etecsa.cu User-Agent: SquirrelMail/1.4.8-5.el5_4.10 MIME-Version: 1.0 X-Priority: 3 (Normal) Importance: Normal X-SpamTest-Envelope-From: gilberto.castillo@etecsa.cu X-SpamTest-Info: Profiles 48563 [Jul 15 2013] X-SpamTest-Method: none X-SpamTest-Rate: 0 X-SpamTest-Status: Not detected X-SpamTest-Status-Extended: not_detected X-SpamTest-Version: SMTP-Filter Version 3.0.0 [0285], KAS30/SDK/Release X-Anti-Virus: Kaspersky Mail Gateway, version: 5.6.28/RELEASE, bases: 20130715T041105 #10600049, check: 20130715 clean Content-Type: multipart/mixed; boundary="=r9HneiDf81291=imx3.etecsa.cu=" X-Pg-Spam-Score: -2.3 (--) 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 This is a multi-part message in MIME format. --=r9HneiDf81291=imx3.etecsa.cu= Content-Disposition: inline Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit > Hello, > > I was just wondering: Is it possible to restore a specific table from an > online backup? > Or is it only possible if we first restore the backup, replay all the > logs, > and then take the table files? > It depends on how you do the copy. To do comados with SQL, you can find to with the sql of the table you want. Saludos, Gilberto Castillo La Habana, Cuba --=r9HneiDf81291=imx3.etecsa.cu= Content-Type: text/plain Content-Disposition: inline --- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu Visit our web-site: , --=r9HneiDf81291=imx3.etecsa.cu= Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin --=r9HneiDf81291=imx3.etecsa.cu=--