Table level restore in postgres

From: arun chirappurath <arunsnmimt(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Table level restore in postgres
Date: 2024-03-28 18:27:39
Message-ID: CAA23Sds9jUJiNn+_-d4OAEvPR3jqAi=0jXwEQYMkROvutAbyBg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all,

I am a new bie in postgres world....

Suppose I have accidently deleted a table or deleted few rows ,is it safe
to drop this table and restore just this table from custom backup to same
database?

Or should I create a new database and restore it there and then migrate the
data?

What is the general methodology used?

I tried it in a smaller database and it worked in same database..however
dbeaver was throwing a warning saying database may get corrupted?

Thanks,
Arun

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-03-28 19:09:24 Re: Table level restore in postgres
Previous Message Adrian Klaver 2024-03-28 16:19:28 Re: How to interpret 'depends on' errors in pg_restore?