Re: Oracle vs. PostgreSQL - a comment
On 6/2/20 11:22 AM, Ron wrote: The inability to do a point-in-time restoration of a *single* database in a multi-db cluster is a serious -- and fundamental -- missing feature (never to be implemented because of the fundamental design). It is possible via 3rd party tools like pg_probackup and pgbackrest. -- Grigory Smolkin Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
Re: Is there any tool that provides Physical Backup plus PITR for a single database ( Not the whole PG instance ) ?
Hello! pg_probackup can do that: https://postgrespro.github.io/pg_probackup/#pbk-partial-restore On 12/15/19 5:32 PM, Abraham, Danny wrote: I assume that this magic does not exist. Am I right ? -- Grigory Smolkin Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
Re: Backup and Restore
Hello! I would recommend to look at pg_probackup: https://github.com/postgrespro/pg_probackup On 12/12/19 6:12 PM, Dor Ben Dov wrote: Hi, What is the most common used back and restore solution for postgres ? Which one are you using ? Regards, Dor *This email and the information contained herein is proprietary and confidential and subject to the Amdocs Email Terms of Service, which you may review at**https://www.amdocs.com/about/email-terms-of-service* -- Grigory Smolkin Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
Re: Enabling checksums on a streaming replica
Hello! Very interesting idea, but what about full page writes, that comes from master? Can they be a problem? On 6/26/19 6:32 PM, Brad Nicholson wrote: I'm wondering about the validity of using the pg_checksums utility to enable checksum's on a streaming replication standby, and then promoting that standby as a way to enable checksums on existing clusters. I've tested the process out, and it "works" (by works I mean doesn't blow up or log any errors). But this seems far enough outside of supported territory that I'm curious what others think. The process is: - Primary with checksums off - create a streaming replica off that primary - stop the secondary - enable checksums on the secondary with the pg_checksums utility - start the replica - promote the replica I've thrown load at it while the it was replicating from checksums off -> checksums on, promoted it, and verified the checksums after with pg_checksums. Any thoughts on this approach? Thanks, Brad -- Grigory Smolkin Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
