On 2019-02-05 20:38, tech tech wrote:
Hi, all,I tried to install the cartridge for Postgres. I am using ubuntu 18.04 and postgres 9.6 However, when I typed this commond: /home/hat/anaconda3/envs/my-rdkit-env/bin/initdb -D /var/www/rdkit I saw following errors. I don't know how to fix it. Does anyone have a correct input file to init the database? Thanks Tom //////////////////////////////////////////////////////////////////////////////// The files belonging to this database system will be owned by user "hat". [...]
performing post-bootstrap initialization ... FATAL: column
pol.polpermissive does not exist at character 169
STATEMENT: CREATE VIEW pg_policies AS
SELECT
N.nspname AS schemaname,
C.relname AS tablename,
[...]
FROM pg_catalog.pg_policy pol
JOIN pg_catalog.pg_class C ON (C.oid = pol.polrelid)
LEFT JOIN pg_catalog.pg_namespace N ON (N.oid = C.relnamespace);
child process exited with exit code 1
initdb: removing contents of data directory "/var/www/rdkit"
Hi Tom,The polpermissive column is not available in Postgres 9.6. On a Postgres 9.6 database the pg_catalog.pg_policies table has the columns
polname polrelid polcmd polroles polqual polwithcheck and on a Postgres 11.1 database the table has these columns: polname polrelid polcmd *polpermissive* polroles polqual polwithcheck Don't know if you have the option of using a newer version of Postgres ? Cheers -- Jan
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ Rdkit-discuss mailing list Rdkit-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rdkit-discuss
