Re: OpenNMS Upgrade Script fails wi th Postgresql 9 :: 'syntax error at or near " $1"'
"Kordzik, Sebastian" <[email protected]> Fri, 12 Jun 2015 10:07:00 +0000
| Newsgroups | gmane.network.opennms.install |
|---|---|
| Message-ID | <[email protected]> |
Hi! Did some more „playing around“ with postgresql but had no luck so far. Even with a fresh installation and new postgresql data folder I still get the ‘syntax error at or near "$1"’ problem. You guys all use Postgresql 9 and have no problems running that install script? Oh, and is there a way to make those DB changes manually? Except comparing the table layout to the content of the create.sql file. And a way to run the upgrade script without running the database part and just do the file based upgrades? Or documentation on all those upgrade changes, so I can do them all manually, if nothing else helps. Best regards Sebastian Von: Kordzik, Sebastian Gesendet: Mittwoch, 10. Juni 2015 14:54 An: 'Installation questions and help' Betreff: AW: [opennms-install] OpenNMS Upgrade Script fails with Postgresql 9 :: 'syntax error at or near "$1"' (Mixed security state) Hi! Thanks for your help! I just reimported all databases via dumps and reused the pg_hba.conf but used the new postgresql.conf and only moved those settings over from the old config which were present in the new one. So I guess it’s mostly default. The only extension I installed is iplike2. I haven’t installed any contrib packages. I attached my postgresql.conf file (if this works….). Maybe some changes to the “COMPATIBILITY” section are needed? Best regards Sebastian Von: David S Hustace [mailto:[email protected]] Gesendet: Mittwoch, 10. Juni 2015 14:42 An: Installation questions and help Betreff: Re: [opennms-install] OpenNMS Upgrade Script fails with Postgresql 9 :: 'syntax error at or near "$1"' (Mixed security state) On Jun 10, 2015, at 7:26 AM, Kordzik, Sebastian <[email protected]<mailto:[email protected]>> wrote: Perhaps you’ve already solved such a problem or have any ideas what it’s causing it – and I would be grateful for any (profound) suggestions ☺ Have you made any customizations to PostgreSQL 9? :-David Hustace The OpenNMS Group, Inc. ------------------------------------------------------------------------------ _______________________________________________ Please read the OpenNMS Mailing List FAQ: http://www.opennms.org/index.php/Mailing_List_FAQ opennms-install mailing list To *unsubscribe* or change your subscription options, see the bottom of this page: https://lists.sourceforge.net/lists/listinfo/opennms-install