Re: PITR backup & Restore issue
От | Gmail Account |
---|---|
Тема | Re: PITR backup & Restore issue |
Дата | |
Msg-id | 4BE18FAC.2070303@gmail.com обсуждение исходный текст |
Ответ на | PITR backup & Restore issue (raghu ram <raghuchennuru@gmail.com>) |
Список | pgsql-admin |
On 05/05/10 8:57 PM, raghu ram wrote: <blockquote cite="mid:k2wd331f2ee1005050827l48b3c5bcmf1abcf339f8879fe@mail.gmail.com"type="cite">Hi Postgres Guru's, <div><br /></div><div><br/></div><div><p style="margin: 0px 0px 13px; font-family: Arial; font-style: normal; font-variant: normal;font-weight: normal; font-size: 13px; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font:none; color: rgb(85, 85, 85);">Is it possible to use the Hot Backup (PITR Backup) of PostgreSQL on an Operatingsystem to restore the database on other Operating system.<p style="margin: 0px 0px 13px; font-family: Arial; font-style:normal; font-variant: normal; font-weight: normal; font-size: 13px; line-height: normal; font-size-adjust: none;font-stretch: normal; -x-system-font: none; color: rgb(85, 85, 85);"><br /><p style="margin: 0px 0px 13px; font-family:Arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 13px; line-height: normal; font-size-adjust:none; font-stretch: normal; -x-system-font: none; color: rgb(85, 85, 85);">Thanks & Regards<p style="margin:0px 0px 13px; font-family: Arial; font-style: normal; font-variant: normal; font-weight: normal; font-size:13px; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none; color: rgb(85, 85,85);">Raghu</div></blockquote><font face="Courier New, Courier, monospace"><br /> Nope, Hot Backup (Online Backup) ofPostgreSQL, on One OS/File System is not compatible with the Other OS/FileSystem.<br /><br /></font>If you want to Movethe Database from One OS/File System to other OS/Filesystem then use pg_dump/pg_dumpall command to take the backup ofdatabase.<br /><br /><pre class="moz-signature" cols="72">-- Thanks & Regards, Vibhor Kumar </pre>
В списке pgsql-admin по дате отправления: