Jasperserver upgrade - permission denied for postgres dump



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= --port=5432 jasperserver > jasperserver-cp-6.1.0_18FEB2020_1650.sql

4) Ensured to run this before:

sudo chown -R postgres:postgres JS_BACKUP


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

How to resolve this?


aparnagl's picture
Joined: Apr 6 2010 - 12:09am
Last seen: 9 months 1 week ago


stchan - 1 year 11 months ago

1 Answer:


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= --port=5432 jasperserver -f /tmp/backup.sql

stchan's picture
Joined: Oct 29 2019 - 6:44pm
Last seen: 1 year 3 months ago