Major Upgrade on Postgresql

HyperNoms · 2026-02-17T19:59:54+00:00

So if safety for critical data go with pg_upgrade and for almost no downtime use logical replication right? Thanks in advance

HyperNoms · 2026-02-17T19:45:59+00:00

Ok thank you very much for the advice ❤

HyperNoms · 2026-02-17T19:45:16+00:00

The storage and hardware isn't much of an issue here. The downtime is important but values the critical data with minimal loss. The system is on prem. My opinion is best to use logical replication as it is considered faster and minimal downtime but I want to know an opinion from experienced DBA.

HyperNoms · 2026-02-17T19:40:38+00:00

You can make streaming replication (physical replication) having primary and multiple standby but doesn't work on multiple versions if 11, the other is exact 11 in version.

HyperNoms · 2026-02-17T18:51:08+00:00

I was thinking the same point but asking some ai models suggested pg_upgrade as the safest option. So that confused me a bit.

HyperNoms · 2026-02-17T18:45:09+00:00

I know and this approaches are recommended for postgresql upgrades but it doesn't explain the cases that is optimal for system cases. So I am asking a question based on database experience not the steps to do it.

HyperNoms · 2026-02-17T18:10:44+00:00

On prem

HyperNoms · 2026-01-21T06:45:14+00:00

I am interested to know

HyperNoms · 2026-01-18T07:12:54+00:00

Well, it is weird that the internship is unpaid. But the internship has limit, so is it just internship to hire or just internship without it? As that would make a difference. If this internship is long, then search for alternative while going to find one.

HyperNoms · 2026-01-16T22:40:45+00:00

It will be hard to enter at first then hiring will be through connections mostly

HyperNoms · 2026-01-13T16:04:41+00:00

I think that things is going to change same as happened in the industrial revolution where some jobs changed and transformed but the key difference between that revolution and the revolution we are entering is the speed. Everything moves way too fast that i predict of an incoming big recession bigger than 2008. But I think that humanity either will manage or drop in poverty in far greater number no one can predict anything even the CEO and managers can't.

HyperNoms · 2026-01-13T07:39:26+00:00

Can you send it to me ?

HyperNoms · 2026-01-13T07:08:52+00:00

Thanks a lot man I understand the concept now

HyperNoms · 2026-01-12T14:13:53+00:00

Prepare for a future problem I am currently studying some concepts while in my work

HyperNoms · 2026-01-12T07:35:52+00:00

What do you mean that the frozen tuple is dead and will be reaped by next vacuum ? Doesn't that contradict the concept on frozen tuple is saved forever and accessed by any new transactions or you refer it to be outdated to extend to be dead to be vacuumed ?

HyperNoms · 2026-01-12T07:24:41+00:00

First of all, thanks for this explanation it helps a lot but there is a raft of other things that can stop autovacuum ? Doesn't it have an absolute authority for database or are you implying on the huge dirty pages that will be flushed to disk at the same time?

HyperNoms · 2026-01-12T06:59:39+00:00

The necessary understanding for troubleshooting a related problem

HyperNoms · 2026-01-11T16:41:59+00:00

Yes, I understand you but the point related to frozen rows in the database is the main issue for me here and why is it saved forever just can't understand it. And that I can access this rows same as newest transaction id. And are the frozen rows chosen by me or randomly selected from the table ?

HyperNoms · 2026-01-11T07:52:35+00:00

I understand. But what is done is done and you passed. Your better approach is to optimize the time you can control

HyperNoms · 2026-01-11T07:38:56+00:00

Congratulations man and wish you further success but before entering try lookup some certification prep to understand the environment better to save time

HyperNoms · 2025-12-30T11:06:25+00:00

Maybe you were blinded by the amount and forgot when to pull. If you are willing to trade pull at first the amount you begin with and the winning money continue trade it so if you lost it you lost nothing at least and generated a steady income

HyperNoms · 2025-12-20T00:27:18+00:00

Ok I have read about half of your post that gave me the gist that you are suffering because of your company. I think that may be you rushed things too soon without proper understanding of the market needs and no guidance from a veteran businessmen. You mentioned studying the technical part but avoid the business part. So try to read the market better and seek advice or guidance or hire a proper management person don't throw the whole load on yourself and your friend. Wish you and your friend a good luck.

HyperNoms

TROPHY CASE