One point to be clear about in all this too: This is not a problem with the installation of the RDKit cartridge. This is a problem with installing PostgreSQL itself. We may be able to help anyway, but this is, in the end, not really something for this mailing list.
On Wed, Feb 6, 2019 at 8:46 AM Jan Holst Jensen <j...@biochemfusion.com> wrote: > 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 > _______________________________________________ > Rdkit-discuss mailing list > Rdkit-discuss@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/rdkit-discuss >
_______________________________________________ Rdkit-discuss mailing list Rdkit-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rdkit-discuss