Oops, one correction - instead of
systemctl initdb postgresql-9.6
please use
/usr/pgsql-9.6/bin/postgresql96-setup initdb
as explained at https://wiki.postgresql.org/wiki/YUM_Installation
Regards
Alex
Hi Steve,
On Fri, Aug 18, 2017 at 7:50 PM, Steve Clark
wrote:
>
> I loaded 9.5 on CentOS 7 but by default every thing wants to use the
> default
> 9.2 version that comes with CentOS 7.
>
> Is there a simple way to fix this so the 9.5 version of tools and
> libraries are used.
>
>
to use PostgreS
Sorry, as a final follow up here, another option (should anyone run into
this and want to keep the intarray extension) is to create the index using
the gin__int_ops operator:
CREATE INDEX ON sets USING GIN(obj_id gin__int_ops);
On Sun, Aug 20, 2017 at 4:22 PM, Wells Oliver
wrote:
> YES!
>
> \dx
YES!
\dx yields intarray was installed (back in the 9.1 days, maybe) and that
was clobbering the @> operator.
Looking into the implications of removing intarray now that we're at 9.6,
seems harmless, but will do my due diligence.
Thanks Jeff.
On Sun, Aug 20, 2017 at 3:15 PM, Jeff Janes wrote
marcelo writes:
> The system I'm building needs to connect some QNX 4.x machines to the
> Postgres' server (by the way, a Linux machine).
>
> Of course, it will be done through a porting of the libpq library.
>
> I was reading the possible parameters for the function mentioned in
> the subject an
On Sun, Aug 20, 2017 at 1:28 PM, Wells Oliver
wrote:
>
> Why is this happening and what can I do to get my GIN indexes working?
> Thanks!
>
>
What extensions do you have installed in each database? I bet one of them
(like intarray) redefines @> for one of your databases.
Try fully qualifying th
The system I'm building needs to connect some QNX 4.x machines to the
Postgres' server (by the way, a Linux machine).
Of course, it will be done through a porting of the libpq library.
I was reading the possible parameters for the function mentioned in the
subject and none refers to the schema
Hey guys, I hope you can help. I am trying to use a GIN Index on an array
column and, weirdly, on the exact same server (9.6.3) it uses the index on
one database, and not on the other. Here's the test query I am using:
CREATE TEMPORARY TABLE objs (obj_id integer PRIMARY KEY);
CREATE TEMPORARY TABL
On Sun, Aug 20, 2017 at 7:19 AM, Enis Inan wrote:
>
> Hello,
>
> Is there a way I can access the ".po" files containing the English -> Foreign
> language translations of postgres' log messages? I only need the translations
> from English to Japanese for a project I'm working on.
>
> Thank you!
>
