Re: Pg_restore and dump -- General question

Thank you all, I will take that in account

________________________________
From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Howard Cole <howardnews(at)selestial(dot)com>
Cc: salah jubeh <s_jubeh(at)yahoo(dot)com>; pgsql-general(at)postgresql(dot)org
Sent: Mon, April 4, 2011 1:44:28 PM
Subject: Re: [GENERAL] Pg_restore and dump -- General question

On Mon, Apr 4, 2011 at 5:40 AM, Howard Cole <howardnews(at)selestial(dot)com> wrote:
> On 04/04/2011 11:47 AM, salah jubeh wrote:
>
> What will happen if
>
> 1. dropped table a
> 2. insert data on b and the other relations
> 3. restore table a and it's dependency (table b).
>
> Simple advice would be to create a script on an offline system for testing -
> when you are happy with the results - do it on the online system - after
> making a backup of course! Anything else would be suicidal.

Agreed. AND on the production system first take a backup and THEN run
the drop cascade inside a transaction in case it does crazy things you
didn't foresee.

begin;
drop object yada cascade;

then rollback if things get too scary.