Обсуждение: restoring a table after an online backup
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?
wkr,
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?
wkr,
Bert Desmet
> 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 --- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
It depends on how you do the copy. To do comados with SQL, you can find to> 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?
>
with the sql of the table you want.
Saludos,
Gilberto Castillo
La Habana, Cuba
The online backups are file system level backups therefore single table restoration is not possible however possible to restore the specific table from the logical backups (pg_dump) if you have. In case of online backups, it's best practice to restore the online backup on a test system and perform PITR. After successful restoration, take the dump of the specific table and restore it on the production.
Thanks & Regards,
Prashanth Ranjalkar
Database Consultant & Architect
Skype:prashanth.ranjalkar
On Mon, Jul 15, 2013 at 6:49 PM, Gilberto Castillo <gilberto.castillo@etecsa.cu> wrote:
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin