PostgreSQL

03 Apr 2025 22:34

You can do cross database queries with fdw

PostgreSQL

03 Apr 2025 18:19

https://www.youtube.com/live/0nFGVCpQDec?si=FCj2p_WagE4FfY3i - live session of Postgres Hacking with Andrey Borodin; join!

PostgreSQL

03 Apr 2025 13:57

I want to do certification

PostgreSQL

03 Apr 2025 12:59

I f***ed up royally a logical upgrade a couple of years ago. Failed to sync sequences that weren't linked to any tables. Problem was they were used to generate certificate S/Ns...

PostgreSQL

03 Apr 2025 12:37

That is, if you keep your sequences synced continuously. Otherwise I doubt you can manage a few 100 ms. Ask me how I know... 😬

PostgreSQL

03 Apr 2025 11:29

ah, logical replication is the one with the lowest downtime

PostgreSQL

03 Apr 2025 11:25

Hi, how do you decide between pg_upgrade, logical replication, and dump/restore for postgresql upgrades? Which postgresql upgrade method is the best for minimal downtime. Thanks

PostgreSQL

03 Apr 2025 09:55

Those are great approaches and i understand you
making changes to move from mysql to postgres or get more projects related to postgres is hard.
I started my way in by learning by my own so it shouldnt be trouble for me, the problem is finding those good topics to learn.

PostgreSQL

03 Apr 2025 09:35

You can ask your team leader to change the field of your occupation. Or you can just change the company. Or you also can work as freelancer or maintain your own pet projects

PostgreSQL

03 Apr 2025 09:29

How can I stay updated as a DBA in postgres?
Where can I find some cool projects / architecture to learn and keep being in this rapidly advancing world? 🧐

PostgreSQL

02 Apr 2025 16:37

That's basically what pg_rewind does. But that's not automatic.

PostgreSQL

02 Apr 2025 15:26

https://www.pgedge.com/blog/setting-up-failover-slots-in-postgresql-17

PostgreSQL

02 Apr 2025 11:50

Oh my...
https://github.com/cybertec-postgresql/vip-manager

PostgreSQL

02 Apr 2025 11:26

etcd API 2 vs. 3 mismatch.
Either use ETCDCTL_API=2 or ETCDCTL_USER

PostgreSQL

02 Apr 2025 11:14

And what does

etcdctl get /service/pg_cluster/leader

PostgreSQL

03 Apr 2025 22:33

Hi, does anybody have info, when postgres will support cross-database queries? And why it is not implemented yet?

PostgreSQL

03 Apr 2025 14:01

There is no such thing as postgresql certification, however many suggest Enterprise DB: https://www.enterprisedb.com/training/certification-exams

PostgreSQL

03 Apr 2025 13:57

Is there classes suggestions for postgre sql??

PostgreSQL

03 Apr 2025 12:56

That's why it's hard for new DBAs but downtime for finely tuned process that handles application dns switch would be in milliseconds (hundreds of ms was exaggeration).

PostgreSQL

03 Apr 2025 11:32

Logical is lowest downtime but hardest to setup, if you can switch your application connections quickly then it's usually few hundred milliseconds of downtime. pg_upgrade with hard link can take long time if there are too many tables and analyze is added time.

PostgreSQL

03 Apr 2025 11:27

pg_upgrade with hard link option is the one with lowest downtime, else pg_upgrade will copy the entire data folder and should be quite fast.
dump restore is good if you want to start from scratch with a "clean" data folder (new indexes, no dead tuples...)
logical replication is somewhat complex to setup so i didn't look much into it

PostgreSQL

03 Apr 2025 11:03

Patroni has pg_rewind flag

PostgreSQL

03 Apr 2025 09:36

Cause I think in general “learning in order to learning” is a bad idea, you have a lack of motivation

PostgreSQL

03 Apr 2025 09:32

I mainly work here now with mySQL
There are some psotgres db's here but they are small and barely any work with them.
So i feel like I missing a lot that going out there

PostgreSQL

02 Apr 2025 18:39

You can also use rsync if not much data has changed

PostgreSQL

02 Apr 2025 16:27

This still requires rebuilding the old primary as secondary.
I was looking for something like reverse replication for failover n failback

PostgreSQL

02 Apr 2025 15:24

Hi,
Does postgres 17 has the ability to make to make the auto reverse replication when a secondary is promoted?

PostgreSQL

02 Apr 2025 11:29

Do you have docs about vip manager with patroni?

PostgreSQL

02 Apr 2025 11:24

# etcdctl get /service/pg_cluster/leader
{"level":"warn","ts":"2025-04-02T12:22:24.718894+0300","caller":"flags/flag.go:93","msg":"unrecognized environment variable","environment-variable":"ETCDCTL_USERNAME=root"}
{"level":"warn","ts":"2025-04-02T12:22:24.733532+0300","logger":"etcd-client","caller":"v3@v3.5.20/retry_interceptor.go:63","msg":"retrying of unary invoker failed","target":"etcd-endpoints://0xc00053a1e0/192.168.25.180:2379","attempt":0,"error":"rpc error: code = InvalidArgument desc = etcdserver: user name is empty"}
Error: etcdserver: user name is empty

PostgreSQL

02 Apr 2025 11:03

I'm using rest-api patroni