Re: Failed to compile libpq

2020-10-14 Thread Tom Lane
Igor Korot writes: > On Thu, Oct 15, 2020 at 12:01 AM Tom Lane wrote: >> Kinda looks like you're using some non-GNU make. > Correct. > It is from Solaris Studio compiler. > What should I do? Try "gmake". If it's not already on the system, you'll need to install it. re

Re: Failed to compile libpq

2020-10-14 Thread Igor Korot
Tom et al, On Thu, Oct 15, 2020 at 12:01 AM Tom Lane wrote: > > Igor Korot writes: > > Configure succeeded, but running "make" failed with > > > [quote] > > make: Fatal error in reader ../../../src/Makefile.global, line 45: > > Unexpected end of line seen > > [/quote] > > Kinda looks like you're

Re: Failed to compile libpq

2020-10-14 Thread Tom Lane
Igor Korot writes: > Configure succeeded, but running "make" failed with > [quote] > make: Fatal error in reader ../../../src/Makefile.global, line 45: > Unexpected end of line seen > [/quote] Kinda looks like you're using some non-GNU make. regards, tom lane

Failed to compile libpq

2020-10-14 Thread Igor Korot
Hi, ALL, I just tried to compile libpq on latest Solaris x86 (12.4) with Solaris compiler (Sollaris Studio) version 12.6. Configure succeeded, but running "make" failed with [quote] make: Fatal error in reader ../../../src/Makefile.global, line 45: Unexpected end of line seen [/quote] Is there a

Re: pgbouncer installation example (Step by step)

2020-10-14 Thread Michael Lewis
On Wed, Oct 14, 2020 at 11:08 AM Atul Kumar wrote: > Hi Team, > > Please share a clean example of installing, https://www.pgbouncer.org/install.html > configuring https://www.pgbouncer.org/config.html > and testing pgBouncer. > https://www.pgbouncer.org/usage.html What else do you want to

Re: pgbouncer installation example (Step by step)

2020-10-14 Thread David G. Johnston
On Wed, Oct 14, 2020 at 10:08 AM Atul Kumar wrote: > Please share a clean example of installing, configuring and testing > pgBouncer. > > Your official links are not organized so I need an example of > PgBouncer with organized steps. > As I said on your exact same posting to the -admin list; not

pgbouncer installation example (Step by step)

2020-10-14 Thread Atul Kumar
Hi Team, Please share a clean example of installing, configuring and testing pgBouncer. Your official links are not organized so I need an example of PgBouncer with organized steps. Regards, Atul

Re: rum index supported on pg13?

2020-10-14 Thread Devrim Gündüz
Hi Teodor, On Wed, 2020-10-14 at 18:49 +0300, Teodor Sigaev wrote: > Thank you, fixed and published. Can you please release a new tarball? We need that to build the RPM packages. I'm still seeing 1.3.6 as the latest version. Thanks! Regards, -- Devrim Gündüz Open Source Solution Architect, Re

Re: rum index supported on pg13?

2020-10-14 Thread Teodor Sigaev
Thank you, fixed and published. On 09.10.2020 05:29, John the Scott wrote: will rum index from postgrespro be supported in pg13? numerous errors occur when compiling rum in pg13 and no replies from github. the differences from pg12 to pg13 seem to be significant https://github.com/postgr

Re: Parameter value from (mb/gb) to bytes

2020-10-14 Thread Magnus Hagander
On Wed, Oct 14, 2020 at 5:23 PM Tom Lane wrote: > Magnus Hagander writes: > > On Wed, Oct 14, 2020 at 5:10 PM Tom Lane wrote: > >> It's fairly annoying that this doesn't work: > >> regression=# select pg_size_bytes(setting||' '||unit) from pg_settings > >> where name = 'shared_buffers'; > > > A

Re: Parameter value from (mb/gb) to bytes

2020-10-14 Thread Raul Kaubi
Hi Thanks for all the replies. So at first, I did this: select (pg_size_bytes(setting) * (select setting from pg_settings where name = 'block_size')::int) as shared_buffers from pg_settings where name = 'shared_buffers'; But as I understood, that the preferred way would be this, correct..? (at

Re: What's your experience with using Postgres in IoT-contexts?

2020-10-14 Thread Jonathan Strong
On Wed, Oct 14, 2020 at 8:49 AM Peter J. Holzer wrote: > On 2020-10-13 06:55:52 +0200, chlor wrote: > > > I want to have long term storage and access to individual telegrams > > > > An IOT is not designed for that. It is used for control or delivery of > > data to a server. > > That's a rather do

Re: Parameter value from (mb/gb) to bytes

2020-10-14 Thread Tom Lane
Magnus Hagander writes: > On Wed, Oct 14, 2020 at 5:10 PM Tom Lane wrote: >> It's fairly annoying that this doesn't work: >> regression=# select pg_size_bytes(setting||' '||unit) from pg_settings >> where name = 'shared_buffers'; > Actually thinking though, surely *this* particular case can be s

Re: Parameter value from (mb/gb) to bytes

2020-10-14 Thread Magnus Hagander
On Wed, Oct 14, 2020 at 5:10 PM Tom Lane wrote: > Magnus Hagander writes: > > On Wed, Oct 14, 2020 at 3:57 PM Thomas Kellerer wrote: > >> select pg_size_bytes(setting) * 8192 > >> from pg_settings > >> where name = 'shared_buffers'; > > > Actually, it doesn't have to be in 8k pages, that depend

Re: Parameter value from (mb/gb) to bytes

2020-10-14 Thread Christoph Moench-Tegeder
## Magnus Hagander (mag...@hagander.net): > Actually, it doesn't have to be in 8k pages, that depends on the build > options. So if you want to be perfectly correct, you should probably > multiply with current_setting('block_size') instead of a hardcoded 8192 :) More self-contained: select pg_s

PostGIS missing from EDB Windows installer for PG13?

2020-10-14 Thread Anthony DeBarros
Good day, I just tried a fresh install of PostgreSQL 13 on Windows using the EDB installer, and I see that StackBuilder does not include an option to install PostGIS. Anyone have insight on whether that's a permanent change or not? Thanks, Anthony DeBarros Author, "Practical SQL" from No Starch

Re: Parameter value from (mb/gb) to bytes

2020-10-14 Thread Pavel Stehule
st 14. 10. 2020 v 17:10 odesílatel Tom Lane napsal: > Magnus Hagander writes: > > On Wed, Oct 14, 2020 at 3:57 PM Thomas Kellerer wrote: > >> select pg_size_bytes(setting) * 8192 > >> from pg_settings > >> where name = 'shared_buffers'; > > > Actually, it doesn't have to be in 8k pages, that de

Re: Parameter value from (mb/gb) to bytes

2020-10-14 Thread Tom Lane
Magnus Hagander writes: > On Wed, Oct 14, 2020 at 3:57 PM Thomas Kellerer wrote: >> select pg_size_bytes(setting) * 8192 >> from pg_settings >> where name = 'shared_buffers'; > Actually, it doesn't have to be in 8k pages, that depends on the build > options. So if you want to be perfectly correc

Re: Parameter value from (mb/gb) to bytes

2020-10-14 Thread Magnus Hagander
On Wed, Oct 14, 2020 at 3:57 PM Thomas Kellerer wrote: > Thomas Kellerer schrieb am 14.10.2020 um 15:55: > > Raul Kaubi schrieb am 14.10.2020 um 12:22: > >> Is there a simple way to dynamically get for example parameter > >> „shared buffers“ value (megabytes or gigabytes) to bytes, for > >> monit

bug in PG13?

2020-10-14 Thread Andreas Kretschmer
Hi all, it seems to me a bug. i have a partitioned table: test=*# select version(); version -  PostgreSQL 13.0 (Ubuntu 13.0-1.pgdg18.04+1) on x86_64-pc-linux-gnu, com

Re: Parameter value from (mb/gb) to bytes

2020-10-14 Thread Thomas Kellerer
Thomas Kellerer schrieb am 14.10.2020 um 15:55: > Raul Kaubi schrieb am 14.10.2020 um 12:22: >> Is there a simple way to dynamically get for example parameter >> „shared buffers“ value (megabytes or gigabytes) to bytes, for >> monitoring perspective..?> >>   >> >> At the moment, this gives me value

Re: Parameter value from (mb/gb) to bytes

2020-10-14 Thread Thomas Kellerer
Raul Kaubi schrieb am 14.10.2020 um 12:22: > Is there a simple way to dynamically get for example parameter > „shared buffers“ value (megabytes or gigabytes) to bytes, for > monitoring perspective..?> >   > > At the moment, this gives me value in GB. > > # psql -U postgres -Atc "show shared_buffers

Parameter value from (mb/gb) to bytes

2020-10-14 Thread Raul Kaubi
Hi Is there a simple way to dynamically get for example parameter "shared buffers" value (megabytes or gigabytes) to bytes, for monitoring perspective..? At the moment, this gives me value in GB. # psql -U postgres -Atc "show shared_buffers;" 1GB This value may as well be in MB. So I am lookin

Re: What's your experience with using Postgres in IoT-contexts?

2020-10-14 Thread Paul Förster
Hi Peter, > On 14. Oct, 2020, at 14:49, Peter J. Holzer wrote: > > "IOT" means "Internet of things". IOT also means "index organized table"... So much for using abbreviations. :-) Cheers, Paul

Re: What's your experience with using Postgres in IoT-contexts?

2020-10-14 Thread Peter J. Holzer
On 2020-10-13 06:55:52 +0200, chlor wrote: > > I want to have long term storage and access to individual telegrams > > An IOT is not designed for that. It is used for control or delivery of > data to a server. That's a rather dogmatic and narrow-minded point of view. "IOT" means "Internet of thin