PostgreSQL

16 Oct 2024 22:20

I'm proud that I provoked that!

(But i'm upset a little, though, that it was unintentional).

PostgreSQL

16 Oct 2024 22:17

Main point is: pg_dump(all) has horrible RPO/RTO, and when disaster strikes and you need to get back up quickly, needing to setup and dump back in loads of data can make the difference

PostgreSQL

16 Oct 2024 22:09

I just stumbled over https://rhaas.blogspot.com/2024/10/is-pgdump-backup-tool.html

LOL Robert , *that* was quick 👏

PostgreSQL

16 Oct 2024 09:58

Check for $http_proxy and $https_proxy in your Python testbed.

PostgreSQL

16 Oct 2024 09:50

That sounds like a problem with your internal network. Did you set a proxy environment variable or so?

PostgreSQL

16 Oct 2024 09:22

Reported S H [7505889847] to admins.​​​

PostgreSQL

16 Oct 2024 08:34

Hello everyone , need help while instalation , i am trying to install postgresql14 on my rhel 7 using yum , i have followed the instructions from postgre but still i have a issue as below

[root@localhost ~]# sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpmLoaded plugins: langpacks, product-id, search-disabled-repos
Cannot open: https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm. Skipping.Error: Nothing to do

i have disabled firewall not sure what i am missing can someone please help me here

PostgreSQL

15 Oct 2024 17:09

1) You cannot do anything good with clusters (currently).

The commodity hardware cluster are always slower than single node of the same price.
Well, it's possible to get performance gain from clusters on a low-end hardware — if you'll separate them completely. No dependencies, no links, no synchronization, and client decides where to go.
But if you didn't do that yet — perhaps, something in busyness logic prevents it, isn't it?

So, just stick to a single server. It would be faster upto a really big servers, with many hundreds of cores, tens terabytes of RAM, tens of millions IOPS.

1.5) Proxmox isn't a bare metal. Either you have a bare metal w/o proxmox, or proxmox with containers or vms.


2) All of the tasks in postgres are done by queries.
So, in order to change something — you probably would need to change queries. Or at least look at them.
In particular, if you want more performance — go and measure your queries, than start thinking about optimising them.
No silver bullet.
Just get to work and do that — measure, look at explain, change algorithms, change structures.

PostgreSQL

15 Oct 2024 16:43

$ pg_dump -h <hostname> -U <username> -W <db_name> > dumped.sql

PostgreSQL

15 Oct 2024 16:10

interesting, I'll go to check it out better.

Thank you @unfoxo and @Musty_10

PostgreSQL

15 Oct 2024 16:04

and also a connection pooler at the same time

PostgreSQL

15 Oct 2024 16:04

https://www.pgpool.net/docs/pgpool-II-3.7.4/en/html/index.html

PostgreSQL

15 Oct 2024 15:57

But this one doesn't route transactional based on whether they are read or write... so I guess still the issue here...?🤔

PostgreSQL

15 Oct 2024 15:53

in my case there are transactions and also prepared statements.

What can be used?

PostgreSQL

15 Oct 2024 15:49

I think haproxy is a bit unfit for "serious" setups where your proxy/pooler needs to know whether the query is read only or write

PostgreSQL

16 Oct 2024 22:19

Especially considering the fact that pg_dump is NOT an exact copy of the data, so the chance of your recovery failing can be high with schemas that are "messy"

PostgreSQL

16 Oct 2024 22:16

I have an exact opposite article in my drafts

PostgreSQL

16 Oct 2024 10:02

Thanks for your help

PostgreSQL

16 Oct 2024 09:54

No, it needs to be done specifically for postgresql?(I tested the code in python, it works fine)
Anyway, thanks for the reply, I will read more about it

PostgreSQL

16 Oct 2024 09:32

Hi everyone
Has anyone had a problem with sending rest request to internal url? I tried pqsl_http, PLPYTHON3U. Requests are sent (for example to google.com), but not to the url inside the local network.

PostgreSQL

16 Oct 2024 09:08

Try to fetch it with curl, then install it directly with rpm

PostgreSQL

15 Oct 2024 17:51

Thank you makes a lot of sense

PostgreSQL

15 Oct 2024 16:43

pg_dump -n schemaname

PostgreSQL

15 Oct 2024 16:35

Can anybody send me the command to take the backup of one schema with data?

PostgreSQL

15 Oct 2024 16:05

so I guess it is the best one to use here in this use case

PostgreSQL

15 Oct 2024 16:04

I think pgpool 2 is doing it here

PostgreSQL

15 Oct 2024 16:00

Hang on, i thought it did that, i think i'm getting confused with another pooler

PostgreSQL

15 Oct 2024 15:53

https://www.pgbouncer.org/features.html

PostgreSQL

15 Oct 2024 15:50

For example, statement pooling might be a good idea when you have a lot of connections doing single-statement (no transactions) queries

PostgreSQL

15 Oct 2024 15:47

Then I guess the problem with HA-Proxy server, does it work with you and ur able to access it and see the dashboard?