PostgreSQL

08 December 2025 11:31

Hello everyone,

I’m new to PostgreSQL and would like to ask a beginner question.

Is it considered best practice to use a single PostgreSQL cluster to host multiple databases for different applications? From what I understand, all databases in a cluster share the same WAL stream, so I’m unclear how point-in-time recovery could be performed for an individual database within that cluster.

Also, RDBMS can be as fast as their transaction logs, are multiple databases add performance overhead to the single transaction log file compared just to have a single db on a particular cluster?

PostgreSQL

02 December 2025 13:18

I assume they didn't like our response

PostgreSQL

02 December 2025 13:17

Yes.

(My vote for permaban.)

PostgreSQL

02 December 2025 13:11

Did OP delete the question? Or am I just a bit dumb right now? 😅

PostgreSQL

02 December 2025 12:29

Feel free to use it, it might work, it would probably work

PostgreSQL

02 December 2025 12:16

The question is extremely meaningless.

Don't ask questions, write code.

(No, you cannot make architectural blueprints in areas you don't know anything about. Just write the system.)

PostgreSQL

02 December 2025 12:09

For example, consider something like Signal: it's very secure, they keep barely any data (and such data can also be sharded very effectively)

PostgreSQL

02 December 2025 12:01

It highly depends on the architecture.

PostgreSQL

02 December 2025 09:59

does anyone here use PgBouncer with their databases or would you recommend another product ?

PostgreSQL

01 December 2025 12:08

pgBackRest for self hosted large databases (>10TB), you can use barman and other options for smaller.

PostgreSQL

01 December 2025 10:42

Morning everyone!

🚀 FOSDEM PGDay 2026 - CfP is OPEN!
The Call for Proposals for FOSDEM PGDay 2026 is officially open, and we want YOUR talk!
📆 January 30, 2026
📍 Brussels Marriott Hotel Grand Place

Got something cool to share about PostgreSQL? Whether it's about performance, extensions, migrations, HA setups, real-world war stories, or the latest features you've been exploring - we want to hear it!
All experience levels welcome! First-time speaker? Awesome! PostgreSQL veteran? Even better! The community learns from everyone.

Submit your proposal here: https://www.postgresql.eu/events/fosdem2026/callforpapers/

⏰ Deadline: December 15, 2025 at 24:00 CET
🎄 Schedule published by Christmas!

Don't wait - submit early! And please, flood us with proposals so the selection committee has plenty of work to do 😅

PostgreSQL

29 November 2025 19:23

There's several here, but on a Saturday night?? I dunno...

Anyway, what's you issue?

PostgreSQL

27 November 2025 17:31

Yeah I have used pigsty several times but only when there are not pgdg packages available

PostgreSQL

27 November 2025 17:14

Friends does any one has used pigsty ?

PostgreSQL

26 November 2025 16:12

Most appropriate is always Ora2pg. You should have some code in procedures, functions, triggers etc that needs to be converted, not just data transfer.

PostgreSQL

02 December 2025 13:18

Supabase yes or no??

PostgreSQL

02 December 2025 13:18

Yes they did, check the history

PostgreSQL

02 December 2025 13:15

They came, they asked, they deleted and left

PostgreSQL

02 December 2025 12:30

I wouldn't use it because i don't like SaaS because of the added latency + complexity (postgresql is fairly easy and self contained to use), but some peoople like the trade off of paying money to not have to care about that

PostgreSQL

02 December 2025 12:22

A good relational database intro book would give you some general info.

PostgreSQL

02 December 2025 12:15

If you can afford it, sure

PostgreSQL

02 December 2025 12:04

The best way to keep data safe is to have as least of it as possible, or as Germans would say, "datensparsamkeit"

PostgreSQL

02 December 2025 10:21

PgBouncer is great if you need it. Which problem are you trying to fix?

PostgreSQL

02 December 2025 07:54

We’ve been using pgbackrest for years with 1500+ clusters and recently took advantage of its native S3 integration with an on premises object store solution : all good

PostgreSQL

01 December 2025 11:06

How you guys backup postgres ?

PostgreSQL

30 November 2025 13:16

Do we have any tools like sct for informix to postgresql schema conversion ? I have tried sqlines online but it didn't help.

PostgreSQL

29 November 2025 18:14

Hello all ! I need psql / patroni expert to debug a restoration / replication issu :)

PostgreSQL

27 November 2025 17:15

How this tool. Is to manage postgresql on offline centre or on intranet

PostgreSQL

26 November 2025 18:42

Hacking Postgres online – join! https://www.youtube.com/watch?v=wLPDt7CufEU

PostgreSQL

26 November 2025 15:45

Plz suggest me most appropriate strategy