Confluence Postgres DB backup and restoration

[Yephone Shein]

I have a question on postgres confluence DB backup and restoration process. I used the pg_dump command and restored, but I have the error the following. 

-bash-4.2$ psql confluencedb < /root/dump_confluence_27122022.sql
-bash: /root/dump_confluence_27122022.sql: Permission denied
-bash-4.2$

Please any suggestions and advice. 

Thanks! 

Ye Phone 

[Fabio Racobaldo _Herzum_ · Accepted solution]

Hi @Yephone Shein ,

welcome to the Atlassian community!

Please check file permission. For more information take a look here https://stackoverflow.com/questions/29547679/permission-denied-when-i-try-to-restore-postgres-backup

Hope this helps,

Fabio

[Yephone Shein]

Hi @Fabio Racobaldo _Herzum_ 

Thanks for your sharing! 

I was tried and now it's ok with confluence backup zip file. However, the link is useful for me. 

Regards,

Ye Phone 

[Fabio Racobaldo _Herzum_]

I'm happy for that. Please mark my answer as accepted!