Hi All:
I suspected this initially and checked the permission on the
file; it was originally set to "root".
Does anyone know how the $libdir is set or what it really should
be (I ran ltrace to try to find out but it wasn't actually evaluated:
<ltrace>
strcpy(0x9c8bc40, "/var/lib/pgsql")
= 0x9c8bc40
sigprocmask(2, 0xbffa66e0, NULL)
= 0
sigemptyset(0xbffa6760)
= 0
sigaddset(0xbffa6760, 17)
= 0
sigemptyset(0xbffa66e0)
= 0
sigprocmask(0, 0xbffa6760, 0xbffa66e0)
= 0
sigemptyset(0xbffa6634)
= 0
sigemptyset(0xbffa65a4)
= 0
sigaction(2, 0xbffa6630, 0xbffa65a0)
= 0
waitpid(-1, 0xbffa66b8, 0<stdin>:22: PGRES_FATAL_ERROR load
'$libdir/xxid'; - ERROR: access to library "$libdir/xxid" is not
allowed
<stdin>:22: Error: the extension for the xxid data type cannot be loaded
in database 'dbname=pgbench host=pgmaster user=pgsql'
<stdin>:22: ERROR: no admin conninfo for node 152441216
</ltrace>
After changing the permissions I re-ran the command but with no
further progress.
Here are the current permissions on the file:
-rwxrwxrwx 1 postgres postgres 7.9K Oct 19 12:19 xxid.so
Note: Obviously not required to have +x.
Does anyone else have any ideas why the error occurs?
-bash-3.00$ ./initialConfigurationMaster2Slave.bash
<stdin>:22: PGRES_FATAL_ERROR load '$libdir/xxid'; - ERROR: access to
library "$libdir/xxid" is not allowed
<stdin>:22: Error: the extension for the xxid data type cannot be loaded
in database 'dbname=pgbench host=pgmaster user=pgsql'
<stdin>:22: ERROR: no admin conninfo for node 160825728
Thank you again for all you help so far,
Kind Rgds,
Ouray
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew
Sullivan
Sent: October 23, 2007 12:48 PM
To: [email protected]
Subject: Re: [Slony1-general] problems with
slony1-engine-1.2.2-1_PG8.2.5and postgresql-server-8.2.5-1PGDG.rhel4
On Tue, Oct 23, 2007 at 12:40:52PM -0400, Ouray Viney wrote:
> > <stdin>:22: PGRES_FATAL_ERROR load '$libdir/xxid'; - ERROR: access
to
> > library "$libdir/xxid" is not allowed
Sounds like ownership problems. Is the $libdir/xxid file owned by
the user running the postmaster?
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Unfortunately reformatting the Internet is a little more painful
than reformatting your hard drive when it gets out of whack.
--Scott Morris
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
