On Wed, Feb 26, 2014 at 11:09 PM, Christophe Pettus <[email protected]> wrote: > tl;dr: WAL-E should back up configuration files in the PGBASE directory. > > -- > > There are two basic layouts that PostgreSQL uses on Linux: The Debian > variety, with the config files under /etc/postgresql..., and the Red Hat > variety, with the config files in PGBASE. They have their pros and cons, but > one of the pros of putting the config files under PGBASE in Red Hat style is > that it means everything you need to start the server is in one place. > > Red Hat-derived installations generally expect that, since that's the way > their installations are normally laid out. Right now, WAL-E deliberately > suppresses the backup of the *.conf files (/tar_partition.py:469). I think > that's a misfeawture. For Debian-derived systems, it's not going to back > them up anyway, since they're not under PGBASE; for Red Hat-derived systems, > including them in the backup is the least surprising thing to do. > > Thoughts?
Is that file actually portable between systems and configurations? The design intent, subject to scrutiny: The postgresql.conf file is liable to be loaded with absolute paths in particular. The general idea was that one has to configure the target database when restoring anyway and that snarfing the settings out of a backup from an older system can introduce errors that fall somewhere between "mystifying" and "dangerous", particularly if one is following the paradigm of configuring the target database but somehow leaves out the directive to use an out-of-line configuration file, picking up whatever the elder system had by accident. That particular intent makes me pretty unexcited to start picking up the configuration file (possibly from an old server and configuration) and archiving it for what may be long time, and then building a presumption that one can accept all postgresql.confs within one's variety of systems and archives. -- You received this message because you are subscribed to the Google Groups "wal-e" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
