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@xxxxxxxxx> wrote:
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
