Re: Backup Tool

From: Gopi Setty <gsp06268(at)gmail(dot)com>
To: "Ahmed, Nawaz" <Nawaz(at)fast(dot)au(dot)fujitsu(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Backup Tool
Date: 2018-03-28 01:50:36
Message-ID: CAKK5+QVf_PnDzMknhwOGLkjvQKoV8Ka4e2b44OpOdhwybNDMrw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have DEV server BARMAN *retention policies working fine. Another server
fix had problem on retention policies. Have ever face this situation. we
had same config.*

*Thanks *

On Mon, Mar 26, 2018 at 9:54 PM, Ahmed, Nawaz <Nawaz(at)fast(dot)au(dot)fujitsu(dot)com>
wrote:

> The show-backup will show you information about a single backup as below
>
>
>
> [barman(at)CentOS72 pg]$ barman -c /etc/barman.d/barman.conf show-backup pg
> 20171207T122938
>
> Backup 20171207T122938:
>
> Server Name : pg
>
> Status : DONE
>
> PostgreSQL Version : 90506
>
> PGDATA directory : /bkup/PG95/95mas/data
>
>
>
> Base backup information:
>
> Disk usage : 322.0 MiB (322.0 MiB with WALs)
>
> Incremental size : 322.0 MiB (-0.00%)
>
> Timeline : 3
>
> Begin WAL : 00000003000000020000006C
>
> End WAL : 00000003000000020000006D
>
> WAL number : 1
>
> WAL compression ratio: 99.84%
>
> Begin time : 2017-12-07 12:29:39+11:00
>
> End time : 2017-12-07 12:29:39.581927+11:00
>
> Begin Offset : 40
>
> End Offset : 96
>
> Begin XLOG : 2/6C000028
>
> End XLOG : 2/6D000060
>
>
>
> WAL information:
>
> No of files : 0
>
> Disk usage : 0 B
>
> Last available : 00000003000000020000006C
>
>
>
> Catalog information:
>
> Retention Policy : not enforced
>
> Previous Backup : - (this is the oldest base backup)
>
> Next Backup : - (this is the latest base backup)
>
>
>
>
>
>
>
>
>
> Best Regards,
>
>
>
>
>
>
> *Nawaz Ahmed Software Development Engineer Fujitsu Australia Software
> Technology Pty Ltd*
> 14 Rodborough Road, Frenchs Forest NSW 2086, Australia
> <https://maps.google.com/?q=14+Rodborough+Road,+Frenchs+Forest+NSW+2086,+Australia&entry=gmail&source=g>
> *T* +61 2 9452 9027 <+61%202%209452%209027>
> Nawaz(at)fast(dot)au(dot)fujitsu(dot)com
> fastware.com.au
>
>
>
>
> *From:* Dhandapani Shanmugam [mailto:postgresql95(at)gmail(dot)com]
> *Sent:* Monday, 26 March 2018 9:47 PM
> *To:* Azimuddin Mohammed <azimeiu(at)gmail(dot)com>
> *Cc:* pgsql-admin <pgsql-admin(at)postgresql(dot)org>
> *Subject:* Re: Backup Tool
>
>
>
> the show backup command captures the failure backup in barman ?
>
>
>
> On Thu, Mar 15, 2018 at 6:55 PM, Azimuddin Mohammed <azimeiu(at)gmail(dot)com>
> wrote:
>
> Chdck out barman ..
>
>
>
> On Mar 15, 2018 8:16 AM, "Dhandapani Shanmugam" <postgresql95(at)gmail(dot)com>
> wrote:
>
>
>
> Hi,
>
>
>
> Can you share your experience on which backup tool is good for postgreSQL
> hot backup. i am testing with EDB BART and need you expert advise
>
>
>
> -D
>
>
> Disclaimer
>
> The information in this e-mail is confidential and may contain content
> that is subject to copyright and/or is commercial-in-confidence and is
> intended only for the use of the above named addressee. If you are not the
> intended recipient, you are hereby notified that dissemination, copying or
> use of the information is strictly prohibited. If you have received this
> e-mail in error, please telephone Fujitsu Australia Software Technology Pty
> Ltd on + 61 2 9452 9000 <+61%202%209452%209000> or by reply e-mail to the
> sender and delete the document and all copies thereof.
>
> Whereas Fujitsu Australia Software Technology Pty Ltd would not knowingly
> transmit a virus within an email communication, it is the receiver’s
> responsibility to scan all communication and any files attached for
> computer viruses and other defects. Fujitsu Australia Software Technology
> Pty Ltd does not accept liability for any loss or damage (whether direct,
> indirect, consequential or economic) however caused, and whether by
> negligence or otherwise, which may result directly or indirectly from this
> communication or any files attached.
>
> If you do not wish to receive commercial and/or marketing email messages
> from Fujitsu Australia Software Technology Pty Ltd, please email
> unsubscribe(at)fast(dot)au(dot)fujitsu(dot)com
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2018-03-28 04:53:27 postgres 9.6.8 to 10 on Ubuntu 16.04.4 LTS --- tsearch2 unloadable...
Previous Message Mark Kirkwood 2018-03-27 21:25:03 Re: AWS Database Migration Errors Post migration