Getting error when taking backup of jasperserver database?

[aamitt06]

Running command pg_dump --username=postgres --host=127.0.0.1 --port=5433 jasperserver > jasperdb.sql

getting error

pg_dump:column -1 out of range 0..21

pg_dumo:column -1 out of range 0..21

pg_dump: cannot duplicate null pointer.

 

I have used bundled jasperserver database.

[aamitt06]

According to me this is a version issue but dont know how to resolve this.

[hozawa]

This is really a postgresql issue. Should post your question to postgresql community instead of here.

[aamitt06]

Well I have resolved the issue initially what I was doing is using the command

root@ubuntu:pg_dump --username=postgres --host=127.0.0.1 --port=5433 jasperserver > /home/user/JS_55_Backup.sql

the problem with it was that  there was another pg_dump on linux server which was of higher version and bundled postgresql of JasperServer uses 9.0.4 postgresql , to resolve this issue I gave the path of pg_dump inside jasperserver i.e

root@ubuntu:~#  /opt/jasperreports-server-cp-5.5.0/postgresql/bin/pg_dump --username=postgresql --host-127.0.0.1 --port=5433 jasperserver > /home/user/JS_55_Backup.sql