Re: Finding free time period on non-continous tstzrange field values

2022-11-30 Thread Amitabh Kant
On Wed, Nov 30, 2022 at 7:13 PM Amitabh Kant wrote: > Hi > > Given the following table, how do I find free time period. > > CREATE TABLE test_time_range ( > id SERIAL PRIMARY KEY, > time_range tstzrange); > > > Insert into test_time_range(time_range) values('[2022-11-28 08:00:00, >

Librephotos on Synology DSM with Docker Problem with PostGres

2022-11-30 Thread Preston Zimmerer
Hello, looking for some help. I am trying to put Librephotos on my NAS that's running DSM using Docker but I'm getting this error on the postgres image/container I have the "librephotos-docker-main" folder placed into the docker folder on my host machine, and I tried creating a directory "db" in

Re: postgres large database backup

2022-11-30 Thread Ron
On 11/30/22 19:41, Michael Loftis wrote: On Wed, Nov 30, 2022 at 18:03 Mladen Gogala wrote: On 11/30/22 18:19, Hannes Erven wrote: You could also use a filesystem that can do atomic snapshots - like ZFS. Uh, oh. Not so sure about that. Here is a page from the world of the

Re: postgres large database backup

2022-11-30 Thread Michael Loftis
On Wed, Nov 30, 2022 at 18:03 Mladen Gogala wrote: > On 11/30/22 18:19, Hannes Erven wrote: > > You could also use a filesystem that can do atomic snapshots - like ZFS. > > Uh, oh. Not so sure about that. Here is a page from the world of the big > O: https://blog.docbert.org/oracle-on-zfs/ > >

Re: postgres large database backup

2022-11-30 Thread Mladen Gogala
On 11/30/22 18:19, Hannes Erven wrote: You could also use a filesystem that can do atomic snapshots - like ZFS. Uh, oh. Not so sure about that. Here is a page from the world of the big O: https://blog.docbert.org/oracle-on-zfs/ However, similar can be said about ZFS. ZFS snapshots will slow

Re: postgres large database backup

2022-11-30 Thread Hannes Erven
Am 30.11.22 um 20:01 schrieb Mladen Gogala: On 11/30/22 10:40, Atul Kumar wrote: Hi, I have a 10TB database running on postgres 11 version running on centos 7 "on premises", I need to schedule the backup of this database in a faster way. The scheduled backup will be used for PITR purposes.

Re: postgres large database backup

2022-11-30 Thread Ron
On 11/30/22 11:41, Vijaykumar Jain wrote: On Wed, Nov 30, 2022, 9:10 PM Atul Kumar wrote: Hi, I have a 10TB database running on postgres 11 version running on centos 7 "on premises", I need to schedule the backup of this database in a faster way. The scheduled backup

Re: postgres large database backup

2022-11-30 Thread Mladen Gogala
On 11/30/22 10:40, Atul Kumar wrote: Hi, I have a 10TB database running on postgres 11 version running on centos 7 "on premises", I need to schedule the backup of this database in a faster way. The scheduled backup will be used for PITR purposes. So please let me know how I should do it in

Re: postgresql 13.1: precision of spatial operations

2022-11-30 Thread Brad White
On 11/30/2022 9:48 AM, Вадим Самохин wrote: Thank you so much Ivan, it worked! Can you give any more detail on which approach you took, for the sake of future followers?

Re: postgres large database backup

2022-11-30 Thread Vijaykumar Jain
On Wed, Nov 30, 2022, 9:10 PM Atul Kumar wrote: > Hi, > > I have a 10TB database running on postgres 11 version running on centos 7 > "on premises", I need to schedule the backup of this database in a faster > way. > > The scheduled backup will be used for PITR purposes. > > So please let me

Re: postgres large database backup

2022-11-30 Thread Christophe Pettus
> On Nov 30, 2022, at 07:40, Atul Kumar wrote: > So please let me know how I should do it in a quicker backup for my 10TB > database ? Is there any tool to take backups and subsequently incremental > backups in a faster way and restore it for PITR in a faster way when required. For an

Re: postgres large database backup

2022-11-30 Thread Michael Loftis
On Wed, Nov 30, 2022 at 8:40 AM Atul Kumar wrote: > > Hi, > > I have a 10TB database running on postgres 11 version running on centos 7 "on > premises", I need to schedule the backup of this database in a faster way. > > The scheduled backup will be used for PITR purposes. > > So please let me

postgres large database backup

2022-11-30 Thread Atul Kumar
Hi, I have a 10TB database running on postgres 11 version running on centos 7 "on premises", I need to schedule the backup of this database in a faster way. The scheduled backup will be used for PITR purposes. So please let me know how I should do it in a quicker backup for my 10TB database ?

Re: Finding free time period on non-continous tstzrange field values

2022-11-30 Thread Amitabh Kant
On Wed, Nov 30, 2022 at 7:20 PM Marcos Pegoraro wrote: > Given the following table, how do I find free time period. >> > > > https://www.crunchydata.com/blog/better-range-types-in-postgres-14-turning-100-lines-of-sql-into-3 > Thanks Marcos .. Had seen this earlier but somehow slipped my mind to

Re: Finding free time period on non-continous tstzrange field values

2022-11-30 Thread Marcos Pegoraro
> > Given the following table, how do I find free time period. > https://www.crunchydata.com/blog/better-range-types-in-postgres-14-turning-100-lines-of-sql-into-3

Finding free time period on non-continous tstzrange field values

2022-11-30 Thread Amitabh Kant
Hi Given the following table, how do I find free time period. CREATE TABLE test_time_range ( id SERIAL PRIMARY KEY, time_range tstzrange); Insert into test_time_range(time_range) values('[2022-11-28 08:00:00, 2022-11-28 20:00:00]'); Insert into test_time_range(time_range)

Re: PostgreSQL extension for processing Graph queries (Apache AGE)

2022-11-30 Thread Alvaro Herrera
On 2022-Nov-29, Young Seung Andrew Ko wrote: > Hello PostgreSQL users, > > https://github.com/apache/age > Apache AGE is an Apache 2-licensed open source PostgreSQL extension for > storing Graph data. > > The current version of Apache AGE is to enable PostgreSQL users to use > Neo4j's