Re: [GENERAL] testcase failing on git master / how to progress

2017-03-17 Thread Tom Lane
Martin F writes: > I did build with > make clean distclean > ./configure --prefix=/deploys/postgresql/inst/ --with-pgport=5433 > --enable-debug CFLAGS="-ggdb -O0 -g3 -fno-omit-frame-pointer" > make > make install That looks like it ought to work. Did you get any compile warnings? (Personally

Re: [GENERAL] testcase failing on git master / how to progress

2017-03-17 Thread Martin F
On 18/03/2017 01:22, Adrian Klaver wrote: On 03/17/2017 06:07 PM, Martin F wrote: Hi, I just started last week to build postgresql from source. (So this may well be something I did wrong on my side) Do you really want to build the latest dev version? Yes, I want the latest, and I understand,

Re: [GENERAL] testcase failing on git master / how to progress

2017-03-17 Thread Adrian Klaver
On 03/17/2017 06:07 PM, Martin F wrote: Hi, I just started last week to build postgresql from source. (So this may well be something I did wrong on my side) Do you really want to build the latest dev version? If not and you want a specific version you should look here: https://www.postgresql.

[GENERAL] testcase failing on git master / how to progress

2017-03-17 Thread Martin F
Hi, I just started last week to build postgresql from source. (So this may well be something I did wrong on my side) I am on branch master Revision: f7819baa618c528f60e266874051563ecfe08207 Date: 17/03/2017 18:58:06 I did build with make clean distclean ./configure --prefix=/deploys/postg

Re: [GENERAL] psql - looking in wrong place for socket

2017-03-17 Thread George Neuner
On Fri, 17 Mar 2017 10:31:16 -0400, Steve Clark wrote: >Hmm... maybe you missed the fact I am running CentOS 6. It appears >8.20 is the latest official release. I'm running 9.5.5 on Centos 6.8 - no problems at all. Go into /etc/yum.repos.d/CentOS-Base.repo, and add the line exclude=postg

Re: [GENERAL] CenOS 5/Postgresql 9.6

2017-03-17 Thread John R Pierce
On 3/17/2017 1:56 PM, Thomas Kellerer wrote: The question remains - does anyone know where I might find packages so I don't have to compile them myself? You can download the binaries (no RPM) from here: https://www.enterprisedb.com/products-services-training/pgbindownload how are those built

Re: [GENERAL] CenOS 5/Postgresql 9.6

2017-03-17 Thread Thomas Kellerer
Steve Crawford schrieb am 17.03.2017 um 20:15: I'm aware of all those dates. Also that 9.6 has been out for six-months, and that RHEL/CentOS 5 are listed among the currently supported versions at https://yum.postgresql.org/. The question remains - does anyone know where I might find packages so

Re: [GENERAL] CenOS 5/Postgresql 9.6

2017-03-17 Thread Steve Crawford
On Fri, Mar 17, 2017 at 11:35 AM, John R Pierce wrote: > On 3/17/2017 11:07 AM, Steve Crawford wrote: > >> Where might I find yum repos PostgreSQL 9.6 on CentOS 5 (i386 & x86_64)? >> >> RHEL/CentOS 5 is still in production with extended support through 2020 >> but seems to be dropped from the 9.6

Re: [GENERAL] CenOS 5/Postgresql 9.6

2017-03-17 Thread John R Pierce
On 3/17/2017 11:07 AM, Steve Crawford wrote: Where might I find yum repos PostgreSQL 9.6 on CentOS 5 (i386 & x86_64)? RHEL/CentOS 5 is still in production with extended support through 2020 but seems to be dropped from the 9.6 PGDG repos. CentOS 5 will be completely dropped in 2-3 weeks, I be

[GENERAL] CenOS 5/Postgresql 9.6

2017-03-17 Thread Steve Crawford
Where might I find yum repos PostgreSQL 9.6 on CentOS 5 (i386 & x86_64)? RHEL/CentOS 5 is still in production with extended support through 2020 but seems to be dropped from the 9.6 PGDG repos. Cheers, Steve

Re: [GENERAL] psql - looking in wrong place for socket

2017-03-17 Thread Adrian Klaver
On 03/17/2017 07:31 AM, Steve Clark wrote: On 03/17/2017 10:14 AM, Adrian Klaver wrote: On 03/17/2017 06:58 AM, Steve Clark wrote: On 03/17/2017 09:49 AM, Adrian Klaver wrote: On 03/17/2017 06:42 AM, Steve Clark wrote: Hi List, I am running postgresql 8.4.20 on CentOS 6. Things have been run

Re: [GENERAL] psql - looking in wrong place for socket

2017-03-17 Thread Steve Clark
On 03/17/2017 10:14 AM, Adrian Klaver wrote: > On 03/17/2017 06:58 AM, Steve Clark wrote: >> On 03/17/2017 09:49 AM, Adrian Klaver wrote: >>> On 03/17/2017 06:42 AM, Steve Clark wrote: Hi List, I am running postgresql 8.4.20 on CentOS 6. Things have been running fine for a long

Re: [GENERAL] psql - looking in wrong place for socket

2017-03-17 Thread Adrian Klaver
On 03/17/2017 06:58 AM, Steve Clark wrote: On 03/17/2017 09:49 AM, Adrian Klaver wrote: On 03/17/2017 06:42 AM, Steve Clark wrote: Hi List, I am running postgresql 8.4.20 on CentOS 6. Things have been running fine for a long time then I rebooted. Postgres came up but when I tried to connect w

Re: [GENERAL] array of bytea;

2017-03-17 Thread Tom Lane
Tom DalPozzo writes: > I tried without success INSERT INTO MYTABLE VALUES ('{'\x0011','\x2233'}'); > What's wrong? You've ignored the rules about how to write element values within an array literal: https://www.postgresql.org/docs/current/static/arrays.html#ARRAYS-IO Personally I tend to write a

Re: [GENERAL] psql - looking in wrong place for socket

2017-03-17 Thread Steve Clark
On 03/17/2017 09:49 AM, Adrian Klaver wrote: > On 03/17/2017 06:42 AM, Steve Clark wrote: >> Hi List, >> >> I am running postgresql 8.4.20 on CentOS 6. Things have been running fine >> for a long time >> then I rebooted. Postgres came up but when I tried to connect with psql on >> the local machi

[GENERAL] array of bytea;

2017-03-17 Thread Tom DalPozzo
Hi, I created a table: CREATE TABLE MYTABLE (DATA BYTEA[]); Now, I'd like to insert some values (a '\x0011' and a '\x2233') but I can't find a right way. I tried without success INSERT INTO MYTABLE VALUES ('{'\x0011','\x2233'}'); What's wrong? Thanks Pupillo

Re: [GENERAL] psql - looking in wrong place for socket

2017-03-17 Thread Adrian Klaver
On 03/17/2017 06:42 AM, Steve Clark wrote: Hi List, I am running postgresql 8.4.20 on CentOS 6. Things have been running fine for a long time then I rebooted. Postgres came up but when I tried to connect with psql on the local machine I got psql: could not connect to server: No such file or d

[GENERAL] psql - looking in wrong place for socket

2017-03-17 Thread Steve Clark
Hi List, I am running postgresql 8.4.20 on CentOS 6. Things have been running fine for a long time then I rebooted. Postgres came up but when I tried to connect with psql on the local machine I got psql: could not connect to server: No such file or directory Is the server running locall

Re: [GENERAL] pg_dump pg_restore hanging in CentOS for large data

2017-03-17 Thread Adrian Klaver
On 03/17/2017 12:27 AM, Sridevi B wrote: Ccing list. Please reply to list also, it puts more eyes on the problem. Hi Adrian, Sorry for delay. Please find my answers inline. Thanks, Sridevi On Thu, Mar 16, 2017 at 2:28 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 03

[GENERAL] Generating JSON-encoded list of object out of joined tables

2017-03-17 Thread Alexander Farber
Good afternoon, what would be please the best way to generate a list of JSON objects out of an SQL join? I am using jQuery dataTables plugin and initially was performing an SQL join and then in my PHP script was fetching results row by row and finally encoded them to JSON and feeded to the plugin