Thanks for good suggestions.
On Tue, Jul 28, 2015 at 3:13 PM, Joshua D. Drake
wrote:
>
> On 07/28/2015 01:35 PM, AI Rumman wrote:
>
>> But what I read, in-place upgrade has smaller outage, compared to
>> dump/restore.
>>
>
> Correct, in fact if you do it with the link option, it will be very fa
On 07/28/2015 01:35 PM, AI Rumman wrote:
But what I read, in-place upgrade has smaller outage, compared to
dump/restore.
Correct, in fact if you do it with the link option, it will be very fast.
But so many articles on having bugs afterwards.
Do you think it is a good idea to use pg_upgrade
On Tue, Jul 28, 2015 at 10:35 PM, AI Rumman wrote:
> But what I read, in-place upgrade has smaller outage, compared to
> dump/restore.
Please, keep in mind that while the direct outage (when the database
is shut down) is small, there will be a time period right after the
upgrade when PostgreSQL w
On 7/28/2015 1:35 PM, AI Rumman wrote:
But what I read, in-place upgrade has smaller outage, compared to
dump/restore. But so many articles on having bugs afterwards.
Do you think it is a good idea to use pg_upgrade for critical database
application?
most of those are application issues with 9
On 7/28/2015 1:29 PM, Joshua D. Drake wrote:
I need to upgrade Postgresql database from 8.4 to latest stable version
(9.4). The db size is almost 2.5 TB.
Is pg_upgrade in-place is a good idea for it?
With quite a bit of testing, yes.
yeah, that was my thought to... clone the database to a
But what I read, in-place upgrade has smaller outage, compared to
dump/restore. But so many articles on having bugs afterwards.
Do you think it is a good idea to use pg_upgrade for critical database
application?
Or any other tool should I consider? For example - slony?
Thanks for advice.
Regards.
On 07/28/2015 01:12 PM, AI Rumman wrote:
Hi,
I need to upgrade Postgresql database from 8.4 to latest stable version
(9.4). The db size is almost 2.5 TB.
Is pg_upgrade in-place is a good idea for it?
With quite a bit of testing, yes.
But keep in mind, it is still an outage.
JD
Thanks fo
