Text only | Text with Images

NetXMS Support Forum

English Support => General Support => Topic started by: Beda on May 24, 2013, 05:41:42 PM

Title: PostgreSQL database export error
Post by: Beda on May 24, 2013, 05:41:42 PM
Hi, is "nxdbmgr.exe export" supposed to work with other databases than SQLite? I'm using PostgreSQL and I get

Code Select

C:\NetXMS\bin>nxdbmgr.exe export DBbackup
NetXMS Database Manager Version 1.2.7

ERROR: Schema version mismatch between dbschema_sqlite.sql and your database. Please check that NetXMS server installed correctly.
Database export failed.


Shouldn't dbschema_pgsql.sql be used?
I'm running NetXMS 1.2.7 on Windows7 with PostgreSQL 9.2.
Title: Re: PostgreSQL database export error
Post by: Victor Kirhenshtein on May 24, 2013, 09:25:00 PM
Hi!

Export file is in fact SQLite database, and file dbschema_sqlite.sql used to create empty export file. Looks like installer contains wrong version of this file. Find schema files and replace them with attached, then export should work.

Best regards,
Victor
Title: Re: PostgreSQL database export error
Post by: Beda on May 29, 2013, 09:56:43 PM
After replacing files in C:\NetXMS\lib\sql by your files, export works.
Thank you very much.
Text only | Text with Images