Re: restoring a table after an online backup

From: "Gilberto Castillo" <gilberto(dot)castillo(at)etecsa(dot)cu>
To: "Bert" <biertie(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: restoring a table after an online backup
Date: 2013-07-15 13:19:08
Message-ID: 45443.192.168.207.54.1373894348.squirrel@webmail.etecsa.cu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> 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

Attachment Content-Type Size
unknown_filename text/plain 179 bytes

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Prashanth Ranjalkar 2013-07-15 13:35:38 Re: restoring a table after an online backup
Previous Message Rafael Domiciano 2013-07-15 13:16:19 9.2.2 - semop hanging