Menu

#14 Added functionality to pg_rman

Accepted
nobody
None
Medium
Defect
2010-02-25
2010-02-25
Anonymous
No

Originally created by: feikesteenbergen@gmail.com

I was looking to write a pg_rman equivalent until I stumbled upon this project.

There are a couple of functional items I have on a wishlist, it may just be
that I have not fully understood the mechanism, but here is a list of
functions I would like to see added.

1). Delete archives from ARCLOG_PATH after they have been backed up X times
2). Compress full backup into a single tar archive (to speed up backup to
tape afterwards)
3). The option to compress the data, but not the archives (my archives are
already compressed)
4). Some autocleaning mechanism. For example:
    Set a maxsize for all backups;
    IF (size of all backups > maxsize)
       THEN delete oldest backup
       IF AND ONLY IF all KEEP parameters are still satisfied
       ELSE print warning / send mail, etc. etc.
5). Improved restore.conf, I'll explain:
    My archives are already in the gzip format, the recovery.conf section
should look something like:
      restore_command = 'gunzip < ARCLOG_PATH/%f.gz > %p'

I would be willing to contribute to this great project, although I do not
have experience in C, I might be able to help.

Please tell me your opinions about these options,

Discussion

  • Anonymous

    Anonymous - 2010-02-25

    Originally posted by: itagaki....@gmail.com

    Yeah, all of your suggestions are pretty reasonable. One of the difficulties is
    that they requires more rich managements of backup catalogs.

    See also Issue 5, that is a plan to re-implement the catalog with RDBMS.

     

    Related

    Tickets: #5

  • Anonymous

    Anonymous - 2010-02-25

    Originally posted by: itagaki....@gmail.com

    (No comment was entered for this change.)

    Status: Accepted

     

Log in to post a comment.

MongoDB Logo MongoDB