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

26 November 2025 15:45

Now should I only go with ora2pg or should o use golden gate cdc services

PostgreSQL

26 November 2025 09:00

That vastly depends on your data structure, your downtime requirements and your budget...

PostgreSQL

23 November 2025 16:47

No, most software that could handle this is incomparably better than pgadmin. So no software like it.

PostgreSQL

23 November 2025 15:55

But I tend to use an union all or create additional query windows

PostgreSQL

23 November 2025 15:51

Do you recommend any software like pgadmin to handle this type of queries like 2 and 3 results at a time?

PostgreSQL

23 November 2025 15:45

Because the cursor is only one, and the data in the cursor at the end of multiple query is the data from the last query

PostgreSQL

20 November 2025 11:47

The first PostgreSQL Edinburgh meetup is taking place on December 11th, and we are super happy to have Chris Ellis as our first guest speaker! 👉 https://luma.com/b9kv5fds

PostgreSQL

17 November 2025 00:59

So i still have to track when a user avandoned the group

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

PostgreSQL

26 November 2025 15:44

I have oracle golden gate license . I can take downtime for two days

PostgreSQL

26 November 2025 03:13

Hello geeks , I have to migrate oracle golden gate database to postgresql . The database size is nearly 1tb . The existing database is running on windows 11 and now I want to move it to redhat10 postgresql . Plz tell me which tool I should use . Is ora2pg sufficient or should I use golden gate services for cdc Change and low downtime .

PostgreSQL

23 November 2025 15:57

You could also try DBeaver which I think it supports multiple resulsets

PostgreSQL

23 November 2025 15:53

Pgadmin4 is working for more than one year in that functionality https://github.com/pgadmin-org/pgadmin4/issues/6776

PostgreSQL

23 November 2025 15:48

Is there any way to get the both queries result?

PostgreSQL

23 November 2025 15:43

I have one doubt
I am new for Postgres, I recently installed pg admin 4 in my windows machine, when I try to query the 2 queries in the same session i am getting one result instead of 2 until unless I use union both the queries. Is this expected?
why these are not showing 2 results at a time , please help me how to get the 2 outputs.

PostgreSQL

17 November 2025 00:59

WHen a user abandons the group, you set the upper bound of the range

PostgreSQL

17 November 2025 00:34

SELECT sent_at, user_id, message FROM messages
JOIN userjoin ON userjoin.chat_id = messages.chat_id AND message.sent_at <@ userjoin.joined_at_range
WHERE userjoin.user_id = [your user id]