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
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
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
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
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
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
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
