can't start Confluence

[hello dev]

 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-]

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)

[Kiran Panduga {Appfire}]

Hi @hello dev , 

I guess, the docker container should be mapped to your local filesystem so that the database and confluence directories exist even after Postgres or Confluence restarts.

sample command:

docker run -d -P -name randomname -v /tmp/localfolder:/volumepath imageName

In your case, it appears that mapping the container on to the local folder was not in place and due to which when you restart the Postgres, it refreshed the database entirely and will have to start again from scratch. 

Thanks,

Kiran.

[hello dev]

Hi Kiran

I used the -v option, but now after I restart, the database files are not available.

The database subdirectory "base/20148" is missing.

database "confluence" does not exist

[Kiran Panduga {Appfire}]

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.

[hello dev]

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?