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

02 Apr 2025 11:00

This is my config on leader and replica

PostgreSQL

02 Apr 2025 10:47

Obviously not. I reckon you've got some mis-config that lets the vip-manager assume both nodes are down. 🤷

PostgreSQL

02 Apr 2025 10:34

On two node must be down?

PostgreSQL

02 Apr 2025 10:29

I experience.... a distinct speed up on queries containing search for distinct subvalues...... honestly it feels good,.... very good

PostgreSQL

02 Apr 2025 08:53

Hello team,
could I know one thing anyone experiece using GIN index on PG?

PostgreSQL

02 Apr 2025 08:52

Apr 02 09:36:29 PGD2 vip-manager[5520]: 2025-04-02T09:36:29.985+0300 INFO IP address 192.168.25.181/24 is down, must be down

PostgreSQL

01 Apr 2025 22:49

Hi everyone, but if in a cluster, I have a redhat node with a postgresql db installed, if they do the backup, do they do it of the node and therefore also include the postgresql or do they do it only of the node?

PostgreSQL

01 Apr 2025 21:26

Before you set sails into HA seas, maybe you should first learn the difference between absolute and relative pathnames...

PostgreSQL

01 Apr 2025 20:21

I'm a big believer in your learn by doing. It's hard to learn a tool without having something you wish to build with it.

Becoming good at anything requires practice. You won't become a PostgreSQL expert from a 1 hour Youtube video, just like a 1 hour Youtube video won't make you a Violin virtuoso.

Start small and just play with getting PostgreSQL running and solving a simple problem you have.

PostgreSQL

01 Apr 2025 20:01

Because you gave a file in /, which is probably not where your patroni.yml really is?

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

PostgreSQL

02 Apr 2025 11:00

Description=Manages Virtual IP for Patroni
After=network-online.target
Before=patroni.service

[Service]
Type=simple

#ExecStart=/usr/bin/vip-manager --config=/etc/default/vip-manager.yml
ExecStart=/usr/bin/vip-manager --ip="192.168.25.181" --interface="ens160" --netmask="24" --trigger-key="/service/pg_cluster/leader" --trigger-value="PGD2" --dcs-type="patroni"
Restart=on-failure

[Install]
WantedBy=multi-user.target

PostgreSQL

02 Apr 2025 10:34

Usually building index will prevent writes, however you can use CONCURRENTLY to make it build during database usage. Be aware of the caveats though: https://www.postgresql.org/docs/17/sql-createindex.html#SQL-CREATEINDEX-CONCURRENTLY

PostgreSQL

02 Apr 2025 10:31

ok great great brother, but during create GIN index i feel seem it's take much time , no sure during process it will locked table or not brother?

PostgreSQL

02 Apr 2025 10:28

"is down, must be down" sounds like "everything in order here" to me. Are you sure you're looking on the right node?

PostgreSQL

02 Apr 2025 08:53

'm experiencing an issue where the virtual IP address isn't being set on the interface. My setup includes PostgreSQL 17, etcd 3.5.20, and Patroni 3.0.4, but the IP isn't coming up as expected. . The vip-manager logs indicate that the IP is down, and it keeps trying to register it.

Could you please help me troubleshoot this issue?

PostgreSQL

01 Apr 2025 22:57

Assuming "They" means your backup team, "they" are taking an inconsistent snapshot of a filesystem your DB resides on. You *may* even be able to redtore it and get a working DB back.
But it's Schroedinger's Backup, so to speak.
Better get a proper backup solution in place. And tell "them" to exclude your $PGDATA, it's just costing precious tape storage.

PostgreSQL

01 Apr 2025 22:11

No way!

The difference is tiny and unimportant.
And HA is the basis of a successful enterprise server running 24x7!

The latter is much more important!!

PostgreSQL

01 Apr 2025 20:34

Maybe need to know how to define where directory to look at the config file

PostgreSQL

01 Apr 2025 20:10

pwd/etc/patroni
[postgres@PGD1 patroni]$ [postgres@PGD1 patroni]$
[postgres@PGD1 patroni]$ patroni --validate-config /patroni.ymlname is not defined.
scope is not defined.restapi is not defined.
consul is not defined.etcd is not defined.
etcd3 is not defined.exhibitor is not defined.
kubernetes is not defined.raft is not defined.
zookeeper is not defined.postgresql is not defined.

PostgreSQL

01 Apr 2025 19:47

I'm add name and scope