PostgreSQL database export error
-
Hi, is "nxdbmgr.exe export" supposed to work with other databases than SQLite? I'm using PostgreSQL and I get
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. -
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
-
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login