Re: [GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

On Tue, Jan 5, 2016 at 6:58 AM, Adrian Klaver wrote: > On 01/04/2016 12:53 PM, Arthur Pemberton wrote: >> >> Yes, I have tried it without --jobs, just to simplify. >> > > That would have been too easy. Not sure what is going on. > > So are there any other errors, warnings, etc between?: > > Checki

Re: [GENERAL] planner does not detect same-as-default collation.

On Tue, Jan 5, 2016 at 6:39 PM, Jeff Janes wrote: > I don't know if this is a bug, or a surprising feature, or just a > misunderstanding. > > If I specify an explicit collation which happens to be the same as the > default collation, it is not recognized as being the same as the > default. > > sel

Re: [GENERAL] A unique pairs version of UNNEST() ?

Andy Colson wrote: >> So in an example where list_of_ids is {1,2,3,4,5} I would essentially get: >> >> {1, 2} >> {1, 3} >> {1, 4} >> {1, 5} >> {2, 3} >> {2, 4} >> {2, 5} >> {3, 4} >> {3, 5} >> {4, 5} >> >> >> Any tips? Thanks! >> >> -- >> Wells Oliver >> wells.oli...@gmail.com

Re: [GENERAL] Streaming replication stacked.

On Mon, Jan 4, 2016 at 9:08 PM, wrote: > And There is System Version. > - > - PostgreSQL Version : 9.4 > - OS : CentOS6.4 > - Replicaion Type: async > - You are using a version of 9.4 older than 9

Re: [GENERAL] Streaming replication stacked.

Yoji wrote: > Hi, Andreas > > Thank you for reply. > > Below is the recovery.conf. > > -- > standby_mode = on > primary_conninfo = 'host=172.16.xxx.xxx user=xx' > trigger_file = '/tmp/trigger_file0' >

[GENERAL] planner does not detect same-as-default collation.

I don't know if this is a bug, or a surprising feature, or just a misunderstanding. If I specify an explicit collation which happens to be the same as the default collation, it is not recognized as being the same as the default. select version();

Re: [GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

Maybe there was a verbose settings that would have given me that, but what I pasted was literally all the output I got. In the end, I did a pg_dumpapp On Mon, Jan 4, 2016 at 8:40 PM, Adrian Klaver wrote: > On 01/04/2016 02:37 PM, Arthur Pemberton wrote: > >> Nothing useful. I'm just going to giv

Re: [GENERAL] Please help! Server process was terminated by signal 11: Segmentation fault

On Tue, Jan 5, 2016 at 12:36 PM, John R Pierce wrote: > On 1/4/2016 6:07 PM, John Hong wrote: > > EnterpriseDB 9.4.1.3 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) > 4.1.2 20080704 (Red Hat 4.1.2-55), 64-bit > > > > you probably should contact EnterpriseDB technical support. This email > l

Re: [GENERAL] Please help! Server process was terminated by signal 11: Segmentation fault

On 1/4/2016 6:07 PM, John Hong wrote: EnterpriseDB 9.4.1.3 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-55), 64-bit you probably should contact EnterpriseDB technical support. This email list is for the community open source version of PostgreSQL. --

Re: [GENERAL] Streaming replication stacked.

Hi Chiru , Thank you for your information. I send wals to standby server using "wal sender" processes. And I had checked logs but It was nothing. Best regards. Yoji -- View this message in context: http://postgresql.nabble.com/Streaming-replication-stacked-tp5880104p5880288.html Sent

Re: [GENERAL] Streaming replication stacked.

Hi, Andreas Thank you for reply. Below is the recovery.conf. -- standby_mode = on primary_conninfo = 'host=172.16.xxx.xxx user=xx' trigger_file = '/tmp/trigger_file0' -- Best regards. Yoji -- View t

Re: [GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

On 01/04/2016 02:37 PM, Arthur Pemberton wrote: Nothing useful. I'm just going to give up and use pg_dump to a new machine. Hopefully that allows me to bypass this issue. Did that help? To help someone else troubleshoot this, did the error you get occur after the pg_upgrade line: Restoring

Re: [GENERAL] RLS 9.5rc1 configuration changes?

Ted Toth writes: > On Mon, Jan 4, 2016 at 4:54 PM, Tom Lane wrote: >> Are you perhaps testing this as a superuser? Superusers bypass RLS >> even with FORCE ROW LEVEL SECURITY. > Yes I was a Superuser but without 'Bypass RLS'. So there's no way to > enforce RLS for all users/roles? There's no s

Re: [GENERAL] to_timestamp alternatives

On 1/1/16 7:15 AM, Alban Hertroys wrote: Since you're dealing with GPS data and presumably have lat/long, it shouldn't be hard to do this dynamically either, either by just blindly dividing longitude by 15 or using actual timezone shape polygons and @> or <@. That would be a bad idea for globa

Re: [GENERAL] RLS 9.5rc1 configuration changes?

On Mon, Jan 4, 2016 at 4:54 PM, Tom Lane wrote: > Ted Toth writes: >> I had been using CrunchyDatas 9.4 with backported RLS but I decided >> since my ultimate target is 9.5 that I update to it. However now the >> function called for the SELECT policy is not being called. \dt shows >> the policy b

Re: [GENERAL] BDR and TX obeyance

BTW, I'm also looking for a "synchronous multi-master" solution... If you find one, please share :-) The only solution I've found so far is a middleware that is close, the C-Jdbc/Sequoia, which seems not being actively maintained for a while now. Regards, Edson Atenciosamente, Edson Carlos E

Re: [GENERAL] RLS 9.5rc1 configuration changes?

Ted Toth writes: > I had been using CrunchyDatas 9.4 with backported RLS but I decided > since my ultimate target is 9.5 that I update to it. However now the > function called for the SELECT policy is not being called. \dt shows > the policy but EXPLAIN ANALYZE of a select doesn't show the filter.

[GENERAL] RLS 9.5rc1 configuration changes?

I had been using CrunchyDatas 9.4 with backported RLS but I decided since my ultimate target is 9.5 that I update to it. However now the function called for the SELECT policy is not being called. \dt shows the policy but EXPLAIN ANALYZE of a select doesn't show the filter. When I turn up debug in p

Re: [GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

Nothing useful. I'm just going to give up and use pg_dump to a new machine. Hopefully that allows me to bypass this issue. On Mon, Jan 4, 2016 at 4:58 PM, Adrian Klaver wrote: > On 01/04/2016 12:53 PM, Arthur Pemberton wrote: > >> Yes, I have tried it without --jobs, just to simplify. >> >> > Th

Re: [GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

On 01/04/2016 12:53 PM, Arthur Pemberton wrote: Yes, I have tried it without --jobs, just to simplify. That would have been too easy. Not sure what is going on. So are there any other errors, warnings, etc between?: Checking cluster versions ok and SQL com

Re: [GENERAL] Convert 2 foreign key values within the same SELECT

Does this work? SELECT l.me_id AS me, l.you_id AS you, a.l AS left, a.aspect, a.r AS right, l.id AS link_id, c.comment, concat(m.first_name, ' ', m.surname) AS me_name, concat(y.first_name, ' ', y.surname) AS you_name FROM aspects a,

Re: [GENERAL] PostgreSQL GUI tools

On Sun, 2016-01-03 at 03:15 -0700, subhan alimy wrote: > Hello everyone, > > Is there any PostgreSQL GUI tools to pull the tables structure along > with > the relationships? > > > Much appropriated.   > > If you are a Java shop you can use ExecuteQuery from www.executequery.o rg You need to

Re: [GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

Yes, I have tried it without --jobs, just to simplify. # /usr/pgsql-9.3/bin/pg_config BINDIR = /usr/pgsql-9.3/bin DOCDIR = /usr/share/doc/pgsql HTMLDIR = /usr/share/doc/pgsql INCLUDEDIR = /usr/pgsql-9.3/include PKGINCLUDEDIR = /usr/pgsql-9.3/include INCLUDEDIR-SERVER = /usr/pgsql-9.3/include/serve

Re: [GENERAL] BDR and TX obeyance

I think this is the nature of "async multi master"... IMHO, It would be necessary to be "sync multi master" (with two-phase commit?) to get the behavior you expect. Atenciosamente, Edson Carlos Ericksson Richter Em 04/01/2016 18:09, Riley Berton escreveu: I have been experimenting with BDR a

Re: [GENERAL] A unique pairs version of UNNEST() ?

On 1/4/2016 2:08 PM, Wells Oliver wrote: Hey all, happy new year. I am trying to get unique pairs from an array of N numbered items, usually 5, but possibly 4 or 6. If I just wanted unique values, I could do SELECT UNNEST(list_of_ids) AS id, COUNT(*) FROM table GROUP BY id but in this situation

[GENERAL] BDR and TX obeyance

I have been experimenting with BDR and have a question about how BDR interacts with transactions. bdrdemo=# create table thingy (id INT, value TEXT, PRIMARY KEY(id)); CREATE TABLE bdrdemo=# create table tx_log(id INT, msg TEXT, PRIMARY KEY(id)); CREATE TABLE bdrdemo=# insert into thingy (id, value

[GENERAL] A unique pairs version of UNNEST() ?

Hey all, happy new year. I am trying to get unique pairs from an array of N numbered items, usually 5, but possibly 4 or 6. If I just wanted unique values, I could do SELECT UNNEST(list_of_ids) AS id, COUNT(*) FROM table GROUP BY id but in this situation I want all unique pairs and a COUNT. For

Re: [GENERAL] Convert 2 foreign key values within the same SELECT

On 01/04/2016 12:36 PM, gvim wrote: I have a query which successfully retrieves id values "me" and "you" when 2 planetary values are supplied: SELECT l.me_id AS me, l.you_id AS you, a.l AS left, a.aspect, a.r AS right, l.id AS link_id, c.comment FROM aspects a, links_aspects

[GENERAL] Convert 2 foreign key values within the same SELECT

I have a query which successfully retrieves id values "me" and "you" when 2 planetary values are supplied: SELECT l.me_id AS me, l.you_id AS you, a.l AS left, a.aspect, a.r AS right, l.id AS link_id, c.comment FROM aspects a, links_aspects la, links l, syn_comments c WHERE (a.r

Re: [GENERAL] PostgreSQL GUI tools

Thank you very much. -- View this message in context: http://postgresql.nabble.com/PostgreSQL-GUI-tools-tp5879926p5880036.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] COPY FROM STDIN

Is there a way to achieve the performance of the COPY FROM STDIN command within a C extension function connected to the db connection that called the C function? I have text that I would like to receive as input to a C function that contains many COPY command statements in the file that would be

Re: [GENERAL] Shared system resources

On 2015-12-23 11:55:36 -0500, George Neuner wrote: > With sufficient privileges, a debugger-like process can attach and > examine the memory of a running - or just terminated - process, but it > won't have access to discarded (unmapped) memory. You just have to load a kernel module to do so - it's

Re: [GENERAL] Building PostgreSQL 9.6devel sources with Microsoft Visual C++ 2015?

Michael Paquier writes: > On Mon, Jan 4, 2016 at 9:40 PM, Sandeep Thakkar > wrote: >> ... We tried building it with Visual Studio 2015 and Windows 10 >> SDK, but see build errors like >> >> src/backend/utils/adt/pg_locale.c(809): error C2037: left of 'locale_name' >> specifies undefined struct/u

Re: [GENERAL] grep -f keyword data query

On Jan 4, 2016 09:45, "Hiroyuki Sato" wrote: > > Hello Arjen > > Thank you for replying. > > 2016年1月4日(月) 16:49 Arjen Nienhuis : >> >> >> On Dec 28, 2015 00:55, "Hiroyuki Sato" wrote: >> > >> > Hello Andreas and Tom >> > >> > Thank you for replying. >> > >> > Sorry, I re-created my questions. I w

Re: [GENERAL] Streaming replication stacked.

Hi Yoji, Please check is there any network issues ,between master and slave server and also share the slave server pg log output. -Are you shipping wals to standby server using any script other than archive_command which is mentioned master config?. On Mon, Jan 4, 2016 at 5:58 PM, Andreas Kret

Re: [GENERAL] Building PostgreSQL 9.6devel sources with Microsoft Visual C++ 2015?

On Mon, Jan 4, 2016 at 9:40 PM, Sandeep Thakkar wrote: > As per the installation doc available here, > http://www.postgresql.org/docs/devel/static/install-windows.html > > the sources can be built with Microsoft Visual C++ 2005 to Microsoft Visual > C++ 2013. Does it mean the higher version like M

[GENERAL] Building PostgreSQL 9.6devel sources with Microsoft Visual C++ 2015?

Hi As per the installation doc available here, http://www.postgresql.org/docs/devel/static/install-windows.html the sources can be built with Microsoft Visual C++ 2005 to Microsoft Visual C++ 2013. Does it mean the higher version like Microsoft Visual C++ 2015 is not supported? We tried building

Re: [GENERAL] Streaming replication stacked.

y-tsuk...@xseed.co.jp wrote: > - > > Do you have any solution? please show us your recovery.conf. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvald

[GENERAL] Streaming replication stacked.

Hi All, I use streaming replication on systems. But I have an problem. I need your support. The system sometimes stacks Postgres process. So, postgresql data isn't syncing. I checkd process that it was stacked "waiting" status on slave server. e.g.) postgres: startup process recovering 00

Re: [GENERAL] PostgreSQL GUI tools

I recently tried many tools, and "sql power architect" is the tool I have selected. It is compatible with liquibase, and works with postgres, mysql oracle and so on. It allows comparing structure differences between databases. Moreover it has a community free edition that covers my needs. 2016-01-

Re: [GENERAL] grep -f keyword data query

Hello Arjen Thank you for replying. 2016年1月4日(月) 16:49 Arjen Nienhuis : > > On Dec 28, 2015 00:55, "Hiroyuki Sato" wrote: > > > > Hello Andreas and Tom > > > > Thank you for replying. > > > > Sorry, I re-created my questions. I was mis-pasted query log on previous > question. > > (@~ operator i

Re: [GENERAL] grep -f keyword data query

Hello David Thank your for your comment. 2015年12月30日(水) 10:15 David Rowley : > On 30 December 2015 at 13:56, Hiroyuki Sato wrote: > >> 2015年12月30日(水) 6:04 David Rowley : >> >>> On 30 December 2015 at 04:21, Hiroyuki Sato wrote: >>> 2015年12月29日(火) 4:35 Jeff Janes : > > Bu