PostgreSQL

31 Mar 2025 07:44

Any chance the those tables create under user defined schema?

PostgreSQL

31 Mar 2025 05:11

I don't understand you , what are you want to say?

PostgreSQL

31 Mar 2025 04:33

I'm reminded of the joke of a guy who fell off a cliff, and caught a branch. He's screaming for anyone to help him... When a Deep Booming Voice Calls out "I am here for you, let go and I will catch you".

He screams out louder: "Is there ANYONE ELSE who can help me?"

LOL

PostgreSQL

31 Mar 2025 00:03

I told you 20 minutes earlier. You can also check out the vipmanager from cybertec.

PostgreSQL

30 Mar 2025 22:42

The by far easiest way IMNSHO is to give the clients each IP and let them pick the primary.
See
https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNECT-TARGET-SESSION-ATTRS
or
https://jdbc.postgresql.org/documentation/use/#connection-fail-over

PostgreSQL

30 Mar 2025 22:05

just install the patroni+etcd+postgresql

PostgreSQL

30 Mar 2025 21:59

If the master go down , how the application know new Master

PostgreSQL

30 Mar 2025 20:57

What is your task?
1. if you need automation, then etsd + patroni is enough for you
2. if you need high availability balancing, then you need to install everything from the list.

I would recommend you to install it manually first, then through ansible.
so you will understand how the installation goes, you also need to read the documentation for what it is needed
1. etсd
2. patroni
3. haproxy
4. pgbouncer
5. vrrp (vip manager)

link explains it briefly, just read it.

PostgreSQL

30 Mar 2025 19:27

hi, try this https://github.com/vitabaks/autobase

PostgreSQL

30 Mar 2025 18:59

how can i talk to my bot?

PostgreSQL

30 Mar 2025 17:22

Pavan, if you read the definition of vacuum full. It takes your current TABLE. Locks it. Loops over the rows and rebuilds, row by row. The ONLY rows it cannot remove that have been deleted would be things that are actively being deleted. WHICH is what the LOCK prevents. It acquires an exclusive lock, for this reason.
A regular Vacuum will leave EMPTY Space where dead rows used to live, available to be written over.

The ONLY flaw you can accuse Vacuum Full of. Is not removing DELETED Columns. Which is well documented. Because PG does a virtual deletion of columns and VACUUM FULL does not edit the row data at all, it simply copies it. So the wasted space is included there. (The best way to get rid of it is to do "CREATE new_table as SELECT * from OLD_TABLE", which will make a clean variation, no deleted rows, no deleted columns, RENAMING everything is up to you)

PostgreSQL

30 Mar 2025 05:43

Also errors in the logs

PostgreSQL

29 Mar 2025 06:09

Is there any PostgreSQL whatsapp community or group ?

PostgreSQL

28 Mar 2025 14:01

Any possibility to grant create temp table access to a user?

PostgreSQL

27 Mar 2025 23:58

Postgresql compatible qlik sense?

PostgreSQL

31 Mar 2025 05:12

You didn't get the answer you wanted, so you asked again.
But it reminded me of that joke..

PostgreSQL

31 Mar 2025 05:09

Thank you 🙏🏿🙏🏿🙏🏿

PostgreSQL

31 Mar 2025 02:26

Hi all, I should upgrade postgres from 12.20 to 14.8. What are the commands?

PostgreSQL

30 Mar 2025 23:02

Is there any other solutions my CEO don't want to buy another server ,

PostgreSQL

30 Mar 2025 22:08

here you need a HAproxy with vip (keepalived or VIP manager)

PostgreSQL

30 Mar 2025 22:03

may be this help you https://www.youtube.com/watch?v=A_t_ytq1lpA

PostgreSQL

30 Mar 2025 21:58

Can I set up a PostgreSQL master-replica architecture without using a separate server for HAProxy and PgBouncer?

PostgreSQL

30 Mar 2025 20:46

Most people tend to use haproxy as a load balancer with patroni but a F5 big-ip is another option

PostgreSQL

30 Mar 2025 18:59

Hi, how are you? What is the best load balancer for PostgreSQL with Patroni?

PostgreSQL

30 Mar 2025 18:58

Hi, how are you? What is the best load balancer for PostgreSQL with Patroni?

PostgreSQL

30 Mar 2025 09:25

What kind of errors?

PostgreSQL

30 Mar 2025 05:42

did you guys encounter that vacuum full is not removing the dead tupple in postgres .

PostgreSQL

28 Mar 2025 15:04

GRANT TEMP ON DATABASE ...;

PostgreSQL

28 Mar 2025 12:06

If is the new name for attinuty the response is yes, postgres higher than 9.4 should be supported

PostgreSQL

27 Mar 2025 01:59

Check this out.
https://www.postgresql.org/message-id/6e38c995-9201-4d9a-916b-eeb708ac70e5%40app.fastmail.com