can't start Confluence

Question

I run Confluence and Postgresql by docker

yesterday, the Postgresql is restart ,then the Confluence hint

Database is being updated by another Confluence instance

then I restart the Postgresql ,but I get

startup process (PID 22) was terminated by signal 6: Aborted

PANIC: could not locate a valid checkpoint record

then I exec

pg_resetwal -f /var/lib/postgresql/data

then I restart Postgresql

Prompt when starting the database

The database subdirectory "base/20148" is missing.

database "confluence" does not exist

I think at the moment I only have confluence datadir

What should I do to recover my data or resart confluence?

Nic Brough -Adaptavist- · Answer

Something has destroyed part of your database.  You will need to recover your system from a backup.

If you were taking database backups with postgres, you should use one of those to recreate the database.  If not, then hopefully you did not turn off the local default file backups - check <confluence home>/backups and /export for them.  With both options, you'll need to create a new postgres database from scratch (and hopefully work out what damaged the old one so you can prevent it happening again)

hello dev · Answer

the database confluence is exist

I use \l can show the confluence,but I can't open the database,the log print

The database subdirectory "base/20148" is missing.

database "confluence" does not exist

How can I export my document in this case, without repairing the database?

Kiran Panduga {Appfire} · Answer

Hi @hello dev ,

Can you get into the Postgres Database and check if the database confluence and the associated tables exist ? If not, you will have to create the new database and then map to your local filesystem, so that the data exist even after docker container restart.

Thanks,

Kiran.