Re: Postgres DB Migration from 8.3 to 9.1

[Vishalakshi Navaneethakrishnan <nvishalakshi@xxxxxxxxxx>]

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@xxxxxxxxx> wrote:

On Thu, Oct 11, 2012 at 8:15 PM, Vishalakshi Navaneethakrishnan
<nvishalakshi@xxxxxxxxxx> 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