Is there a simple, non-complex pgpool configuration for 1 write-server that has multiple read-only replicas? My python app should hit the 1 pgpool server that splits the writes over to 1, while spreading reads across the read-replicants. Heimdall is pricy. pgbounce/etc appear focused on the pooling/performance, while pgpool is talked about being useful for splitting reads vs writes. I'm trying to avoid putting the logic into the client side (django db router) or any packages that appear to do that. submitted by /u/joej [visit reddit] [comments ..read more

I have three date columns, and I want to return which of the three columns contain the earliest date in them. I can find the earliest date easily with least(), but how can I show in my output what column it came from as well? Quick example table below   User ID User Added Date User Order Date User Acquired Date 123 01-01-2021 02-02-2022 03-03-2023 456 10-10-1999 08-08-2001 07-07-1997   I would like to return from this the following User ID Earliest Date Date Value 123 01-01-2021 User Added Date 456 07-07-1997 User Acquired Date submitted by /u/holymacaroniba ..read more

submitted by /u/Logical_Skill_ [visit reddit] [comments ..read more

submitted by /u/vladmihalceacom [visit reddit] [comments ..read more

Curt Kolovson kicked off the second day at the Postgres conference in Silicon Valley by sharing the story of his contribution to the most hated feature of Postgres and thoughts/progress on the temporal data support in the database. submitted by /u/dmagda7817 [visit reddit] [comments ..read more

Hi guys, I just released my first open source project, which is a Go library which uses generic functions to quickly create a REST API offering CRUD functionality on a Postgres database. The library is: https://github.com/loveyourstack/lys And there is a sample application based on the old MS Northwind database which shows how the library is used, it is here: https://github.com/loveyourstack/northwind If you use Go as well as Postgres, you may find it useful. As my first open source project, any advice and contributions are most welcome! Thanks submitted by /u/LoveYourStack [visit reddit] [c ..read more

Hello, my query looks like that: ... WHERE user_id = 12 AND deleted_by IS NOT NULL Should my index look like that ? CREATE INDEX wst_user_id ON workers_send_times (user_id) WHERE deleted_by IS NOT NULL or this CREATE INDEX wst_user_id ON workers_send_times (user_id, deleted_by) WHERE deleted_by IS NOT NULL ​ submitted by /u/Far-Mathematician122 [visit reddit] [comments ..read more

Wish you were here! submitted by /u/linuxhiker [visit reddit] [comments ..read more

Hello, We have the requirement to move/replicate data from relational data model i.e. from postgresql database(aurora postgres 15.4) to S3 bucket in csv format in certain frequency(say hourly once or may be once in 6hrs). The volume of transaction data is ~100 million+ each day for each table. And total number of tables currently we have at hand for replication is ~10 tables (it may increase in future). And also there may be requirement to put some inter table dependencies in tables export job because of the dependency between the stored data. For moving data out of S3, we see there exists ex ..read more

A new release introduces improvements and bug fixes. https://github.com/GreenmaskIO/greenmask Changes: Fixed panic caused in RandomString transformer Fixed wrong table size calculation. Now the table size includes TOAST table size Added custom transformer interaction API defaults if not set Changed docker workdir to greenmask home Removed bucket name from object path prefix If you are not familiar yet with Greenmask - it is a Database anonymization tool that brings wide anonymization functionalities and techniques. Check out the Playground page to get started submitted by /u/anyweny [visit ..read more