'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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
