Hi Robert,
Thanks for ur views, I got an advice from a DB professional
Raghavendra Rao as below it worked
From your contrib/pg_standby location you need to first set the path
for pg_config and do ./configure or directly make, make install. This
will create pg_standby executable in postgresql/8.2/bin...
Go through the README file in the pg_standby contrib location which will
brief you about the installation procedure.
Mehdi
On 11/23/2011 04:16 AM, Robert Treat wrote:
> On Tue, Nov 22, 2011 at 4:09 AM, khizer<khizer@srishtisoft.com> wrote:
>> Hi,
>>
>> May i know how to install pg_standby for postgresql8.2 in ubuntu 10.10
>> OS
>> I copied the pg_standby folder for compilation which has the files
>> pg_standby.c, Makefile
>>
>> initially i tried with make, make install inside contrip/pg_standby folder
>> but i got an err Makefile.global no such file r directory ...
>>
>> so i compiled and reinstalled postgresql8.2 but not able to find pg_standby,
>> How can i solve this guys?
> IIRC, the way to do this is to compile 8.3 for your platform,
> including the pg_standby contrib module, and then just copy the binary
> over to you system. Since it doesn't integrate directly, it will work
> against 8.2, save for the %r macro (for removing unneeded xlog
> segments). If you really need the %r capabilities, you might want to
> look at OmniPITR, which doesn't require compiling and implements that
> feature.
>
> Robert Treat
> play: xzilla.net
> work: omniti.com
>