Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres DB Migration from 8.3 to 9.1 - Mailing list pgsql-general

From Vishalakshi Navaneethakrishnan
Subject Re: Postgres DB Migration from 8.3 to 9.1
Date
Msg-id CAP-PUP2J1DzTFf5VHocMHBJPZjVwpxMY6Ze8PE1omcSW0mZFEw@mail.gmail.com
Whole thread Raw
In response to Re: Postgres DB Migration from 8.3 to 9.1  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Postgres DB Migration from 8.3 to 9.1  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
Hi all,

While testing upgrade facility, I have installed postgres 9.2 using  source package. 

Because it needs to  be compiled with --disable-integer-datetimes.

I have used this command

./configure --prefix=/opt/PostgreSQL/9.2/ --disable-integer-datetimes --without-readline  

After installation i found pg_upgrade binary missing in bin directoy. How can i get this ?

Thanks in Advance.

On Sat, Oct 13, 2012 at 3:37 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Thu, Oct 11, 2012 at 8:15 PM, Vishalakshi Navaneethakrishnan
<nvishalakshi@sirahu.com> wrote:
> Hi Friends,
>
> We have our production environment database server in Postgres 8.3 version.
> we have planned to upgrade to lastest version 9.1. Dump from 8.3  and
> restore in Postgres 9.1 takes more than 5 hours. Any other quick method to
> upgrade from 8.3 to 9.1. We need to reduce our downtime  below 1 hour. Any
> Possibilities..?

As downtime required approaches zero, the likelyhood of needing slony
approaches 1.



--
Best Regards,
Vishalakshi.N

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: tablespace_oid alias?
Next
From: John R Pierce
Date:
Subject: Re: Postgres DB Migration from 8.3 to 9.1