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

01 Apr 2025 19:46

patroni --validate-config /patroni.yml
name 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 18:48

If you just want to *use* Postgres, the tutorial in chapter 2 (IIRC) is a good starting point. From then on, books on SQL and/or databases will probably help more than the technical documentation.
I'd recommend "Mastering PostgreSQL" by Dimitri Fontaine, it shows some interesting approaches you'll not find everywhere.

PostgreSQL

01 Apr 2025 17:26

first study programming language and practice writing some code.
second for databases, you need to learn how to write select, update, delete scripts and learn how to optimize the query you wrote.
and the most important thing is to always practice preferably 5-6 hours a day.

PostgreSQL

01 Apr 2025 16:45

Guys, as a newbie I want to ask the professionals.

I'm currently studying PostgreSQL, their documentation is 2500 pages long in PDF
Tell me, do I need to read all this to become a good programmer with a normal salary?
Or will an hour-long YouTube video on PostgreSQL be enough?

PostgreSQL

01 Apr 2025 07:08

https://pgconfigurator.cybertec-postgresql.com/

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

PostgreSQL

01 Apr 2025 19:05

He probably just wants to succeed in an interview but if he is aiming for programmer job then I don't see any need of going through docs or books. Most application developers are clueless about databases anyway.

PostgreSQL

01 Apr 2025 17:27

You don't need to know everything from the written documentation on databases, but you can read it for yourself and keep the documentation at hand, because it is impossible to remember everything.

PostgreSQL

01 Apr 2025 17:07

To be a good programmer you should study programming language first and practice writing some code.

PostgreSQL

01 Apr 2025 12:01

first read documentation for what used any parameters for understanding, after use pgconfigurator

PostgreSQL

01 Apr 2025 07:02

https://www.postgresql.org/docs/current/performance-tips.html