Re: Windows 10 got stuck with PostgreSQL at starting up. Adding delay lets it avoid.

TAKATSUKA Haruka schrieb am 29.06.2018 um 08:03: > I got a trouble in PostgreSQL 9.3.x on Windows 10. > I would like to add new delay code as an official build option. > > Windows 10 sometime (approximately once in 300 tries) hung up > at OS starting up. The logs say it happened while the Postgre

Windows 10 got stuck with PostgreSQL at starting up. Adding delay lets it avoid.

I got a trouble in PostgreSQL 9.3.x on Windows 10. I would like to add new delay code as an official build option. Windows 10 sometime (approximately once in 300 tries) hung up at OS starting up. The logs say it happened while the PostgreSQL service was starting. When OS stopped, some postgres a

Re: incorrect resource manager data checksum in record

On Fri, Jun 29, 2018 at 1:14 PM, Devin Christensen wrote: >> From your description it sounds like it's happening in the middle of >> streaming, right? > > Correct. None of the instances in the chain experience a crash. Most of the > time I see the "incorrect resource manager data checksum in recor

Re: incorrect resource manager data checksum in record

> From your description it sounds like it's happening in the middle of streaming, right? Correct. None of the instances in the chain experience a crash. Most of the time I see the "incorrect resource manager data checksum in record" error, but I've also seen it manifested as: invalid magic number

Re: incorrect resource manager data checksum in record

On Fri, Jun 29, 2018 at 5:44 AM, Devin Christensen wrote: > The pattern is the same, regardless of ubuntu or postgresql versions. I'm > concerned this is somehow a ZFS corruption bug, because the error always > occurs downstream of the first ZFS node and ZFS is a recent addition. I > don't know en

Re: Analyze plan of foreign data wrapper

Mathieu PUJOL wrote: > I'am writing a foreign data wrapper. To avoid returning data for a column > that is not used, I parse 'targetlist' and 'qual' of the Plan. > I'am able to find Var nodes but I can't figure out how i could now if this > node is related to a column my foreign table. For a Var

Re: plperl and plperlu language extentsions

On 06/28/2018 12:21 PM, Niles Oien wrote: I got it working, although I found it a bit odd. Although "yum list" showed postgresql10-plperl.x86_64 as being installed, in fact : I don't use RH based systems much so I failed to catch it earlier. From your earlier post: # yum list | grep postgr

incorrect resource manager data checksum in record

I've been seeing this issue in multiple separate hot standby replication chains of PostgreSQL servers (5 so far). There are 4 servers in each chain (some running Ubuntu 14.04 and others Ubuntu 16.04. and PostgreSQL >= 10.1 and <= 11). We also have a mix of ext4 and zfs file systems. Here are the de

Re: Database name with semicolon

2018-06-28 12:10 GMT+02:00 joby.john@nccgroup.trust < Joby.John@nccgroup.trust>: > > See if something like below works: > > {db; name} > > > > Hi, > > Thanks for the responses. > > I tried putting curly brackets around the value of database like you > mentioned. > {db; name} > But the server was t

Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function

Hi, Luca, it'd be cool if you could not top-quote on this list - Thanks! Others - this seems like a potentially more longstanding bug, see the bottom of the mail. Peter, looks like you might be involved specifically. On 2018-06-28 08:26:58 +0200, Luca Ferrari wrote: > Got it: it happens if you

Re: Sv: Re: Sv: Re: CTE optimization fence

On 2018-Jun-27, Andreas Joseph Krogh wrote: > I know. I hate the INLINE proposal and hope default-behaviour will be like in > other DBs, inline like sub-query as default. GUC for preserving fence is what > I > hope will happen. I am probably biased ;-) but I like my proposal #1 in this email h

Re: plperl and plperlu language extentsions

On 06/27/2018 08:27 AM, Niles Oien wrote: Hi, I am running postgres 10.4 on CentOS 7.5. I am having trouble getting the plperl language extension going : netdrms02.nispdc.nso.edu:5432 postgres@nsocu=# CREATE EXTENSION plperl; ERROR:  58P01: could not o

Re: Database name with semicolon

Zitat von "joby.john@nccgroup.trust" : Not sure what else I can try or whether the ODBC driver supports database name with a semicolon at all. Not knowing much about ODBC, how about single quotes? And if you pass the entire URL, would it be possible to pass instead values to Kind of functio

RE: JSONB arrays

From: Victor Noagbodji [mailto:vnoagbo...@amplify-nation.com] Sent: 28 June 2018 11:28 To: pgsql-general Subject: JSONB arrays Hey people, I ended up with the following to check (or similar to return) the intersection of two list of values on a JSONB object:

Re: Database name with semicolon

> See if something like below works: > {db; name} Hi, Thanks for the responses. I tried putting curly brackets around the value of database like you mentioned. {db; name} But the server was treating the brackets as part of the database name and so did not work. I tried double quotes like "db;

RE: Index Gin Creation is taking long time..

From: Anto Aravinth [mailto:anto.aravinth@gmail.com] Sent: 28 June 2018 11:34 To: pgsql-generallists.postgresql.org Subject: Index Gin Creation is taking long time.. Hello, I'm trying to create an index: create index search_idx on so2 using gin (to_tsvector('english',posts)); Looks like

Index Gin Creation is taking long time..

Hello, I'm trying to create an index: create index search_idx on so2 using gin (to_tsvector('english',posts)); Looks like its running atleast for 8hours :( Totally I have 47M records in so2. Not sure why its taking so long time. Any idea or tips to debug while the index creation is going on? T

JSONB arrays

Hey people, I ended up with the following to check (or similar to return) the intersection of two list of values on a JSONB object: array_length( array( select jsonb_array_elements_text(col1) intersect select jsonb_array_elements_text(col2) ), 1) > 0 Is there a better way? Thanks

Re: help understanding create statistic

On 28 June 2018 at 21:38, Luca Ferrari wrote: > CREATE INDEX idx_year > ON expenses ( EXTRACT( year FROM day ) ); > > why is the planner not choosing to use such index on a 'year' raw query? > > EXPLAIN SELECT * FROM expenses > WHERE year = 2016; The expression in the where clause must match the

Re: plperl and plperlu language extentsions

On Thu, Jun 28, 2018 at 9:26 AM Niles Oien wrote: > > Yet plperl would seem to be installed : > > # yum list | grep postgres | grep perl > postgresql-plperl.x86_64 9.2.23-3.el7_4 base > postgresql10-plperl.x86_6410.4-1PGDG.rhel7 pgdg10 >

Analyze plan of foreign data wrapper

Hello! I'am writing a foreign data wrapper. To avoid returning data for a column that is not used, I parse 'targetlist' and 'qual' of the Plan. I'am able to find Var nodes but I can't figure out how i could now if this node is related to a column my foreign table. I guess that the field 'location'

help understanding create statistic

Hi all, in order to better understand this feature of 10, I've created a table like this: CREATE TABLE expenses( ... day date, year int, CHECK( year = EXTRACT( year FROM day ) ) ); so that I can ensure 'year' and 'day' are tied together: SELECT count(*) FILTER( WHERE year = 2016 ) AS

Re: Example setup for Odyssey connection pooler?

Thank you this was helpful On 27-06-18 15:17, Adrian Klaver wrote: On 06/27/2018 06:07 AM, Pablo Hendrickx wrote: Please reply to list also. Ccing list. Yes that's the config file. How do I start Odyssey as a service? There are some example scripts: https://emea01.safelinks.protection.out

plperl and plperlu language extentsions

Hi, I am running postgres 10.4 on CentOS 7.5. I am having trouble getting the plperl language extension going : netdrms02.nispdc.nso.edu:5432 postgres@nsocu=# CREATE EXTENSION plperl; ERROR: 58P01: could not open extension control file "/usr/pgsql-10/share/extension/plperl.control": No such file

RE: EXTERNAL: Re: Database name with semicolon

Hi Pavel, Thanks for coming back to me. The version of the Postgres server where I am trying is: 9.5.3 Yes, I tried putting the database name in double quotes with no luck. Please note we are using PostgreSQL Unicode ODBC driver (version 10.2) to communicate with the server. Regards, Joby John