Re: RES: Postgresql Crasching

On 1/25/19 10:50 AM, Márcio Antônio Sepp wrote: On 1/25/19 10:21 AM, Márcio Antônio Sepp wrote: Hi all, We are experiencing the follow error in last few weeks: Jan 25 16:03:51 FreeBSD11 kernel: pid 78639 (postgres), uid 770: exited on signal 11 (core dumped) Jan 25 16:03:51 FreeBSD11

RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5

Well, happy to report pg_upgrade worked, and have 9.5 cluster up and running. Will be testing during weekend but everything looks ok. Just had to tweak a few settings that changed from 9.3 to 9.5 (logs and checkpoint_segments). Life's good. Thanks again, and just have to say it - open source

RES: Postgresql Crasching

> > On 1/25/19 10:21 AM, Márcio Antônio Sepp wrote: > > > > Hi all, > > > > > > We are experiencing the follow error in last few weeks: > > > > Jan 25 16:03:51 FreeBSD11 kernel: pid 78639 (postgres), uid 770: exited > on > > signal 11 (core dumped) > > Jan 25 16:03:51 FreeBSD11 postgres[73403]:

Re: Postgresql Crasching

=?iso-8859-1?Q?M=E1rcio_Ant=F4nio_Sepp?= writes: > We are experiencing the follow error in last few weeks: > Jan 25 16:03:51 FreeBSD11 kernel: pid 78639 (postgres), uid 770: exited on > signal 11 (core dumped) > # select version(); > PostgreSQL 11.0 on amd64-portbld-freebsd11.2, compiled by

Re: Postgresql Crasching

On 1/25/19 10:21 AM, Márcio Antônio Sepp wrote: Hi all, We are experiencing the follow error in last few weeks: Jan 25 16:03:51 FreeBSD11 kernel: pid 78639 (postgres), uid 770: exited on signal 11 (core dumped) Jan 25 16:03:51 FreeBSD11 postgres[73403]: [7-1] 2019-01-25 16:03:51.135 -02

RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5

Tom, can't thank you enough. Now, the 2nd query and results are like so: select pg_describe_object(classid,objid,objsubid), deptype from pg_depend where refobjid = 'sde.st_envelope'::regtype; "function st_envelope_in(cstring)";"n" "function st_envelope_out(st_envelope)";"n" "type

Postgresql Crasching

Hi all, We are experiencing the follow error in last few weeks: Jan 25 16:03:51 FreeBSD11 kernel: pid 78639 (postgres), uid 770: exited on signal 11 (core dumped) Jan 25 16:03:51 FreeBSD11 postgres[73403]: [7-1] 2019-01-25 16:03:51.135 -02 [73403] WARNING: terminating connection because of

Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5

Duarte Carreira writes: > So I proceeded with the 2 queries: > select pg_describe_object(refclassid,refobjid,refobjsubid), deptype from > pg_depend where objid = 'sde.st_envelope'::regtype; > "schema sde";"n" > "function st_envelope_in(cstring)";"n" > "function st_envelope_out(st_envelope)";"n"

RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5

Just a footnote. This is not a postgis object, it's an esri object. Belongs to the sde schema that is installed in every database where esri software is installed in, namely arcgis server. -Mensagem original- De: Duarte Carreira Enviada: 25 de janeiro de 2019 18:03 Para: 'Tom Lane'

RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5

First, I'd like to apologize for posting the dump file to the whole list... I wish I could delete it, at least the attachment... I ran the explain plan, and got a seq scan, so no faulty index: "Sort (cost=5073.45..5195.00 rows=48622 width=17)" " Sort Key: classid, objid" " -> Seq Scan on

Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5

Duarte Carreira writes: > Sure, I'll be sending you the dump shortly off-list. Hmph. So the problem seems to be that pg_dump isn't emitting a "shell type" command for sde.st_envelope. The first mention of that type is in the "CREATE FUNCTION sde.st_envelope_in..." command, and that won't have

RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5

Sure, I'll be sending you the dump shortly off-list. Duarte -Mensagem original- De: Tom Lane Enviada: 25 de janeiro de 2019 14:28 Para: Duarte Carreira Cc: pgsql-gene...@postgresql.org Assunto: Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5 Duarte Carreira

Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5

Duarte Carreira writes: > Tom, just did a pg_dump -s from 9.3 and there are no warnings in the output > file. It goes smoothly and fast (few seconds). Database is around 50GB, > schema 9MB. Has postgis and a few more extensions - ogr_fdw (from postigs), > file_fdw, postgres_fdw, table_func.

RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5

Tom, just did a pg_dump -s from 9.3 and there are no warnings in the output file. It goes smoothly and fast (few seconds). Database is around 50GB, schema 9MB. Has postgis and a few more extensions - ogr_fdw (from postigs), file_fdw, postgres_fdw, table_func. I also did a pg_dumpall -s and also

RE: Full text search with more than one word

Hi Magnus , Example- Search keyword is ("Marketing Coordinator" OR "Marketing Specialist" OR "Marketing Associate" ) AND "Creative Suite". Thank you for your information , phraseto_tsquery() is supporting two word search or phase search where as it is not supporting logical operator

Re: Full text search with more than one word

Again, please do not top-post on the postgresql mailinglists, it's considered rude. On Fri, Jan 25, 2019 at 12:56 PM Ritanjali Majihee < rmaj...@247headhunting.com> wrote: > Hi Magnus , > > > > Example- Search keyword is ("Marketing Coordinator" OR "Marketing > Specialist" OR "Marketing

Re: Sv: Re: Geographical multi-master replication

On Fri., 25 Jan. 2019, 8:40 pm Andreas Kretschmer > > Am 25.01.19 um 10:10 schrieb Andreas Joseph Krogh: > > To my surprise I'm unable to find downloadable BDR3. I thought it was > > an open-source extention to vanilla-pg-11, isn't that the case anymore? > > yeah, you have to sign a support

Re: Sv: Re: Geographical multi-master replication

Am 25.01.19 um 10:10 schrieb Andreas Joseph Krogh: To my surprise I'm unable to find downloadable BDR3. I thought it was an open-source extention to vanilla-pg-11, isn't that the case anymore? yeah, you have to sign a support contract. It works as a extension to vanilla-pg-11, but it's not

Sv: Re: Geographical multi-master replication

På fredag 25. januar 2019 kl. 06:45:43, skrev Andreas Kretschmer < andr...@a-kretschmer.de >: Am 25.01.19 um 06:10 schrieb Jeremy Finzel: > >     The problem is that the version for BDR 1.0.7, which has an >     implementation for postgres 9.4, will be on end