[pgpool-general: 1236] Re: pgpool 3.2.1 - Online Recovery Setup

[Lonni J Friedman]

Sure, as long as everything is running the same version of the OS.
You might have to reload/restart the server too.

On Tue, Dec 4, 2012 at 6:28 PM, Mikola Rose <mrose at power-soft.com> wrote:
> Ah ok I assume I can just cp those to pgsql/lib on each node.
>
> On 2012-12-04, at 6:13 PM, "Lonni J Friedman" <netllama at gmail.com> wrote:
>
>> On Tue, Dec 4, 2012 at 5:46 PM, Mikola Rose <mrose at power-soft.com> wrote:
>>> Heya List;
>>>
>>>
>>>
>>> Has anyone had a problem with running the psql –f pgpool-recovery.sql
>>> template1 script
>>>
>>>
>>>
>>> I am running this on my pgpool machine that does not have an active postgres
>>> db on it so my command is a little different
>>>
>>> psql -h prod1.db.power-soft.net -p 5433 -U postgres -f pgpool-recovery.sql
>>> template1
>>>
>>>
>>>
>>>
>>>
>>> the result is;
>>>
>>>
>>>
>>> psql:pgpool-recovery.sql:4: ERROR:  could not access file
>>> "$libdir/pgpool-recovery": No such file or directory
>>>
>>> psql:pgpool-recovery.sql:9: ERROR:  could not access file
>>> "$libdir/pgpool-recovery": No such file or directory
>>>
>>> psql:pgpool-recovery.sql:14: ERROR:  could not access file
>>> "$libdir/pgpool-recovery": No such file or directory
>>>
>>>
>>>
>>> What is it looking for?
>>
>> pgpool-recovery.so which should have been installed on each database
>> server prior to running the SQL script.