Re: Computed index on transformation of jsonb key set

2019-04-27 Thread Andrew Gierth
> "Steven" == Steven Schlansker writes: Steven> I figured I'd end up with significantly better storage and Steven> performance characteristics if I first compute a uuid[] value Steven> and build the GIN over that, and use the array operator class Steven> instead. Additionally, this elimin

Missing pg_config on SuSE SLES 12 for PostgreSQL 10

2019-04-27 Thread Matthias Apitz
Hello, I'm investigating on a SuSE Linux SLES 12 server if we could add support for PostgreSQL 10 to our Library Management System (currently running on top of Oracle 12 and Sybase 15.7) using all kind of languages and API one could imagine. I've up and running the server and figured out how to

Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

2019-04-27 Thread Laurenz Albe
Matthias Apitz wrote: > I'm investigating on a SuSE Linux SLES 12 server if we could add support > for PostgreSQL 10 to our Library Management System (currently running on top > of Oracle 12 and Sybase 15.7) using all kind of languages and API one could > imagine. > > I've up and running the serv

Re: TCP Resets when closing connection opened via SSL

2019-04-27 Thread Peter J. Holzer
On 2019-04-26 18:36:12 +0200, Jānis Pūris wrote: > Thanks for the insight, Tom. > > > It's fairly obvious from the postmaster log that the client side > is not bothering to close the transaction it started > > > Thats what I was also thinking, but I've managed to reproduce it with > aut

Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

2019-04-27 Thread Matthias Apitz
On Sat, 27 Apr 2019 12:41:07 +0200, Laurenz Albe wrote: > Matthias Apitz wrote: >> I'm investigating on a SuSE Linux SLES 12 server if we could add support >> for PostgreSQL 10 to our Library Management System (currently >> running on top >> of Oracle 12 and Sybase 15.7) using all kind of languages

Re: TCP Resets when closing connection opened via SSL

2019-04-27 Thread Jānis Pūris
Thank you, Peter. It makes more sense now, and I'm so glad someone else is able to reproduce this. To clarify on why I consider this a problem - It is not just the alerts on monitoring system. The alerts themselves can be tuned / thresholds increased etc. The real issue (could argue this is non

Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

2019-04-27 Thread Matthias Apitz
El día sábado, abril 27, 2019 a las 11:00:53a. m. +, Matthias Apitz escribió: > >> To get Perl's DBD::Pg compiled now I really do need the pg_config tool, > >> but I can't figure out how to get it. I see the following RPM (the ones > >> with an 'i' or 'i+' are installed): > >> > > [...] > >>

Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

2019-04-27 Thread Adrian Klaver
On 4/27/19 12:58 AM, Matthias Apitz wrote: Hello, I'm investigating on a SuSE Linux SLES 12 server if we could add support for PostgreSQL 10 to our Library Management System (currently running on top of Oracle 12 and Sybase 15.7) using all kind of languages and API one could imagine. I've up a

Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

2019-04-27 Thread Matthias Apitz
El día sábado, abril 27, 2019 a las 06:22:00a. m. -0700, Adrian Klaver escribió: > On 4/27/19 12:58 AM, Matthias Apitz wrote: > > Hello, > > > > I'm investigating on a SuSE Linux SLES 12 server if we could add support > > for PostgreSQL 10 to our Library Management System (currently running on to

Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

2019-04-27 Thread Andrew Gierth
> "Matthias" == Matthias Apitz writes: Matthias> There is no cmd 'pg_config'. Can I compile this from source? Some distros separate out a 'libpq' package, and have a 'libpq-devel' package with pg_config in it. Did you look for that? -- Andrew (irc:RhodiumToad)

Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

2019-04-27 Thread Adrian Klaver
On 4/27/19 6:33 AM, Matthias Apitz wrote: El día sábado, abril 27, 2019 a las 06:22:00a. m. -0700, Adrian Klaver escribió: On 4/27/19 12:58 AM, Matthias Apitz wrote: Hello, I'm investigating on a SuSE Linux SLES 12 server if we could add support for PostgreSQL 10 to our Library Management Sys

Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

2019-04-27 Thread Matthias Apitz
El día sábado, abril 27, 2019 a las 02:39:54p. m. +0100, Andrew Gierth escribió: > > "Matthias" == Matthias Apitz writes: > > Matthias> There is no cmd 'pg_config'. Can I compile this from source? > > Some distros separate out a 'libpq' package, and have a 'libpq-devel' > package with pg_c

Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

2019-04-27 Thread Christoph Moench-Tegeder
## Matthias Apitz (g...@unixarea.de): > To get Perl's DBD::Pg compiled now I really do need the pg_config tool, > but I can't figure out how to get it. I see the following RPM (the ones > with an 'i' or 'i+' are installed): Um. Which postgresql10-* packages are that? SLES12SP4 has "postgresql10"