Обсуждение: Best backup strategy for production systems
Hi,
I'm a newbie in postgresql. I've mounted my first postgresql instance, it is empty now, only with default postgres DB.
It is under Linux, with 2 filesystems, one for data and another for archiving (I've enabled archiving as it will be for production).
Could someone recommend me a strategy for backups, scripts and so on?
Can base backup be done with the system up (postgres up), isn't it?
Would it be ok if I do a base backup each week and archiving backup each day?
As I've not configured backups (and archiving deletion), I've had my first problem and it is that my archiving filesystem (FS) is full and archiver process is showing "failed" with the last wal file copy (normal as archiving FS is full).
Please, recommend me what I should make now .. I should create another network FS for base backups and archiving backups? When I have my first base backup, could I then delete archiving files, isn't it?
My archiving FS has 20GB, I don't understand as with a system without load (it will be for production, but it hasn't databases now .. only postgres), how it full the FS in a few days ... Is it normal?
Thanks beforehand.
Cheers...
On 17/06/2014 10:51, Oliver wrote: > Hi, > I'm a newbie in postgresql. I've mounted my first postgresql instance, > it is empty now, only with default postgres DB. > It is under Linux, with 2 filesystems, one for data and another for > archiving (I've enabled archiving as it will be for production). > Could someone recommend me a strategy for backups, scripts and so on? Hi there, You should post to the pgsql-general mailing list; this one is specifically for PgAdmin, the administration GUI for PostgreSQL. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
Ah thanks Ray, I'm sorry.
Cheers...
2014-06-17 11:04 GMT+01:00 Raymond O'Donnell <rod@iol.ie>:
On 17/06/2014 10:51, Oliver wrote:Hi there,
> Hi,
> I'm a newbie in postgresql. I've mounted my first postgresql instance,
> it is empty now, only with default postgres DB.
> It is under Linux, with 2 filesystems, one for data and another for
> archiving (I've enabled archiving as it will be for production).
> Could someone recommend me a strategy for backups, scripts and so on?
You should post to the pgsql-general mailing list; this one is
specifically for PgAdmin, the administration GUI for PostgreSQL.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie
On 17/06/2014 11:17, Oliver wrote: > Ah thanks Ray, I'm sorry. > > Cheers... Hi Oliver, It's not a problem. :-) But you'll get advice from a much wider range of people on that list, at least regarding general PG questions such as yours. All the best, Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie