[GENERAL] the master has two sync slave, which slave can promote to master and the other slave as the new master's slave?

Hi, everyone. I am puzzled about the question: the master A has two slave slave_1 , slave_2 , the version of postgres is 9.3. I want to promote one slave to master, and the other slave as the new master's slave, but which slave should can promote ? get the master-slave information from

[GENERAL] range partitioning of materialized views

I find PostgreSQL's materialized view functionality very useful, but one problem is that when the view gets large, there is no way to refresh part of it. I know that table partitioning is coming in Postgres 10, but I haven't heard anything about ideas for partitioning / sharding of

Re: [GENERAL] Best way to alter a foreign constraint

On 03/18/2017 12:05 PM, Sylvain Marechal wrote: Hello all, Some of my tables were badly designed and have 2 indexes, like the following example (lots of tables have same problem): <<< postgres=# \d test1 Table "public.test1" Column | Type | Modifiers +-+--- t1

[GENERAL] Best way to alter a foreign constraint

Hello all, Some of my tables were badly designed and have 2 indexes, like the following example (lots of tables have same problem): <<< postgres=# \d test1 Table "public.test1" Column | Type | Modifiers +-+--- t1 | integer | not null Indexes:

Re: [GENERAL] CenOS 5/Postgresql 9.6

Hi, On Fri, 2017-03-17 at 12:15 -0700, Steve Crawford wrote: > The question remains - does anyone know where I might find packages so I > don't have to compile them myself? (I'm the maintainer of the repository) There are no packages for CentOS 5 / PG 9.6, and it was my decision to drop