1 year ago

#368477

test-img

TWhite

backup postgres database conf files

I have been exploring ways to backup a Postgres database. It seems the main tool is pg_dumpall. However, this doesn't backup the configuration files such as the hba_file, ident_file, external_pid_file, and the postgresql.conf file.

If pg_dumpall only saves the data in the data_directory would it be possible to restore the postgres database without the configuration files? If so, how would I do it? If not, how should I backup the configuration files?

I would like to have a backup such that the cluster can be recreated from scratch.

postgresql

backup

0 Answers

Your Answer

Accepted video resources