Re: [GENERAL] OS X 10.11.3, psql, bus error 10, 9.5.1

2016-03-11 Thread Chris Ruprecht
Hey Tom, I can't reboot right now, working on a client's machine remotely, but I'l test that tomorrow and keep you posted. Thanks for the link. > On Mar 11, 2016, at 22:40, Tom Lane wrote: > > I'd bet a nickel this is caused by El Capitan's "System Integrity > Protection"

Re: [GENERAL] OS X 10.11.3, psql, bus error 10, 9.5.1

2016-03-11 Thread Tom Lane
Chris Ruprecht writes: > today, I built PG 9.5.1 on my Mac. Everything went fine with the build, as > usual but after installing everything, psql did nothing but give a 'bus > error: 10'. Loading it into gdb gave me more details: > Program received signal SIGBUS, Bus error.

Re: [GENERAL] enum bug

2016-03-11 Thread Elein
Elein Mustain el...@varlena.com 510-637-9106 > On Mar 11, 2016, at 3:45 PM, David G. Johnston > wrote: > >> On Fri, Mar 11, 2016 at 4:19 PM, Elein wrote: > >> An unused (yet) enum type cannot display the enum ranges. An empty table >>

[GENERAL] OS X 10.11.3, psql, bus error 10, 9.5.1

2016-03-11 Thread Chris Ruprecht
Hello friends, today, I built PG 9.5.1 on my Mac. Everything went fine with the build, as usual but after installing everything, psql did nothing but give a 'bus error: 10'. Loading it into gdb gave me more details: Program received signal SIGBUS, Bus error. 0x00010001be6c in

Re: [GENERAL] enum bug

2016-03-11 Thread David G. Johnston
On Fri, Mar 11, 2016 at 4:19 PM, Elein wrote: > An unused (yet) enum type cannot display the enum ranges. An empty table > containing that type cannot display enum ranges. > ​Yes, it can. ​CREATE TYPE rainbow AS enum ('red','orange','yellow','blue','purple'); SELECT

[GENERAL] BDR not catching up

2016-03-11 Thread cchee-ob
I'm getting this message repeating on the UDR node that I just added today. Any way to get it start applying? svp2=# select * from bdr.bdr_nodes; node_sysid | node_timeline | node_dboid | node_status | node_name|node_local_dsn |

Re: [GENERAL] enum bug

2016-03-11 Thread Elein
The point is that enum information belongs to a type, not a column value of that type. This is the difference between a class and a class instance. If you get that, you understand. The workaround suggested only works if some non-empty row in some table has a column defined to be that enum

Re: [GENERAL] enum bug

2016-03-11 Thread David G. Johnston
On Fri, Mar 11, 2016 at 2:55 PM, Melvin Davidson wrote: > Enums are evil! > http://www.lornajane.net/posts/2010/is-enum-evil > > ​Using red background is evil :) I'll disagree on the premise but will agree that without a better implementation and handling of change our

Re: [GENERAL] enum bug

2016-03-11 Thread David G. Johnston
On Fri, Mar 11, 2016 at 2:36 PM, Elein wrote: > > > Bug/Improvement: > > > >Enums belong to types, not to column values. > > > >* Create a built in function, like enum_range( type ), independent of > tables > > that shows a type's enum values. > >create or

Re: [GENERAL] enum bug

2016-03-11 Thread John R Pierce
On 3/11/2016 1:36 PM, Elein wrote: >Bug/Improvement: > >Enums belong to types, not to column values I've read this post twice, and I'm still unclear on what you're saying is a problem, and what your proposed solution is... -- john r pierce, recycling bits in santa cruz -- Sent

Re: [GENERAL] enum bug

2016-03-11 Thread Melvin Davidson
On Fri, Mar 11, 2016 at 4:36 PM, Elein wrote: > > > Bug/Improvement: > > > >Enums belong to types, not to column values. > > > >* Create a built in function, like enum_range( type ), independent of > tables > > that shows a type's enum values. > >create or

[GENERAL] enum bug

2016-03-11 Thread Elein
> Bug/Improvement: > >Enums belong to types, not to column values. > >* Create a built in function, like enum_range( type ), independent of > tables > that shows a type's enum values. >create or replace function enum_range( typein regtype ) returns name[] > language sql

Re: [GENERAL] How to setup Active Directory users in Postgres 9.3.11

2016-03-11 Thread Wyatt Sanford
Hello Giuseppe, Thank you for your reply. After obtaining more information from our network personnel and a little trial and error, I was able to get the pg_hba.conf file edited correctly specifying ldap authentication against our Active Directory domain and users can now connect. Your

Re: [GENERAL] Cannot create role, no default superuser role exists

2016-03-11 Thread Adrian Klaver
On 03/10/2016 05:07 PM, Robert McAlpine wrote: Thank you for the quick reply. I very recently had some success by doing a complete purge of postgresql-9.5, reinstalling and then copying in the original data directory (or I guess I could have just pointed to it, but w/e). I did not expect this

Re: [GENERAL] Unable to match same value in field.

2016-03-11 Thread Adrian Klaver
On 03/11/2016 12:19 AM, Condor wrote: On 10-03-2016 15:37, Adrian Klaver wrote: On 03/10/2016 01:09 AM, Condor wrote: Hello, I using postgresql 9.5.1 and I have problem to match value in one field. Both tables are text: =# \d list_cards_tbl; Column | Type |

Re: [GENERAL] Regarding connection drops for every few minutes

2016-03-11 Thread Scott Marlowe
On Fri, Mar 11, 2016 at 3:22 AM, Durgamahesh Manne wrote: > Hi Sir > > As per above discussion.GOOD response from PostgreSQL > > i am very happy to work on PostgreSQL.Super fast response only from postgres > team regarding i asked any question related to postgres >

Re: [GENERAL] Regarding connection drops for every few minutes

2016-03-11 Thread Scott Marlowe
On Fri, Mar 11, 2016 at 2:22 AM, Durgamahesh Manne wrote: > hi > > the following info generating in pg_log > > LOG: could not receive data from client: Connection reset by peer > LOG: could not receive data from client: Connection reset by peer > LOG: could not

Re: [GENERAL] "PostgreSQL" Version 9.3 Supportability

2016-03-11 Thread Andreas Kretschmer
> "Harish Kumar Gudur (DATA GLOVE INCORPORATED DBA TR)" > hat am 11. März 2016 um 13:27 geschrieben: > > > Hi Team, > We are planning to migrate few Vendor based applications from Windows Server > 2003 to the latest server Operating System Windows Server 2012/2008.

[GENERAL] "PostgreSQL" Version 9.3 Supportability

2016-03-11 Thread Harish Kumar Gudur (DATA GLOVE INCORPORATED DBA TR)
Hi Team, We are planning to migrate few Vendor based applications from Windows Server 2003 to the latest server Operating System Windows Server 2012/2008. Before migration we would like to do the assessment of the application and check the supportability. We are performing the assessment for:

[GENERAL] MongoDB 3.2 beating Postgres 9.5.1?

2016-03-11 Thread Paul Jones
I have been running the EDB benchmark that compares Postgres and MongoDB. I believe EDB ran it against PG 9.4 and Mongo 2.6. I am running it against PG 9.5.1 and Mongo 3.2 with WiredTiger storage using 10,000,000 JSON records generated by the benchmark. It looks like Mongo is winning, and

Re: [GENERAL] recovering database from a linux file system

2016-03-11 Thread Pierre Chevalier Géologue
Hi, Le 10/03/2016 21:10, John R Pierce a écrit : On 3/10/2016 12:05 PM, Alka Gupta wrote: The vendor won't give us any way to access the machine and retrieve the DB, so I removed the HDD and connected it to my Linux laptop. I was able to grab all the DB files and copy them to my Windows

Re: [GENERAL] Regarding connection drops for every few minutes

2016-03-11 Thread Durgamahesh Manne
Hi Sir As per above discussion.GOOD response from PostgreSQL i am very happy to work on PostgreSQL.Super fast response only from postgres team regarding i asked any question related to postgres regards mahesh On Fri, Mar 11, 2016 at 3:28 PM, John R Pierce wrote: > On

Re: [GENERAL] Regarding connection drops for every few minutes

2016-03-11 Thread John R Pierce
On 3/11/2016 1:50 AM, Durgamahesh Manne wrote: Thanks for quick response .as per above conversation. for which parameter i can comment to resolve the issue & please specify the value of parameter sir LOG: could not receive data from client: Connection reset by peer your client is

[GENERAL] regarding postgres feedback

2016-03-11 Thread Durgamahesh Manne
Hi Sir i am very happy to work on PostgreSQL.Super fast response only from postgres team regarding i asked any question related to postgres regards mahesh

Re: [GENERAL] Regarding connection drops for every few minutes

2016-03-11 Thread John R Pierce
On 3/11/2016 1:04 AM, Durgamahesh Manne wrote: Connection reset by peer that TCP/IP error means the client disconnected without cleanly closing the socket. It can also happen if something in the network between the client and the server dropped the connection. -- john r pierce,

[GENERAL] Regarding connection drops for every few minutes

2016-03-11 Thread Durgamahesh Manne
hi the following info generating in pg_log LOG: could not receive data from client: Connection reset by peer LOG: could not receive data from client: Connection reset by peer LOG: could not receive data from client: Connection reset by peer LOG: could not receive data from client: Connection

[GENERAL] Re: [pgsql-in-general] Regarding connection drops for every few minutes

2016-03-11 Thread John Purdie
Please unsubscirbe From: pgsql-in-general-ow...@postgresql.org [mailto:pgsql-in-general-ow...@postgresql.org] On Behalf Of Durgamahesh Manne Sent: 11 March 2016 09:04 To: pgsql-general@postgresql.org; pgsql-in-gene...@postgresql.org Subject: [pgsql-in-general] Regarding connection drops for

[GENERAL] Regarding connection drops for every few minutes

2016-03-11 Thread Durgamahesh Manne
hi the following info generating in pg_log LOG: could not receive data from client: Connection reset by peer LOG: could not receive data from client: Connection reset by peer LOG: could not receive data from client: Connection reset by peer LOG: could not receive data from client: Connection

Re: [GENERAL] Unable to match same value in field.

2016-03-11 Thread Condor
On 10-03-2016 15:37, Adrian Klaver wrote: On 03/10/2016 01:09 AM, Condor wrote: Hello, I using postgresql 9.5.1 and I have problem to match value in one field. Both tables are text: =# \d list_cards_tbl; Column | Type | Modifiers