Re: How to get some table entries from backup instance back to production instance
| От | daku.sandor@gmail.com |
|---|---|
| Тема | Re: How to get some table entries from backup instance back to production instance |
| Дата | |
| Msg-id | 7302ABEA-C622-4DD3-8913-DE33C855FA77@gmail.com обсуждение исходный текст |
| Ответ на | How to get some table entries from backup instance back to production instance (Marcel Ruff <mr@marcelruff.info>) |
| Ответы |
Re: How to get some table entries from backup instance back
to production instance
|
| Список | pgsql-novice |
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
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
В списке pgsql-novice по дате отправления: