Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

We recently inherited a company and their CentOS server with a Postgres running their CSR db. They have a backup system in place which we know nothing about.

It creates backups of the Postgres DB in i's entirity and creates two files, a .backup and .globals. What application are they using to create these backups?

share|improve this question

2 Answers 2

PostgreSQL uses pg_dump to create database backups. The pg_dump documentation will tell you the various options that can be used.

pg_restore is used to restore these dumps to a database.

share|improve this answer

In addition to pg_dump, there is also pg_dumpall-- they could be using either one. I would hazard a guess that the .globals file was created using pg_dumpall --globals-only. If these backups are being automatically generated then there should be an entry in either the postgres users crontab ( run crontab -l as the postgres user) or in the /etc/crontab file that will tell you how the files are being created.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.