Can I back up Conflunce through SSH

[soldesk]

Good day to all,

We're currently suffering a major catastrophe, we cannot access the confluence URL and we cannot back up the files

Question 1.) can we back-up the confluence use SSH?

Question 2.) can we use the backed-up data to rebuild a new confluence sever?

[MoroSystems Support]

Hello,

Questions 1.):

Yes, XML backup in Confluence is not the only backup option.

You can create DB backup on database application.

Are you using PostgreSQL database?

Questions 2.):

a) You should migrate CONFLUENCE_HOME folder and CONFLUENCE_INSTALL folder + DB backup to new confluence server.

b) Create new DB  and migrate DB backup into new DB.

c) If you change the location CONFLUENCE_HOME, you should change PATH in CONFLUENCE_INSTALL/confluence/WEB-INF/classes/confluence-init.properties to CONFLUENCE_HOME folder.

[soldesk]

Yes, we are using PostgreSQL, how will we back up the DB? pg_dumb is not working.

We have migrated the confluence from Linux to windows, the problem is the migration of PostgreSQL DB. :(

[MoroSystems Support]

pg_dumb is wrong. pg_dump is correct.

Maybe you are not configured PATH to pg_dump on alternatives.

You should create new folder with access

chmod -R 777 new_folder

You should start pg_dump on

cd  /usr/pgsql-X.X/bin/

You should go to postgres user:

su postgres

Create db backup:

./ pg_dump -U dbrole dbname -f PATH_NEW_FOLDER/filename.sql

[soldesk]

Sorry my bad, anyways when I go to Postgres user this message appeared :

any idea what is it?

thanks @MoroSystems Support

[MoroSystems Support]

It is correct. You are postgres user in OS.

Now you do it:
   cd  /usr/pgsql-VERSION_POSTGRES/bin/

   ./pg_dump -U dbrole dbname -f PATH_NEW_FOLDER/filename.sql

Please check  PostgreSQL client programs:

yum info postgresql.x86_64

[Nic Brough -Adaptavist-]

"Permission denied" means your account does not have the right to run it.

You need to talk to your server administrators about granting that permission to it,