Re: Ideas about presenting data coming from sensors

On 2/27/25 09:05, Achilleas Mantzios - cloud wrote: On 2/26/25 18:29, Adrian Klaver wrote: On 2/26/25 01:27, Achilleas Mantzios - cloud wrote: Hi Again Up to this day we have set the data acquisition system running for just one ship and writing the code to display the data. For less than

Re: Ideas about presenting data coming from sensors

On 2/26/25 18:29, Adrian Klaver wrote: On 2/26/25 01:27, Achilleas Mantzios - cloud wrote: Hi Again Up to this day we have set the data acquisition system running for just one ship and writing the code to display the data. For less than 20 days we have 6M rows. I gave a shot to timescale,

Re: How to return seto records from seof record function?

On Tue, Feb 25, 2025 at 8:47 AM Laurenz Albe wrote: > > I don't think there is a way to get a generic "record" as result. > And even if you could, you would still have to specify a column list > when you call autonomous(). > > Attempts to write functions with polymorphic return type are usually >

Re: Ideas about presenting data coming from sensors

On 2/26/25 01:27, Achilleas Mantzios - cloud wrote: Hi Again Up to this day we have set the data acquisition system running for just one ship and writing the code to display the data. For less than 20 days we have 6M rows. I gave a shot to timescale, installed locally as an extension, it see

Re: Corruption of few tables

On 2/25/25 23:21, sivapostg...@yahoo.com wrote: Since we rectified the issue in ver 11, I couldn't get more details. What issue is this?: ls_pack_version <> ls_db_version or the SSL issue you show below? Now we are getting the same [ or similar ] issue in PostgreSQL 15.7 (Ubuntu 15.7-1.p

Re: Corruption of few tables

On 2/25/25 22:33, sivapostg...@yahoo.com wrote: Thanks // Following is the PB code to retrieve data ls_pack_version = fn_get_product_version() ls_pack_build   = fn_get_product_build() Select releasenumber, buildnumber Into   :ls_db_version, :ls_db_build From   public.co_version Where  modulena

Re: Corruption of few tables

On Wed, Feb 26, 2025 at 9:06 AM Greg Sabino Mullane wrote: > On Wed, Feb 26, 2025 at 2:21 AM sivapostg...@yahoo.com < > sivapostg...@yahoo.com> wrote: > >> issue in PostgreSQL 15.7 >> > > Still missing a ton of bug fixes - Postgres 15 is on version 15.12. Try to > get that upgraded. > And it tak

Re: Corruption of few tables

On Wed, Feb 26, 2025 at 2:21 AM sivapostg...@yahoo.com < sivapostg...@yahoo.com> wrote: > issue in PostgreSQL 15.7 > Still missing a ton of bug fixes - Postgres 15 is on version 15.12. Try to get that upgraded. > We got the following error > ERROR: SSL error: bad length > SSL SYSCALL error: No

PG16 and replication, ensure a clean switchover after a stop of the primary server

Hi, First, I have put all details of this post in this gist https://gist.github.com/flaf/ccedf78d0290d231e79581077fd92dbc (with a little video/demo to see with your eyes ;)). I have 2 PostgreSQL servers version 16.8 on RedHat 8.10, with physical streaming async replication: * postgres-1 the pri

Re: Ideas about presenting data coming from sensors

Hi Again Up to this day we have set the data acquisition system running for just one ship and writing the code to display the data. For less than 20 days we have 6M rows. I gave a shot to timescale, installed locally as an extension, it seems much prettier than having to do all the partition