RE: Backup Tool

Поиск
Список
Период
Сортировка
От Ahmed, Nawaz
Тема RE: Backup Tool
Дата
Msg-id BAAE097528E6CB4FB2BE65AEFA6EEE04939643E2@SYD1217
обсуждение исходный текст
Ответ на Re: Backup Tool  (Dhandapani Shanmugam <postgresql95@gmail.com>)
Ответы Re: Backup Tool  (Gopi Setty <gsp06268@gmail.com>)
Список pgsql-admin

The show-backup will show you information about a single backup as below

 

[barman@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
T +61 2 9452 9027
Nawaz@fast.au.fujitsu.com
fastware.com.au


 

From: Dhandapani Shanmugam [mailto:postgresql95@gmail.com]
Sent: Monday, 26 March 2018 9:47 PM
To: Azimuddin Mohammed <azimeiu@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.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@gmail.com> wrote:

Chdck out barman ..

 

On Mar 15, 2018 8:16 AM, "Dhandapani Shanmugam" <postgresql95@gmail.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 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@fast.au.fujitsu.com

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Artem Tomyuk
Дата:
Сообщение: Re: how to shrink pg_attribute table in some database
Следующее
От: Artem Tomyuk
Дата:
Сообщение: autovacuum: vacuum analyze vs autovacuum: vacuum