Re: Postgres DB Migration from 8.3 to 9.1

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(dot)marlowe(at)gmail(dot)com>wrote:

> On Thu, Oct 11, 2012 at 8:15 PM, Vishalakshi Navaneethakrishnan
> <nvishalakshi(at)sirahu(dot)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