Thanks Christian Brilliant, I've found those in the source directory.
I can't see the process for installing these though, so I'll assume that I just rename the _pg.xsl ones into the /usr/share/openvas/scap and cert directories. Roger 2017-04-24 10:00 GMT+01:00 Christian Fischer < christian.fisc...@greenbone.net>: > Hi, > > On 18.04.2017 10:03, Roger Davies wrote: > > Hi > > > > Just wondering if someone has a Postgres equivalent of > > greenbonde-scapdata-sync and greenbone-certdata-sync. > > > > The xsl SQL uses 'INSERT OR REPLACE" which is sqllite specific, so I get > > an error when running them. > > > > Can't seem to find anything online. > > most likely because both scripts and the .xls files are already > supporting Postgresql since quite some time and doesn't use INSERT OR > REPLACE when running Postgresql: > > https://lists.wald.intevation.org/pipermail/openvas-commits/ > 2014-October/020637.html > > https://lists.wald.intevation.org/pipermail/openvas-commits/ > 2014-October/020601.html > > So the question is why your environment is not using the Postgres > compatible .xls files > > Regards, > > -- > > Christian Fischer | PGP Key: 0x54F3CE5B76C597AD > Greenbone Networks GmbH | http://greenbone.net > Neumarkt 12, 49074 Osnabrück, Germany | AG Osnabrück, HR B 202460 > Geschäftsführer: Lukas Grunwald, Dr. Jan-Oliver Wagner > _______________________________________________ > Openvas-discuss mailing list > Openvas-discuss@wald.intevation.org > https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss >
_______________________________________________ Openvas-discuss mailing list Openvas-discuss@wald.intevation.org https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss