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?

PostgreSQL

12 September 2024 00:30

And then you will change haproxy config: replace 5432 port to 6432.

PostgreSQL

12 September 2024 00:28

You will install pgboucer near each posgtres. You will not install it on the etcd hosts.

PostgreSQL

12 September 2024 00:23

What are you asking then?

PostgreSQL

12 September 2024 00:17

At the end of the day, if you only have haproxy or pgbouncer running in one place, that your application talks to. Then you still have a single point of failure.

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

12 September 2024 00:33

so at the backend service, if I have like primary is listening to 5432, and replica is listening to 5433, I'll change both to 6432, right??

PostgreSQL

12 September 2024 00:29

First, you have to configure pgboucer to work with local posgtes on each node.

PostgreSQL

12 September 2024 00:25

If I want to have pg bouncer working with patroni and HA proxy, I wanna like integrate pg bouncer with them.

So my question is, do I have to install and configure pgbouncer on each node of postgreSQL patroni works?? also, do I have to install it on the same node on which etcd is running? and how to integrate pgbouncer with patroni and HA-proxy?? that's my question though

PostgreSQL

12 September 2024 00:21

Yes, I totally understand this, but I am asking for something else here
.

PostgreSQL

12 September 2024 00:13

okay, now if I have 3 nodes managed by etcd and patroni, I wanna now to install and configure pg-bouncer with them, so do I need to setup on each node patroni runs?? Do I need also to setup pg bouncer on etcd node??

and how can I integrate it with patroni to work together with also HA proxy?