Re: Localization

2019-05-30 Thread Alvaro Herrera
On 2019-May-30, Yonatan Misgan wrote: > Hello Dear, how are you doing? I am Yonathan Misgan from Ethiopia. > Currently I am working on open source database localization. I highly > requested your advice on how to support my hard code in PostgreSQL. I > am developed Ethiopian locales after all I ha

Postgresql backup via LVM snapshot?

2019-05-30 Thread Lu, Dan
Hello, Would you be able to confirm for me that a host level LVM snapshot of the PGDATA directory along with PG_WAL directly via LVM backup is supported way of backup and restore? I read about this here: https://dba.stackexchange.com/questions/145361/backup-standby-database-using-lvm-snapshot

Re: Questions about btree_gin vs btree_gist for low cardinality columns

2019-05-30 Thread Peter J. Holzer
On 2019-05-30 10:11:36 -0700, Will Hartung wrote: > Well part of the problem is that “B-tree” is a pretty generic term. Pretty > much > every index is either some form of hash, or some form of tree. We use the term > B-tree, even though pretty much no major index is actually a binary tree. There

Localization

2019-05-30 Thread Yonatan Misgan
Hello Dear, how are you doing? I am Yonathan Misgan from Ethiopia. Currently I am working on open source database localization. I highly requested your advice on how to support my hard code in PostgreSQL. I am developed Ethiopian locales after all I have difficulties on how to use this locale.

Re: Questions about btree_gin vs btree_gist for low cardinality columns

2019-05-30 Thread Will Hartung
> On May 29, 2019, at 10:59 AM, Jeremy Finzel wrote: > > > > On Fri, May 24, 2019 at 10:25 AM Jeremy Finzel > wrote: > I have been hoping for clearer direction from the community about > specifically btree_gin indexes for low cardinality columns (as well as low > c

compiling PL/pgSQL plugin with C++

2019-05-30 Thread Тарасов Георгий Витальевич
Dear all, I'm working on development of some PL/pgSQL plugin. The smaller part of my code is written on C. It's a standard extension code for integration with fmgr (_PG_init ...) But bigger part of the code is written on C++. And here I need declarations of internal PL/pgSQL structs from plpgsql

Re: terminating walsender process due to replication timeout

2019-05-30 Thread AYahorau
Hello, I took a look in postgresql source code. As far as I understood walsender can send some data to walreceiver regarding some changes and so-called keepalive messages. Exactly these keepalive messages walsender sends periodically once per wal_sender_timeout seconds (once per 1 second in my

Migrating a Patroni cluster from Ubuntu 16.04 to Ubuntu 18.04

2019-05-30 Thread Peter J. Holzer
I upgraded a cluster from Ubuntu 16.04 to Ubuntu 18.04 this week and since this wasn't as smooth as I hoped I'm posting my experiences here hoping that it will help others. First: No production systems were harmed in the making of this report. We have a test cluster, and it really keeps adrenaline