Re: ZFS filesystem - supported ?

2021-10-23 Thread Mladen Gogala
On 10/23/21 23:12, Lucas wrote: I don't know where you have your database deployed, but in my case is in AWS EC2 instances. The way I handle backups is at the block storage level, performing EBS snapshots. Yes, Amazon uses SAN equipment that supports snapshots. This has proven to work very

Re: ZFS filesystem - supported ?

2021-10-23 Thread Lucas
On 2021-10-24 06:48, Mladen Gogala wrote: On 10/23/21 09:37, Laura Smith wrote: Hi Mladen, Yes indeed, snapshots is the primary reason, closely followed by zfssend/receive. I'm no stranger to using LVM snapshots with ext4/xfs but it requires a custom shell script to manage the whole

Re: Python3 for PostgreSQL 14

2021-10-23 Thread Дмитрий Иванов
Yes, it does. >If you used the EDB installer for the Windows install of Postgres then >you need to use their Language Pack to match up with what the plpython >expects. It was obvious, but it didn't work. This is not a problem at the moment. >This is the Debian project packages, not something the

Re: Python3 for PostgreSQL 14

2021-10-23 Thread Adrian Klaver
On 10/23/21 13:00, Дмитрий Иванов wrote: Да. Python extension issues occurred on Windows Server 2012 and Windows 10 Pro. Experimentally, when installing version 3.7.4, everything worked. If you used the EDB installer for the Windows install of Postgres then you need to use their Language

Re: Python3 for PostgreSQL 14

2021-10-23 Thread Дмитрий Иванов
Да. Python extension issues occurred on Windows Server 2012 and Windows 10 Pro. Experimentally, when installing version 3.7.4, everything worked. This is my first time deploying Debian, and since I didn't want to deploy multiple versions, I asked a question. I have installed Python 3.10 x64. when

Re: ZFS filesystem - supported ?

2021-10-23 Thread Mladen Gogala
On 10/23/21 09:37, Laura Smith wrote: Hi Mladen, Yes indeed, snapshots is the primary reason, closely followed by zfssend/receive. I'm no stranger to using LVM snapshots with ext4/xfs but it requires a custom shell script to manage the whole process around backups. I feel the whole thing

Re: Issue with pg_basebackup v.11

2021-10-23 Thread Tom Lane
Ninad Shah writes: > Would keepalive setting address and mitigate the issue? [ shrug... ] Maybe; nobody else has more information about this situation than you do. I suggested something to experiment with. regards, tom lane

Re: ZFS filesystem - supported ?

2021-10-23 Thread Laura Smith
On Saturday, October 23rd, 2021 at 14:03, Mladen Gogala wrote: > On 10/23/21 07:29, Laura Smith wrote: > > > Hi, > > > > Given an upcoming server upgrade, I'm contemplating moving away from XFS to > > ZFS (specifically the ZoL flavour via Debian 11). BTRFS seems to be falling > > away (e.g.

Re: ZFS filesystem - supported ?

2021-10-23 Thread Mladen Gogala
On 10/23/21 07:29, Laura Smith wrote: Hi, Given an upcoming server upgrade, I'm contemplating moving away from XFS to ZFS (specifically the ZoL flavour via Debian 11). BTRFS seems to be falling away (e.g. with Redhat deprecating it etc.), hence my preference for ZFS. However, somewhere in

Re: WAL streaming and dropping a large table

2021-10-23 Thread Mladen Gogala
On 10/21/21 16:23, Rory Falloon wrote: Hi, My postgres server setup is thus: a production database, which is using WAL streaming (hot standby) to four other hosts of various latencies. I Have a table that is ~200GB which has been backed up, and now I Want to remove it. The table is not in

ZFS filesystem - supported ?

2021-10-23 Thread Laura Smith
Hi, Given an upcoming server upgrade, I'm contemplating moving away from XFS to ZFS (specifically the ZoL flavour via Debian 11). BTRFS seems to be falling away (e.g. with Redhat deprecating it etc.), hence my preference for ZFS. However, somewhere in the back of my mind I seem to have a