Re: [Postgres-xc-general] First-time tinkering with PostgreSQL-XC

[Michael P. <mic...@gm...>]

On Fri, Sep 30, 2011 at 4:51 PM, Chris Angelico <ro...@gm...> wrote:

> On Fri, Sep 30, 2011 at 4:48 PM, Michael Paquier
> <mic...@gm...> wrote:
> > Retry to start GTM with with command, it may make a difference:
> > gtm -x 1000 -D /usr/local/pgsql/data/gtm/ -p 6667 -l gtm.log &
> > ...
> > This was perhaps autovacuum transactions that were committing on nodes
> with
> > the same transaction ID as a past transaction. A transaction ID being
> > committed twice on a node makes it crash with a FATAL error.
> >
>
> Made that change, thanks. Doesn't appear to have changed anything from
> the state as at my second post; Unix socket isn't working but TCP
> socket is. It's worth being correct, anyhow.
>
> Is it a consideration that I'm using libpqxx?
>
This may be a problem, but I'm not sure.
Have you tried to set LD_LIBRARY_PATH to connect refer to the path where you
installed postgres-xc libs?
Regarding your settings, it should be in /usr/local/pgsql/lib.
-- 
Michael Paquier
http://michael.otacoo.com