| From: | Shreeyansh dba <shreeyansh2014(at)gmail(dot)com> |
|---|---|
| To: | 张得群 <184062459(at)qq(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: How to change to Linux from windows when the db has a big size |
| Date: | 2015-01-13 04:58:15 |
| Message-ID: | CAGDYbUNWcNX769z2Zah717Cn=0ou1w8oN8r+Qnqyy6DMoTY7Bg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Tue, Jan 13, 2015 at 7:31 AM, 张得群 <184062459(at)qq(dot)com> wrote:
> Hello,I have a database on Windows 7 ,Postgresql 9.3,its size is about
> more than 1T,now I want to transfer the platform to Linux ,are there any
> good ways to do it? The pg_dump command is too slow ,what I want is that
> can I just connect my hd to linux and set some configures about
> postgresql?Thank you !
>
Hi,
Though pg_dump is a better option, but as your database size very large it
requires more downtime which results performance of pg_dump slow. Slony
replication is the best option for performing large database upgrades which
results in less downtime as you are moving out of Windows to Linux.
Hope this will solve your issue.
--
Thanks & Regards
*Venkataramana Aitla*
*Database Administrator*
www.shreeyansh.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2015-01-13 09:41:24 | Re: How to change to Linux from windows when the db has a big size |
| Previous Message | 张得群 | 2015-01-13 02:01:54 | How to change to Linux from windows when the db has a big size |