PostgreSQL

17 March 2026 08:27

I think this might give you a good start -> https://www.postgresql.org/docs/current/mvcc-intro.html

PostgreSQL

16 March 2026 08:43

https://www.percona.com/blog/how-to-convert-postgresql-streaming-replication-to-logical-replication/

PostgreSQL

16 March 2026 08:34

I would only need to stop the master in order to change wal level to logical no? I couldn't find anything online about this. Only the options of dump-restore and copy

PostgreSQL

16 March 2026 07:19

Question regard logical replication in version 13 - how do I make the initial copy for large DBs? Is it possible to make the replication from a pg-basebackup/a snapshot of the master machine?

PostgreSQL

04 March 2026 05:37

i use standard c debugger in vscode

PostgreSQL

04 March 2026 01:34

Hello Everyone,
What is the best free tool for debugging PostgreSQL functions and procedures?

PostgreSQL

03 March 2026 23:19

datagrip shows map as well

PostgreSQL

03 March 2026 22:25

psql is enough for any dba use case and pgadmin runs unnecessary queries for monitoring which is harmful at scale. Overall gui is trash, connection is counter intuitive for newbies. There are better options for gui addicts like dBeaver, datagrip etc

PostgreSQL

02 March 2026 12:11

Dump is not a backup and stay away from pgAdmin.

PostgreSQL

02 March 2026 11:26

Hello guys, I'm from India-Gujarat, I'm a beginner and need help. Currently, I'm taking a full database backup using the pgAdmin GUI tool in Tar format with Encoding UTF-8 without changing anything. It generates a file almost half the size of the database, and the file extension is .sql. I'm also restoring that backup through the pgAdmin GUI tool, which I guess requires pg_dump and pg_restore. So, am I doing it the right way or not? I think it will take more time and space because the database size is almost 400 GB. Is there any other method for taking backup and restoring then please guide me

PostgreSQL

28 February 2026 14:00

/channel/postgresql_lib

PostgreSQL

28 February 2026 12:19

Any training video available?

PostgreSQL

27 February 2026 14:34

On High-performance SQL

https://stackoverflow.blog/2023/09/28/how-to-write-high-performance-sql-for-your-postgres-database/?_hsenc=p2ANqtz-9nGH4mITy2YCSbO5iO1BZu8oSHs4jMspWDYftXFtfLKSSO1dHhkRS4aPuSvwiqoDpLw1GfduMBl_r0Z0clqqUex2KdHxSAiK0N2CH5QXkP_Fg5ecE&_hsmi=277235435&utm_content=277235953&utm_medium=email&utm_source=hs_email

PostgreSQL

27 February 2026 14:20

Hmmm, didn't we have some video links in a pinned message back in the days? List from @J_Arun_Mani or @CaptainKirkFan IIRC?

PostgreSQL

25 February 2026 11:27

We don't mess around in this channel 😎

PostgreSQL

17 March 2026 07:46

Please explain what is (MVCC) in posgre

PostgreSQL

16 March 2026 08:42

It's easier to convert physical replica to logical using pg_replication_slot_advance (before pg17) and skip initial sync.

PostgreSQL

16 March 2026 07:43

I mean technically that might work but only if you can pause the original DB until you are finished and can start the subscription.

Probably the way to go if you are CPU-limited on the replica is to remove indexes and then re-add them later. Or add entirely new ones. The indexes can differ, it's just the definition of the columns you copy that has to be at least compatible, IIRC.

PostgreSQL

12 March 2026 15:31

hey, anyone here is a Russian? could anyone from Russia dm me? I received a VN in Russian, which I don't understand

PostgreSQL

04 March 2026 02:19

PgAdmin will let you set breakpoints in the code and trace through them. I would NOT do this on a production server.

We created a routine that lets us turn ON and OFF NOTIFY output.
And we put the LOGGING code in the procedures. When it's off, it simply returns.
When it's on, we get the output messages to the console (and optionally can be logged to the postgresql.log).

But good luck. Nothing FREE that I know of has implemented the debugger piece...

PostgreSQL

03 March 2026 23:20

I never tried that, thanks for mentioning it

PostgreSQL

03 March 2026 22:27

Unless you work with GIS data. I like how pgadmin shows me a map of the items in my database, that is how I found errors before even trying to display the data on a map myself.

PostgreSQL

03 March 2026 19:35

I understand the first one but i don't understand the latter

PostgreSQL

02 March 2026 11:47

* If the extension is .sql, you're _not_ doing a tar format dump. But a single, uncompressed SQL file...
* Many ppl in this channel (including myself) will tell you that a dump is not a backup. Read the documentation on the subject (https://www.postgresql.org/docs/current/backup.html) and compare the pros & cons.
* You will _probably_ end up using pgbackrest, BARMAN or a similar kind of solution, with a WAL archive.

PostgreSQL

28 February 2026 14:03

Take the other link. That first one was just my browesr's URL...

PostgreSQL

28 February 2026 13:23

Check out https://web.telegram.org/a/#-1001764686735

PostgreSQL

27 February 2026 15:52

I will make do with low-performamce SQL. No sense in risking burning out the database engine... it already catches sometimes when I try to replicate boxes!

PostgreSQL

27 February 2026 14:22

May be from Kirk, I don't remember any such list 🤔

PostgreSQL

27 February 2026 14:16

Could you please help me , anyone has postgresql videos

PostgreSQL

25 February 2026 08:08

Banned, deleted and reported