[Pgpool-general] pgpool_walrecrunning not working from pgpool connection

Daniel.Crespo at l-3com.com Daniel.Crespo at l-3com.com
Tue Oct 26 22:35:23 UTC 2010


> > I'm using Postgresql 9.0 and the latest pgpool from CVS Head from
> > Thursday October 21st, for streaming replication.
> >
> >
> >
> > When I start pgpool-II, and see the postgresql log file, its output
> > states that pgpool_walrecrunning() can not access
> > '$libdir/pgpool_walrecrunning': No such file or directory.
> >
> >
> >
> > pgpool_walrecrunning.so is actually there. What is more important,
> when
> > I connect directly to postgresql it returns properly. But if I
> connect
> > using pgpool's port (9999 by default), the above error is shown.
> >
> >
> >
> > I did enter the sql directory of pgpool source, and compiled and
> > installed each of the components, including pgpool_walrecrunning.
> >
> >
> >
> > Is there something I'm missing?
> 
> Are you sure that you installed pgpool_walrecrunning on each DB node?

Yes. I did. Here is what I experience:

********* Directly to postgres *************
-bash-3.2$ psql -U someuser -p 5432 db0
psql (9.0.1)
Type "help" for help.

db0=# select pgpool_walrecrunning();
 pgpool_walrecrunning
----------------------
 f
(1 row)

db0=# \q

************* Through pgpool ***************
-bash-3.2$ psql -U someuser -p 9999 db0
psql (9.0.1)
Type "help" for help.

db0=# select pgpool_walrecrunning();
ERROR:  could not access file "$libdir/pgpool-walrecrunning": No such
file or directory
db0=# \q

Any clue?

Thanks,
-Daniel


More information about the Pgpool-general mailing list