pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedBackup Tool
7+ messages / 6 participants
[nested] [flat]
* Backup Tool
@ 2018-03-15 13:15 Dhandapani Shanmugam <postgresql95@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Dhandapani Shanmugam @ 2018-03-15 13:15 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Backup Tool
@ 2018-03-15 13:25 Azimuddin Mohammed <azimeiu@gmail.com>
parent: Dhandapani Shanmugam <postgresql95@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: Azimuddin Mohammed @ 2018-03-15 13:25 UTC (permalink / raw)
To: Dhandapani Shanmugam <postgresql95@gmail.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: Backup Tool
@ 2018-03-15 13:28 Thomas Flatley <FLATLEYT@outlook.com>
parent: Azimuddin Mohammed <azimeiu@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Thomas Flatley @ 2018-03-15 13:28 UTC (permalink / raw)
To: Azimuddin Mohammed <azimeiu@gmail.com>; Dhandapani Shanmugam <postgresql95@gmail.com>; +Cc: pgsql-admin
Pgbackrest has been rock-solid for us –
https://pgbackrest.org/
From: Azimuddin Mohammed [mailto:azimeiu@gmail.com]
Sent: Thursday, March 15, 2018 9:25 AM
To: Dhandapani Shanmugam <postgresql95@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Backup Tool
Chdck out barman ..
On Mar 15, 2018 8:16 AM, "Dhandapani Shanmugam" <postgresql95@gmail.com<mailto: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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Backup Tool
@ 2018-03-15 14:22 Grigory Smolkin <g.smolkin@postgrespro.ru>
parent: Thomas Flatley <FLATLEYT@outlook.com>
0 siblings, 0 replies; 7+ messages in thread
From: Grigory Smolkin @ 2018-03-15 14:22 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hello.
If you are using one of the Linux distributions and PG version is 9.5 or
higher, I would recommend to check pg_probackup.
https://github.com/postgrespro/pg_probackup
Windows support is not here yet.
On 03/15/2018 04:28 PM, Thomas Flatley wrote:
>
> Pgbackrest has been rock-solid for us –
>
> https://pgbackrest.org/
>
> *From:*Azimuddin Mohammed [mailto:azimeiu@gmail.com]
> *Sent:* Thursday, March 15, 2018 9:25 AM
> *To:* Dhandapani Shanmugam <postgresql95@gmail.com>
> *Cc:* pgsql-admin <pgsql-admin@postgresql.org>
> *Subject:* Re: Backup Tool
>
> Chdck out barman ..
>
> On Mar 15, 2018 8:16 AM, "Dhandapani Shanmugam"
> <postgresql95@gmail.com <mailto: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
>
--
Grigory Smolkin
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Backup Tool
@ 2018-03-26 10:46 Dhandapani Shanmugam <postgresql95@gmail.com>
parent: Azimuddin Mohammed <azimeiu@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Dhandapani Shanmugam @ 2018-03-26 10:46 UTC (permalink / raw)
To: Azimuddin Mohammed <azimeiu@gmail.com>; +Cc: pgsql-admin
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
>>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: Backup Tool
@ 2018-03-27 02:54 Ahmed, Nawaz <Nawaz@fast.au.fujitsu.com>
parent: Dhandapani Shanmugam <postgresql95@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Ahmed, Nawaz @ 2018-03-27 02:54 UTC (permalink / raw)
To: 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<mailto:Nawaz@fast.au.fujitsu.com>
fastware.com.au<http://fastware.com.au/;
[cid:image001.jpg@01D3C5D3.14E1F3C0]
[cid:image002.jpg@01D3C5D3.14E1F3C0]
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<mailto:azimeiu@gmail.com>> wrote:
Chdck out barman ..
On Mar 15, 2018 8:16 AM, "Dhandapani Shanmugam" <postgresql95@gmail.com<mailto: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
Attachments:
image001.jpg (image/jpeg, 7.7K) download
view image
image002.jpg (image/jpeg, 3.8K) download
view image
* Re: Backup Tool
@ 2018-03-28 01:50 Gopi Setty <gsp06268@gmail.com>
parent: Ahmed, Nawaz <Nawaz@fast.au.fujitsu.com>
0 siblings, 0 replies; 7+ messages in thread
From: Gopi Setty @ 2018-03-28 01:50 UTC (permalink / raw)
To: Ahmed, Nawaz <Nawaz@fast.au.fujitsu.com>; +Cc: 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@fast.au.fujitsu.com>
wrote:
> 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
> <https://maps.google.com/?q=14+Rodborough+Road,+Frenchs+Forest+NSW+2086,+Australia&entry=gmail&am...;
> *T* +61 2 9452 9027 <+61%202%209452%209027>
> 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 <+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@fast.au.fujitsu.com
>
>
Attachments:
image001.jpg (image/jpeg, 7.7K) download
view image
image002.jpg (image/jpeg, 3.8K) download
view image
end of thread, other threads:[~2018-03-28 01:50 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-03-15 13:15 Backup Tool Dhandapani Shanmugam <postgresql95@gmail.com>
2018-03-15 13:25 ` Azimuddin Mohammed <azimeiu@gmail.com>
2018-03-15 13:28 ` Thomas Flatley <FLATLEYT@outlook.com>
2018-03-15 14:22 ` Grigory Smolkin <g.smolkin@postgrespro.ru>
2018-03-26 10:46 ` Dhandapani Shanmugam <postgresql95@gmail.com>
2018-03-27 02:54 ` Ahmed, Nawaz <Nawaz@fast.au.fujitsu.com>
2018-03-28 01:50 ` Gopi Setty <gsp06268@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox