Jasperserver upgrade - permission denied for postgres dump

0

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?

 

aparnagl's picture
Joined: Apr 6 2010 - 12:09am
Last seen: 2 weeks 2 days ago

.

stchan - 1 month 2 weeks ago

1 Answer:

0

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

stchan's picture
100
Joined: Oct 29 2019 - 6:44pm
Last seen: 20 min 12 sec ago
Feedback