pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to change to Linux from windows when the db has a big size
3+ messages / 3 participants
[nested] [flat]
* How to change to Linux from windows when the db has a big size
@ 2015-01-13 02:01 张得群 <184062459@qq.com>
0 siblings, 1 reply; 3+ messages in thread
From: 张得群 @ 2015-01-13 02:01 UTC (permalink / raw)
To: pgsql-admin
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 !
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How to change to Linux from windows when the db has a big size
@ 2015-01-13 04:58 Shreeyansh dba <shreeyansh2014@gmail.com>
parent: 张得群 <184062459@qq.com>
0 siblings, 1 reply; 3+ messages in thread
From: Shreeyansh dba @ 2015-01-13 04:58 UTC (permalink / raw)
To: 张得群 <184062459@qq.com>; +Cc: pgsql-admin
On Tue, Jan 13, 2015 at 7:31 AM, 张得群 <184062459@qq.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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How to change to Linux from windows when the db has a big size
@ 2015-01-13 09:41 Craig Ringer <craig@2ndquadrant.com>
parent: Shreeyansh dba <shreeyansh2014@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Craig Ringer @ 2015-01-13 09:41 UTC (permalink / raw)
To: Shreeyansh dba <shreeyansh2014@gmail.com>; +Cc: 张得群 <184062459@qq.com>; pgsql-admin
Indeed - Slony-I will be your best bet if you wish to avoid extended
downtime. However, Slony-I is not the simplest thing to set up and use. You
will need to spend time reading the manual. You will also need to test it
first. Do not just attempt it on your live database and hope it will work.
A possibly simpler alternative may be Londiste. Unlike Slony it cannot
replicate DDL, but if you do a pg_dump --schema-only and restore that to
the new server you can then set up Londiste to replicate the data. I've
worked with 100GB+ databases with Londiste, but not 1TB, and I don't know
your schema so I can't promise it'll work. It's not very intrusive though,
so if you have problems it's easy to remove.
By the way, the BDR project has a component that's designed to help with
this (currently called "UDR") but it only works on PostgreSQL 9.4, and not
yet on Windows. It's simpler than Slony-I, but both get the same job done.
In any case: if you need low-downtime, use Slony. If you want it to be done
faster and simpler, but with downtime, use pg_dump and pg_restore in
parallel mode.
You cannot simply copy the data directory. There is no way to in-place
convert a Windows PostgreSQL data directory for Linux use or vice versa.
On 13 January 2015 at 12:58, Shreeyansh dba <shreeyansh2014@gmail.com>
wrote:
>
>
> On Tue, Jan 13, 2015 at 7:31 AM, 张得群 <184062459@qq.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
>
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2015-01-13 09:41 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-01-13 02:01 How to change to Linux from windows when the db has a big size 张得群 <184062459@qq.com>
2015-01-13 04:58 ` Shreeyansh dba <shreeyansh2014@gmail.com>
2015-01-13 09:41 ` Craig Ringer <craig@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox