On Wednesday, June 18, 2025, sivapostg...@yahoo.com
wrote:
>
>
> How to change the setting(s), if any, to retrieve the current date and
> time in IST?
>
https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-TIMEZONES
Not totally sure if that will or won’t impact how pgAdmin be
Hello,May be a very basic question. We all here are new to Linux / PostgreSQL
Ubuntu Server 22.04PostgreSQL 15PgAdmin4 6.16
When I run the following query in pg_admin
Select today_now From (Select localtimestamp(0) as today_now) a;
I get UTC time and not the IST time, which I expect.
How to chan
Not sure if it makes a big difference to the answer, but MySQL was a
typo - the edge db on the Rpi is Sqlite3.
On Thu, Jun 19, 2025 at 5:00 PM Laurenz Albe wrote:
>
> On Thu, 2025-06-19 at 16:50 +1200, Al Grant wrote:
> > I want to create a web based dashboard for all the currently detected
> > s
On Thu, 2025-06-19 at 16:50 +1200, Al Grant wrote:
> I want to create a web based dashboard for all the currently detected
> signals, where the dashboard contains a graph of the daily beep rate
> for each channel (max 100 channels) over user selectable periods from
> 1 week to 1 year - that query d
Introduction:
I have a question about the design of a project as it relates to
databases, and the scale-ability of the design. The project is
volunteer, so there is no commercial interest.
But first a bit of background:
Background:
I have programmed a rasp pi to record radio beeps from wildlife
Hi Team,
I am planning to implement a PostgreSQL High Availability (HA) and Load
Balancing setup and would greatly appreciate your feedback on the
architecture we've designed (see attached diagram).
[image: image.png]
*Overview of the Setup:*
-
Two PostgreSQL nodes (VM1 and VM2) configure
Around 100 DBs, ranging from 1TB to 50TB.
Initial testing showed that it takes 1.5h to dump the DB and 3h to restore
it for a DB of around 3TB.
Just recreating the indexes takes around 30 minutes on the same DBs.
I understand that pg_dump/pg_restore is the safe route but it's too slow
for me so I
