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.marl...@gmail.com>wrote: > On Thu, Oct 11, 2012 at 8:15 PM, Vishalakshi Navaneethakrishnan > <nvishalak...@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