From: | Marcel Ruff <mr(at)marcelruff(dot)info> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Cc: | daku(dot)sandor(at)gmail(dot)com |
Subject: | Re: How to get some table entries from backup instance back to production instance |
Date: | 2015-02-11 08:02:40 |
Message-ID: | 54DB0CA0.2000009@marcelruff.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Ok, thank you, this seems to be the way.
What about the children and grandchildren?
Is there a way to cascade the "pa" query or do I need to query "children" and "grandchildren"
with separate extra queries?
Thanks
Marcel
On 10.02.2015 10:04, daku(dot)sandor(at)gmail(dot)com wrote:
>
> Hi,
>
> I would do this way:
> After the first step select the required records into another tables with CREATE TABLE patmp AS
> SELECT * FROM pa WHERE ...
> Move these temporary tables to the prod database by dump and restore and transfer the content into
> the prod tables with INSERT INTO pa SELECT * FROM patmp.
> Done.
>
> Regards,
> Sándor Daku
>
>
>
> On 10 Feb 2015, at 09:39, Marcel Ruff <mr(at)marcelruff(dot)info <mailto:mr(at)marcelruff(dot)info>> wrote:
>
>> Hi,
>>
>> I have 4 tables with 1:n relation:
>>
>> grandpa -> pa -> child -> grandchild
>>
>> Now I need to copy an instance of "pa" with his descendants
>> from my backup (a postgres dump) back to prod.
>> "grandchild" has a blob column (containing fotos)
>>
>> Which options do I have?
>>
>> 1) Import the backup dump in a separate postgres instance
>> 2) Do some magic query which created insert statements
>> 3) Run the insert statements on the prod server
>>
>> What is the best approach, and how does a query look like which
>> returns nicely formatted insert lines?
>>
>> Thank you
>> Marcel
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Chuck Roberts | 2015-02-11 11:55:15 | How to create tables and copy records in blocks? |
Previous Message | petrov.boris.v@mail.ru | 2015-02-10 18:45:05 | Re: Who should own database? |