tables?
In Citus (which I'm guessing you are using) it is not supported and that's documented. https://docs.citusdata.com/en/v11.0/extra/triggers.html
Hello, I have an issue with the High Availability solution I set up. I'm using Patroni with HAProxy on both PostgreSQL nodes, but HAProxy is masking the client's IP address th...
Hello all, When update query have like '%value%' condition it takes too much time , What should we do for better performance?
I'm looking for best practices with database migrations which necessarily include user (read: potentially sensitive) data. Making the repos private on Github and commiting our...
What do you want to do with ip addresses from clients?
Can You elaborate why would You have user sensitive data in a repo? PII data is usually on prod only, and anonymized for staging and test
3. restored into db3. but the table is not showing. why its not restored?
Hello. Our backend is using PostgreSQL and performs >50K queries/second and we're facing some scaling issues. The macro symptom is a sundden increase of i/o wait, increase of ...
Hello everyone, I'm encountering difficulties starting PostgreSQL-15 on RHEL 9.2. I'm encountering the following error: "pg_ctl is unable to access the /u01/postgresql-15/dat...
Hi Team, Can anyone help me with below requirement please? we have two rhel 8 servers in which we installed the postgres with a custom data directory path that is /u01/post...
Guys I wanted to make a post upload feature in laravel which will also have likes and comments . So I am assuming that I will have to make a table for post, user, like and ...
Обсуждают сегодня