PostgreSQL

17 September 2024 16:26

Hello Everyone!

I hope you're doing well. I wanted to ask if anyone could share insights into the advantages of using repmgr over Patroni as a PostgreSQL high-availability solution. I'm exploring the two options and would appreciate any input on their differences or benefits.

Thank you!

PostgreSQL

16 September 2024 19:20

yes, adding the composite index on (post_date, data_type, inactive_on) made it acceptable.
- thank you!!

PostgreSQL

16 September 2024 17:44

Maybe a composite index on (column mapped on index gltx_i1), gltx.inactive_on, gltx.data_type ? The first index scan is followed by a subsequent filter. A direct composite index on columns involved can help

PostgreSQL

16 September 2024 10:53

As Gunnar said, just write something reasonable and explain to the recreuiter what you can and cannot do. The goal of a job is to take on your current skills and improve so that you can be a worthy employee

PostgreSQL

16 September 2024 10:50

So experience will be counted based on time I've spent in internships only? In that case I will have only 3 months of experience!!!!

PostgreSQL

16 September 2024 09:27

Judging by some of the CVs I've seen in my life and the interviews they led to, "8-10 years" 😏
Seriously:
Be honest, state something like "< 1 year" and amend what you've just explained somewhere in the application. That will (hopefully) result in realistic job opportunities and assignments which allow you to grow on them, so to speak.

PostgreSQL

16 September 2024 07:48

Good morning everyone

PostgreSQL

13 September 2024 15:45

Depends. If it is for personal growth, you pick. If it is so you can get side-gigs, I would see what people are asking for. I come from a world where Certifications don't hurt if they are honestly held (many fail to retain the knowledge).

But I usually look to see where the work is (and might continue to be)... [Conversion INTO PG from many systems] and focus on those skillsets.

PostgreSQL

13 September 2024 15:05

are they monthly? like Oracle?

PostgreSQL

13 September 2024 15:02

what about major realise then, from 15 to 16 for example?

PostgreSQL

13 September 2024 14:51

Download the postgresql 16,3 binaries

PostgreSQL

13 September 2024 00:07

https://nometa.xyz/index.html?redirect=0

PostgreSQL

12 September 2024 10:21

20 mio sounds like a bad case of premature optimization...

PostgreSQL

12 September 2024 00:47

Well, I mean in the configuration of Pgbouncer, I'll configure pgbouncer based on the current postgreSQL running which is running by patroni in my case, not the your localhost, right???

I mean configuring pgbouncer, I have to mention in the pgbouncer.ini file the Ip and port of the current postgres running by patroni, not my localhost one, right???

PostgreSQL

12 September 2024 00:37

Well, I don't know your system, but I can assume that you have to install 2 pgboucer instances - one for primary and one for replica. One on port 6432, and other on 6433

PostgreSQL

16 September 2024 23:58

PostgreSQL Person of the Week interview with: Andrew Atkinson

https://postgresql.life/post/andrew_atkinson/

PostgreSQL

16 September 2024 18:24

Yep, what's killing you is the
Rows Removed by Filter: 16.020.005
part.

PostgreSQL

16 September 2024 16:48

would someone be able to help me with this slow query?

https://explain.dalibo.com/plan/cc60892796gce73c

PostgreSQL

16 September 2024 10:52

Experience is subjective you can stay in a company four years and do nothing or stay somewhere a couple of months and become a pro

PostgreSQL

16 September 2024 09:29

Dunno if pgadmin has a separate option, I'd usually dump the schema and globals and grep -e GRANT -e REVOKE the results.

PostgreSQL

16 September 2024 07:50

Need help
How to take and restore user permissions on a DB for Database refresh activity

PostgreSQL

16 September 2024 06:56

Good morning everybody,

Can you please tell me this, if I started learning and making softwares from last 1 year ( in that time frame I have contributed to open source project (for 2 months) and worked as backend+devops intern (again for 3 months), so do I have 5 months of experience or 1 yoe?

PostgreSQL

13 September 2024 15:09

And yearly major upgrades

PostgreSQL

13 September 2024 15:05

and how to know if there is new patch that need to be upgraded in postgreSQL?

PostgreSQL

13 September 2024 14:53

Stop the cluster, use yum upgrade and then start the postgres

PostgreSQL

13 September 2024 14:44

Hey guys,

If I run postgreSQL 16.2, what is the best approach to update the MINOR release of postgres like to be 16.3?

and how to check for patch release and how to update them pls??

PostgreSQL

12 September 2024 16:24

Hello experts. Has anyone setup pgaudit on windows before

PostgreSQL

12 September 2024 06:27

I have this problem how can partition a table with 20 million of record who can suggest me any document to read ? Or maybe can explain inherins partition can use in this case or not ?

PostgreSQL

12 September 2024 00:43

You'll show ip:port of postgres in pgboucer.ini. But I don't know, how to show to two pgbouncers different config files on one host. Maybe in systemd pgbouncer.sevice file?

PostgreSQL

12 September 2024 00:36

my postgres database cluster is down, because it is totally running by patroni, so you're meaning to configure pg-bouncer on each postgres node managed by patroni?? As if I run psql -h localhost, it won't work. I have to exactly specifying the host and port your postgres running by patroni in order to enter the postgres..

so which one u are referencing?