2830
English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
Hello guys
How can we perform failover and failback without any tool in postgres. In streaming replication setup I promoted secondary as master. So now I need my old master back. So I tried with pg_rewind but not working. How can I perform failback.
Hey Guys,
I have a serious important question to know more about your perceptions on the future of being a DBA.
I wanted to know is being only a DBA is a satisfactory for career progression in the future, or the world of tech now wanted you to delve into more skills to put into consideration as well like programming more to be specific, to exactly to dig deep more into being a software engineer rather being a DBA.
As I see multiple vacancies nowadays need a DBA, and have a great Java programming skills more into problem solvings skills in coding.
What do u think, guys?
On my append-only tables i found some amount of dead tuples. I find it weird since I've never deleted any rows. However, at some point i have used ON CONFLICT DO NOTHING to prevent duplicate inserts. Does that cause a written and then a deleted tuple?
Ok. Can we enable archive mode ?I was asked to setup streaming replication in RDS.
Читать полностью…
Hello
How can setup the replication in AWS RDS postgres? Is it possible to setup streaming replication in RDS? Please help me on this.
Hi, I installed postgresql 17.rc1 but the postgis spatial extension is not found, I had to download postgis 3.5.0dev, can you help me with the configuration in windows
Читать полностью…
Overall, patroni is way better if u want to have a scalable solution for large environment
Читать полностью…
I am new to Postgres, purchased a few trainings, the only HA solution I have is rempgr, that’s why I installed it, and was wondering if it is a good solution
Читать полностью…
Thanks, Mustafa!
About repmgr, one drawback is the split brain scenario, is this possible using Patroni?
PostgreSQL Person of the Week interview with: Andrew Atkinson
https://postgresql.life/post/andrew_atkinson/
Yep, what's killing you is the Rows Removed by Filter: 16.020.005
part.
would someone be able to help me with this slow query?
https://explain.dalibo.com/plan/cc60892796gce73c
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
Читать полностью…
pg_basebackup then. Or maybe you can do something with rsync, @unfoxo had some examples recently.
Hi @Musty_10. I believe that DBA roles have largely evolved into DBA engineering positions, particularly in cloud environments where DevOps practices are becoming more common. Most skills associated with traditional DBA roles now focus on data migration, and coding skills have also become increasingly important.
Читать полностью…
Hello and welcome to this chat. Here we discuss PostgreSQL and provide best-effort voluntary support on Postgresql issues.
If you have any question, try asking kindly, including log files, error descriptions and perhaps what you're trying to do.
- 🚫 photos and screenshots
- 🚫 spam and offtopic
- ✅ questions with log files and clear explanation of what's gone wrong
⬇️ Press the button down here ⬇️
You do it directly from the AWS console, or via the API. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.Replication.ReadReplicas.html
Читать полностью…
Come to think of it, *if* you violated your DCS and lose a DC, it would go down or block operations, which will cause Patroni to shut down your cluster.
So even if you try quite hard, you should have trouble getting a split brain... 😏
Patroni uses RAFT implementations (etcd, zookeeper, etc.) which are *specifically designed* not to suffer from split brain.
You could violate the DCS layer of course, e.g. by setting up a 3-node etcd and then shutting down one node permanently. But that would be against the basic design ideas. So by definition the answer is "no, if you use it like designed".
yeah, u won't find a lot in a purchased training someone implementing Patroni as it is more complex compared to repmngr.
It has pros like u can integrate literally with anything, cloud specifically.
u can avoid splitting brain using etcd, zookeeper or any concensus tool.
U can have full cluster health check
in patroni, is it fully automatic, but with repmngr u can have a minimal manual intervention when failover happens
I guess it is there, but with etcd or other key store, u can avoid this
Читать полностью…
In terms of simplicity go for repmngr, but Patroni has more to offer than repmngr
Читать полностью…
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!
yes, adding the composite index on (post_date, data_type, inactive_on) made it acceptable.
- thank you!!
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
Читать полностью…
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
Читать полностью…
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!!!!
Читать полностью…