Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL backup stategies - Mailing list pgsql-general

From Melvin Davidson
Subject Re: PostgreSQL backup stategies
Date
Msg-id CANu8FixzgBzBRcUHif4GFm9-0wmAFX-AHq3je1wM_JbeDQbuCA@mail.gmail.com
Whole thread Raw
In response to PostgreSQL backup stategies  (Luis Marin <luismarinaray@gmail.com>)
List pgsql-general
Tree view


On Wed, Feb 21, 2018 at 10:00 PM, Luis Marin <luismarinaray@gmail.com> wrote:
Dear Friends,

Please, somebody knows a good source of information about PostgreSQL 9 backup strategies for production systems, if you have read a good book with this subject, could you share the author and name of the book ?

Thanks

>... a good source of information about PostgreSQL 9 backup strategies
That is a very broad topic, It is also highly dependent of your particular configuration.
What is your O/S?
How big is your database?
What is your high availability (replication) configuration?
What are the hours for production access?
Do you intend to use 3rd party solution? EG: Barman,

You might want to start here -> https://www.compose.com/articles/postgresql-backups-and-everything-you-need-to-know/
--
Melvin Davidson

Maj. Database & Exploration Specialist

Universe Exploration Command – UXC

Employment by invitation only!

pgsql-general by date:

Previous
From: Luis Marin
Date:
Subject: PostgreSQL backup stategies
Next
From: Tom Lane
Date:
Subject: Re: Understanding query planner cpu usage