Is there any tool that provides Physical Backup plus PITR for a single database ( Not the whole PG instance ) ?

2019-12-15 Thread Abraham, Danny
I assume that this magic does not exist. Am I right ?

Is there any tool that provides Physical Backup plus PITR for a single database ( Not the whole PG instance ) ?

2019-12-15 Thread Abraham, Danny
I assume that this magic does not exist. Am I right ? Thanks Danny

Re: server will not start (Debian)

2019-12-15 Thread Peter J. Holzer
On 2019-12-10 12:03:30 -0500, stan wrote: > OK, here is the latets. If I do sudo systemctl start postgresql@12-main > > the instance starts and works fine. > > However, if I reboot the machine, the instance is not started. Check whether the service is enabled in systemd: # systemctl status post

Re: Is there any tool that provides Physical Backup plus PITR for a single database ( Not the whole PG instance ) ?

2019-12-15 Thread Adrian Klaver
On 12/15/19 6:33 AM, Abraham, Danny wrote: I assume that this magic does not exist. Am I right ? Take a look at: https://pgbackrest.org/user-guide.html#restore/option-db-include and see it that meets your needs. I have never actually done it so I cannot add anything to the above. Thanks D

Re: Fast, stable, portable hash function producing 4-byte or 8-byte values?

2019-12-15 Thread George Neuner
On Tue, 10 Dec 2019 18:00:02 -0600, Ron wrote: >On 12/10/19 3:11 PM, Erwin Brandstetter wrote: >> I am looking for stable hash functions producing 8-byte or 4-byte hashes >> from long text values in Postgres 10 or later. >> >> There is md5(), the result of which can be cast to uuid. This reliabl

Re: Fast, stable, portable hash function producing 4-byte or 8-byte values?

2019-12-15 Thread Erik Aronesty
You can always tweak fnv for whatever bite-size or bit size you want. Sometimes I know a little information about my data shape and make a custom fnv that only looks at the first half for the last half of a string, etc. On Wed, Dec 11, 2019, 1:02 PM Erwin Brandstetter wrote: > Thanks for the su

Re: Is there any tool that provides Physical Backup plus PITR for a single database ( Not the whole PG instance ) ?

2019-12-15 Thread Ron
On 12/15/19 10:32 AM, Adrian Klaver wrote: On 12/15/19 6:33 AM, Abraham, Danny wrote: I assume that this magic does not exist. Am I right ? Take a look at: https://pgbackrest.org/user-guide.html#restore/option-db-include and see it that meets your needs. I have never actually done it so I c

Re: Fast, stable, portable hash function producing 4-byte or 8-byte values?

2019-12-15 Thread Ron
On 12/15/19 3:59 PM, George Neuner wrote: On Tue, 10 Dec 2019 18:00:02 -0600, Ron wrote: On 12/10/19 3:11 PM, Erwin Brandstetter wrote: I am looking for stable hash functions producing 8-byte or 4-byte hashes from long text values in Postgres 10 or later. There is md5(), the result of which