2830
English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
AFAIKT Citus gets told what to distribute how, incl. Indexes etc.
Anyway, if you already know you'll have data distributed in a bad way, maybe sharding is the wrong approach altogether?
Also, using partitioning and postgres_fdw seems to be a feasible option nowadays. As you need to spend time on thinking about how to split your data anyway, consider this as well.
How do you guys store/manage your procedures?
Using Git or something else?
RDS manages binary replication for you, and it sets up WAL archiving as part of it. You don't have any real control over the precise configuration of binary replication: you get what RDS sets up for you.
Читать полностью…
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
Читать полностью…
Yes exactly, do u know if I used schema-based sharding, certainly it will divide the database into different folders within the same data of the database across the workers nodes. Now, if I want to have an index for example to implement, will be still effective as the physical data is scattered so maybe a portion of your index data is found on worker node 1 and other on node 2, so it won't make sense, right?
Читать полностью…
Is it possible to apply database sharding to postgreSQL? Having two cluster that working as a primary and divide the workload on both?
Читать полностью…
Hi Everyone..I am doing migration by using the Ora2pg tool ..i am facing an issue and the error is as follows.
-------------------------------------------------------------
DBD::pg:: db pg_putcopyend failed :ERROR: invalid byte sequence for encoding "UTF8": 0x00vg : 11 recs/sec
Context: copy content, line 1 at /usr/local/share/perl5/Ora2pg.pm line 16849
FATAL : ERROR : invalid byte sequence for encoding "UTF8": 0x00
_-------_----------------------------------------------------
Do you have any commands for that, that will be useful?
Читать полностью…
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?