Re: Wall shiping replica failed to recover database with error: invalid contrecord length 1956 at FED/38FFE208

Hello, čt 3. 10. 2019 v 0:09 odesílatel Stephen Frost napsal: > Greetings, > > * Aleš Zelený (zeleny.a...@gmail.com) wrote: > > But recovery on replica failed to proceed WAL file > > 00010FED0039 with log message: " invalid contrecord length > > 1956 at FED/38FFE208". > > Err- you'v

Advice for geographically dispersed multi master

-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 Hi, /* Disclaimer: I am primarily a systems administrator with some database and DBA history. Although these days I would normally leave this kind of thing to a seasoned DBA this is for my personal use, and the use of a non- profit or

Re: partitions vs indexes

On 2 Oct 2019, at 22:16, Michael Lewis wrote: "I would like to convert a table with a primary key into a partitioned setup by a column which is not part of the primary key" That isn't possible. The partition key must be contained by the primary key. That is, the primary key could be site_id, i

Re: Advice for geographically dispersed multi master

Nikolai Lusan schrieb am 03.10.2019 um 11:05: I have read the various replication and clustering documentation for postgresql 11, and it looks like what I want is "Synchronous Multimaster Replication". The organisation I am doing this for does not have the money to throw at a commercial solution

PMChildFlags array

Hi, Observed below errors in logfile 2019-09-20 02:00:24.504 UTC,,,99779,,5d73303a.185c3,73,,2019-09-07 04:21:14 UTC,,0,FATAL,XX000,"no free slots in PMChildFlags array","" 2019-09-20 02:00:24.505 UTC,,,109949,,5d8432b8.1ad7d,1,,2019-09-20 02:00:24 UTC,,0,ERROR,58P01,"could not open shar

Re: Advice for geographically dispersed multi master

On Thu, 2019-10-03 at 19:05 +1000, Nikolai Lusan wrote: > So I am looking to move my current setup of 3 separate, individual, > postgres 11 servers into a multi master cluster. > > I have read the various replication and clustering documentation for > postgresql 11, and it looks like what I want i

Re: partitions vs indexes

On Wed, 2019-10-02 at 22:09 +0200, Enrico Thierbach wrote: > would like to convert a table with a primary key into a partitioned > setup by a column which is not part of the primary key. Also, a > column might hold a referenece to a parent row. So this is my current > table setup, slimmed down: >

Re: Urgent :: Postgresql streaming replication issue - sync mode

On Wed, 2019-10-02 at 23:58 +0530, Shital A wrote: > We are seeing a strange issue with postgresql streaming application > in sync mode. > > We are using postgresql 9.6. Old version because of some specific > requirements. We have setup cluster with master-standby using > pacemaker. > > When w

Re: PMChildFlags array

Any suggestions on this ? On Thu, 3 Oct 2019 at 16:27, bhargav kamineni wrote: > Hi, > > Observed below errors in logfile > > 2019-09-20 02:00:24.504 UTC,,,99779,,5d73303a.185c3,73,,2019-09-07 > 04:21:14 UTC,,0,FATAL,XX000,"no free slots in PMChildFlags array","" > 2019-09-20 02:00:24.5

Re: PMChildFlags array

On 10/3/19 3:57 AM, bhargav kamineni wrote: Hi, Observed below errors  in logfile 2019-09-20 02:00:24.504 UTC,,,99779,,5d73303a.185c3,73,,2019-09-07 04:21:14 UTC,,0,FATAL,XX000,"no free slots in PMChildFlags array","" 2019-09-20 02:00:24.505 UTC,,,109949,,5d8432b8.1ad7d,1,,2019-09-20

Re: performance of pg_upgrade "Copying user relation files"

On 10/2/19 5:47 PM, Adrian Klaver wrote: On 10/2/19 4:58 PM, Glenn Pierce wrote: Please reply to list also. Ccing list. On Thu, 3 Oct 2019, 00:11 Adrian Klaver, > wrote:     On 10/2/19 3:30 PM, Glenn Pierce wrote: > I have been trying to upgrade postgre

Re: psql \copy hanging

On 10/2/19 11:51 PM, Arnaud L. wrote: Hi list, Le 28/08/2019 à 09:43, Luca Ferrari a écrit : I don't want to be pedantic, but I would have tried with a single change at a time. And my bet is: the local file would do the trick (i.e., it is a weird share problem). Well, this problem is still b

Re: psql \copy hanging

Le 03/10/2019 à 15:54, Adrian Klaver a écrit : On 10/2/19 11:51 PM, Arnaud L. wrote: Well, this problem is still bugging me, and this time I've tried with a local file. Unfortunately, it did not help. To further rule out filesystem problems, I first took care to delete the target files before c

Re: psql \copy hanging

On 10/3/19 7:13 AM, Arnaud L. wrote: Le 03/10/2019 à 15:54, Adrian Klaver a écrit : On 10/2/19 11:51 PM, Arnaud L. wrote: Well, this problem is still bugging me, and this time I've tried with a local file. Unfortunately, it did not help. To further rule out filesystem problems, I first took car

Re: Urgent :: Postgresql streaming replication issue - sync mode

I read this https://www.2ndquadrant.com/en/blog/evolution-fault-tolerance-postgresql-synchronous-commit/ But don't see why your primary would have more records than the standby? If killall was issued before commit returned, that means the transaction wasn't completed so yes you would lose records

Re: Urgent :: Postgresql streaming replication issue - sync mode

On Fri, 2019-10-04 at 00:34 +1000, Jason Wang wrote: > I read this > https://www.2ndquadrant.com/en/blog/evolution-fault-tolerance-postgresql-synchronous-commit/ > > But don't see why your primary would have more records than the > standby? > > If killall was issued before commit returned, that

Re: PMChildFlags array

> Hi, > > Observed below errors in logfile > > 2019-09-20 02:00:24.504 UTC,,,99779,,5d73303a.185c3,73,,2019-09-07 > 04:21:14 UTC,,0,FATAL,XX000,"no free slots in PMChildFlags array","" > 2019-09-20 02:00:24.505 UTC,,,109949,,5d8432b8.1ad7d,1,,2019-09-20 > 02:00:24 UTC,,0,ERROR,58P01,"could

PG12

Main page (https://www.postgresql.org/) announces new release, but Downloads for Windows page (https://www.postgresql.org/download/windows/) doesn't list PG12. Any clarification? Regards, Igor Neyman

RE: PG12

From: Igor Neyman [mailto:iney...@perceptron.com] Sent: Thursday, October 03, 2019 12:27 PM To: pgsql-general@lists.postgresql.org Subject: PG12 Main page (https://www.postgresql.org/) announces new release, but Downloads for Windows page (https://www.postgresql.org/download/windows/) doesn't lis

Re: PG12

On 10/3/19 9:27 AM, Igor Neyman wrote: Main page (https://www.postgresql.org/) announces new release, but Downloads for Windows page (https://www.postgresql.org/download/windows/) doesn’t list PG12. Any clarification? It is available: https://www.enterprisedb.com/downloads/postgres-postgres

Re: PMChildFlags array

bhargav kamineni writes: > Postgres was rejecting a bunch of connections from a user who is having a > connection limit set. that was the the FATAL error that i could see in log > file. > FATAL,53300,"too many connections for role ""user_app""" > db=\du user_app >List

RE: PG11 Parallel Thanks!!

>On Wed, Oct 2, 2019 at 8:41 AM Jason Ralph >wrote: > Since pg11 on both the target and source, the run time has decreased a lot, I > chalk it up to the parallel index creations in pg11 which was a very time > consuming >process on pg9.3. > The process has finished almost 10 hours earlier than

Re: PMChildFlags array

bhargav kamineni writes: > Postgres was rejecting a bunch of connections from a user who is having a > connection limit set. that was the the FATAL error that i could see in log > file. > FATAL,53300,"too many connections for role ""user_app""" > db=\du user_app >List

Re: PG12

On Thu, Oct 3, 2019 at 6:31 PM Adrian Klaver wrote: > On 10/3/19 9:27 AM, Igor Neyman wrote: > > Main page (https://www.postgresql.org/) announces new release, but > > Downloads for Windows page > > (https://www.postgresql.org/download/windows/) doesn’t list PG12. > > > > Any clarification? > > I

BitmapAnd on correlated column?

I'm running the following query on Postgres version 10.8: SELECT count(*) FROM test_table WHERE and id_column_1 IN (9954, 9690, 9689, 9688) AND id_column_2 IN (75328, 51448, 48060, 48065, 51803, 51449, 51802, 48064, 48061, 48062, 48059, 48063, 121834, 326649, 303167, 303249, 336838, 334172, 30341

Re: BitmapAnd on correlated column?

On 10/3/19 3:22 PM, greigwise wrote: I'm running the following query on Postgres version 10.8: SELECT count(*) FROM test_table WHERE and id_column_1 IN (9954, 9690, 9689, 9688) AND id_column_2 IN (75328, 51448, 48060, 48065, 51803, 51449, 51802, 48064, - Sent from: https://www.postgresql-arc

Re: BitmapAnd on correlated column?

yes. where and is a typo. -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: PMChildFlags array

bhargav kamineni writes: >> What was the database doing just before the FATAL line? > Postgres was rejecting a bunch of connections from a user who is having a > connection limit set. that was the the FATAL error that i could see in log > file. > FATAL,53300,"too many connections for role ""user

Re: PMChildFlags array

On 2019-Oct-03, bhargav kamineni wrote: > bhargav kamineni writes: > > Postgres was rejecting a bunch of connections from a user who is having a > > connection limit set. that was the the FATAL error that i could see in log > > file. > > FATAL,53300,"too many connections for role ""user_app""" >

Re: pg12 rc1 on CentOS8 depend python2

> Users of these (now contrib) modules need to have > postgresql12-plpython3 installed anyway, so it's unlikely you'd be > breaking anyone's installation. I agree. To use these EXTENSION(hstore_plpython,jsonb_plpython, and ltree_plpython), we need to install plpythonu anyway. I don't think it woul