Jasperserver upgrade - permission denied for postgres dump

[aparnagl]

Hi

Following the link: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-upgrade-guide/v71/upgrading-60-63-71-0#upgrading_562921741_1114058

While backing up postgresql,

1) what use should run the pg_dump command?

2) Should the command be run in JS_BACKUP?

3) What exact command should it be?

We are getting 'permission denied' error for the following command:

1) run as su user

2) From /opt/JS_BACKUP

3) command: pg_dump --username=postgres --host=127.0.0.1 --port=5432 jasperserver > jasperserver-cp-6.1.0_18FEB2020_1650.sql

4) Ensured to run this before:

sudo chown -R postgres:postgres JS_BACKUP

Error:

bash: js-db-dump.sql: Permission denied

How to resolve this?

 

[stchan]

.

[stchan]

User postgres is just fine and your command also works in my environment

Probably try to test if you can touch a file in the directory first

Also, try below to create file to /tmp

 pg_dump --username=postgres --host=127.0.0.1 --port=5432 jasperserver -f /tmp/backup.sql