pg_restore

Поиск
Список
Период
Сортировка
От Jyoti Seth
Тема pg_restore
Дата
Msg-id 003101c9e8e5$2a31ee80$7e95cb80$@com
обсуждение исходный текст
Список pgsql-sql
<div class="Section1"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D">Hi all,</span><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D"> </span><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D"> I have two databases db1 and db2 with no network connection. I want to take backup of few master tables
fromdb1 and restore it to db2 at frequent intervals.. I do not want to delete data from the tables and restores the
freshdata as this data is getting referenced in other tables. I can do that by creating scripts on db1 and executing
thesame on db2. But I want to know if  I can use pg_restore command to overwrite existing data of these master
tables</span><pclass="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"; 
color:#1F497D"> </span><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D">Thanks,</span><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D">Jyoti</span><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D"> </span></div>

В списке pgsql-sql по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Xml Schemas
Следующее
От: "Jyoti Seth"
Дата:
Сообщение: backup