Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Confluence Postgres DB backup and restoration

Yephone Shein January 23, 2023

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 

1 answer

1 accepted

0 votes
Answer accepted
Fabio Racobaldo _Catworkx_
Community Champion
January 24, 2023

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 January 24, 2023

Hi @Fabio Racobaldo _Catworkx_ 

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 _Catworkx_
Community Champion
January 24, 2023

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

Like Yephone Shein likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Atlassian, Team '25 Europe, Atlassian conference, AI-powered teamwork, Atlassian events, keynote speakers, Barcelona tech conference, Atlassian Williams Racing, Carlos Sainz, Jenson Button, Mike Cannon-Brookes, Anu Bharadwaj, Atlassian Rovo

Atlassian Williams Racing is coming to Team '25 Europe 🏎️

Discover the teamwork and precision behind success on and off the track. See how this high-performing team makes the impossible possible. Be one of the first 100 customers to register for a chance to win 2 tickets to an Atlassian Williams 2026 race.

Register now
AUG Leaders

Atlassian Community Events