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

PostgreSQL

25 February 2026 07:42

I would immediately invest that 10.8k and keep looping. It is like printing your own money for free.

PostgreSQL

23 February 2026 12:57

yes, replica is active and slot is active true, same vlan theres no firewall or something, actually theres 2 replicas one of running well, update xmin but one of is stuck keeps same xmin , and I facing with this problem on another clusters too

PostgreSQL

23 February 2026 12:51

but if theres no activity why it keeps xmin, aint is a bug

PostgreSQL

23 February 2026 12:49

what you mean actual subscriber, its physical active rep slot, without any activity

PostgreSQL

23 February 2026 12:07

thank you, I need set to off this config right

PostgreSQL

23 February 2026 11:57

I think postgresql has a bug for physical replication slots, sometimes replication slot keeps xmin that inhibits autovacuum clean dead tuples in lider even theres no transactions in replicas

PostgreSQL

22 February 2026 14:17

How would you implement polymorphic datatype with Postgres? Would you just use JSONB or Class Table Inheritance or just nullable fields?

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

25 February 2026 07:54

Where did the original post go?

PostgreSQL

23 February 2026 13:02

Maybe there is an update that isn't applying on the replica or it hasn't done a checkpoint etc.?

PostgreSQL

23 February 2026 12:52

And the question re the subscriber meant: did you check that there's really a replica connected? Sometimes a firewall suddenly appears out of nowhere, you know...

PostgreSQL

23 February 2026 12:51

Then the setting doesn't apply anyway.

PostgreSQL

23 February 2026 12:11

"off" may disturb queries on the replicas. Anyway, if your _slot_ is blocking VACUUM, did you check there's an actual subscriber on that slot?

PostgreSQL

23 February 2026 11:59

Physical replication slots don't keep xmin (only actual replication connections with hot_standby_feedback=on do).

PostgreSQL

22 February 2026 15:29

All feasible IMHO, although you'll not enjoy the inheritance approach.

PostgreSQL

21 February 2026 06:21

Lucky he didn't run into the problems with 18.2. 😅 We had lists of journals disappearing because titles and descriptions were subject to a substring clause to limit length printed and the values contained non-ASCII characters, and I think some emails not sent on similar grounds. Had to install a snapshot version with it fixed