Hi,
I am having problems install the Postgres cartridge in Postgres 9.1 on
Linux Mint 12 (which is based on Ubuntu 11.10).
RDKit 2012_03_1 builds without any issues and all tests pass.
The PgSQL cartridge builds fine too, and installs fine as seen below.
jhje@linux-dev-x86 ~/RDKit_2012_03_1/Code/PgSQL/rdkit $ sudo make install
/bin/mkdir -p '/usr/lib/postgresql/9.1/lib'
/bin/mkdir -p '/usr/share/postgresql/9.1/extension'
/bin/sh
/usr/lib/postgresql/9.1/lib/pgxs/src/makefiles/../../config/install-sh
-c -m 755 rdkit.so '/usr/lib/postgresql/9.1/lib/rdkit.so'
/bin/sh
/usr/lib/postgresql/9.1/lib/pgxs/src/makefiles/../../config/install-sh
-c -m 644 ./rdkit.control '/usr/share/postgresql/9.1/extension/'
/bin/sh
/usr/lib/postgresql/9.1/lib/pgxs/src/makefiles/../../config/install-sh
-c -m 644 ./rdkit--3.1.sql '/usr/share/postgresql/9.1/extension/'
jhje@linux-dev-x86 ~/RDKit_2012_03_1/Code/PgSQL/rdkit $
However, the "make installcheck" step fails. In the regression.diffs I see:
[... tons of lines ...]
--- 4,9 ----
--
SET client_min_messages = warning;
\set ECHO none
! FATAL: failed to initialize rdkit.tanimoto_threshold to 0.5
! FATAL: failed to initialize rdkit.tanimoto_threshold to 0.5
! connection to server was lost
The same thing happens when I try to enable the 'rdkit' extension directly.
postgres@linux-dev-x86 ~ $ psql
psql (9.1.3)
Type "help" for help.
postgres=# create extension rdkit;
FATAL: failed to initialize rdkit.tanimoto_threshold to 0.5
FATAL: failed to initialize rdkit.tanimoto_threshold to 0.5
The connection to the server was lost. Attempting reset: Succeeded.
postgres=#
/var/log/postgresql/postgres-9.1-main-log doesn't tell me anything extra:
2012-04-24 18:23:32 CEST LOG: invalid value for parameter
"rdkit.tanimoto_threshold": 0.5
2012-04-24 18:23:32 CEST STATEMENT: create extension rdkit;
2012-04-24 18:23:32 CEST FATAL: failed to initialize
rdkit.tanimoto_threshold to 0.5
2012-04-24 18:23:32 CEST STATEMENT: create extension rdkit;
Being in Denmark, I suspected regional settings, but apparently it is
not the issue (?):
postgres=# select 7.0/3;
?column?
--------------------
2.3333333333333333
(1 row)
postgres=# \q
The decimal separator used in Postgres is a period, not a comma as I feared.
Any help appreciated :-).
Cheers
-- Jan Holst Jensen
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Rdkit-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/rdkit-discuss
