PostgreSQL

27 Nov 2024 14:24

So in case im not using replication slot and i configure my replica like primary_con_info + restore_command I also have to make sure my primary's pg_wal will keep enough wal files?
but if i use the archive command doesn it means that all the WAL files are also copied directly to another directory and can be fetched from there in case replica needs them?

PostgreSQL

27 Nov 2024 14:15

Thanks,
now if i have replication that set as streaming+log shipping (archive command) - do i need to worry about WALs being deleted from pg_wal before streamed or shipped directly to replica?

PostgreSQL

27 Nov 2024 14:12

A soft limit, yes. It *should* not grow above that before a checkpoint is triggered.

PostgreSQL

27 Nov 2024 05:06

I'd jump at this if it weren't such an obvious scam.. been job hunting for 3 months with no success

PostgreSQL

26 Nov 2024 20:35

But, of course, we are talking about Microsoft failover cluster, where,if postgres installed on 2 nodes, only one node can serve read/writes, while the other node cannot serve even with reads, correct? So actually, shared storage failover concept with windows build-in feature would not allow to release the master node with some read operations ...

PostgreSQL

25 Nov 2024 06:46

# su - postgres
$ psql

PostgreSQL

24 Nov 2024 23:13

Patroni, Pgbackrest and Ubuntu combo works so great for me that I don't have to deal with Windows headache.

PostgreSQL

24 Nov 2024 19:08

I've seen people that swears that they knew an architect from a company that did that with a fine success!

PS Yes, MS fileover cluster is completely orthogonal to postgres replication clustering.
Btw, imho it's much better autofailover that pg_auto_failover and so on.

PostgreSQL

23 Nov 2024 18:48

Also, it might be that the planner just ignores some of the JOINed tables if they aren't relevant to the result with only two columns. Compare the EXPLAIN outputs of both queries.

PostgreSQL

23 Nov 2024 17:31

If your 2 columns are in the index, no table accesses are necessary, and the sql is very fast....

PostgreSQL

23 Nov 2024 17:03

HIPAA with postgre and GCP . Kindly help . Newbie

PostgreSQL

23 Nov 2024 06:24

Hi
Is there any way to get discount or get coupon codes for postgreSQL certification from enterprisedb.
Exam costs 100$
Kindly help.

PostgreSQL

22 Nov 2024 14:51

Learn Manual, API Automation, Selenium Automation Testing for Job guarantee✈️

Learn in - Demand Tools
1. SELENIUM
2. POSTMAN
3. TestNG
4. REST ASSURED
5. GitHub
6. Cucumber
7. CI/CD Pipeline Setup
6. Jenkins and more....

• 1:1 Live Online Training
• Flexible Timings
• Unlimited Interviews
• Mock Interviews
Lowest Fee in the World

WhatsApp for more details
+91-700-421-9889

PostgreSQL

22 Nov 2024 09:51

Hey guys,

Any idea why a normal select,insert, create and drop actions queries are needed for usage permission in pg_logical schema ?

PostgreSQL

22 Nov 2024 01:36

User and encrypted password entry should be there in pool_passwd file. Password should be in encrypted form, not in plain.

PostgreSQL

27 Nov 2024 14:22

As long as you are using replication slots for SR and right archive_command, WAL files are not deleted from pg_wal before they are successfully streamed or shipped. However, misconfigurations or lagging replicas can lead to issues, so proactive monitoring is essential

PostgreSQL

27 Nov 2024 14:13

max_wal_size sets a guideline for checkpoint frequency and WAL recycling, but it is not a hard limit. The actual size of the pg_wal directory may exceed this value under certain circumstances

PostgreSQL

27 Nov 2024 14:10

is it correct to say that "max_wal_size" is the limit for the pg_wal directory?

PostgreSQL

27 Nov 2024 03:49

Back door jobs available for freshers and experienced persons

PostgreSQL

25 Nov 2024 06:49

parmarshyamsinh/getting-started-with-postgresql-a-beginners-guide-bf8d55fb2ef4" rel="nofollow">https://medium.com/@parmarshyamsinh/getting-started-with-postgresql-a-beginners-guide-bf8d55fb2ef4

PostgreSQL

25 Nov 2024 06:44

Hi guys new to PostgreSQL how and where to start??

PostgreSQL

24 Nov 2024 19:17

Ok,so if Microsoft Server solves the whole headaches around failovers, fencing, ..even new version of Postgresql 17 to solve as well incremental backups, and full restore backup, I should be very calm with such setup that would just work. Are there also some other backup tools that are good,free available and for windows that you would recommend? Postgresql does not yet natively provide differential backup/restore,so I would still need to look for option for that

PostgreSQL

24 Nov 2024 19:05

Hi, does someone have good experience with deployment of Postgresql with Windows Server? Does the Microsoft's feature of "Failover cluster" helps to solve the matrix of the typical tools, such as Patroni, Repmgr, pg_auto_failover, or this "Failover cluster" feature solves just the equation of shared disk storage failover (for write operation) to eg. Slave B node, when Master A node runs into problem? 
I would be glad of any supporting comments? Thank you, Gorazd!

PostgreSQL

23 Nov 2024 18:32

Hi,
I am looking for PostgreSQL developers with 8-10 years experience. Remote job in Bangalore. If you are interested let me know

PostgreSQL

23 Nov 2024 17:09

if you’re not in hurry, it’s on our roadmap
https://neon.tech/docs/security/compliance

(why some “Neon” here? we are open-source Postrges-based cloud serverless, with contributing back to Open Source and Postgres developers in the team)

PostgreSQL

23 Nov 2024 08:26

Hi everyone.

I have a question about active users.
How can i find to show data of usera dont active in the last 30 days?

PostgreSQL

22 Nov 2024 22:04

I wrote a big query with multiple join conditions when I use two columns in the select part this query will execute within 3 seconds and return 300000 of records but when adding another 15 columns the same query will take 1.30minutes..how can I reduce the time?

PostgreSQL

22 Nov 2024 10:08

It must be the same unless you decide to change authentication method at pgpool side (pool_hba.conf)

PostgreSQL

22 Nov 2024 01:48

This pasword could be the same that i create in by database? So after that i can connect in virtual ip ? With the port 9999??

PostgreSQL

22 Nov 2024 01:32

Hello😀 somene can help me, i have a cluster with a virtual ip with the port 9999, but all my nodes listen in the port 5432 how can create a user in postgresl just to read and write in some schema. I already created the user called “pruebasintercom” but when I try to conect with the virtual ip on port 9999 , but i got this error failed to authenticate with backend using SCRAM: valid password not found ?? In pgpoo there is a file pool_hba.conf what can i do there?? Maybe there is i have to create the new user from my data base?? Some can guide me please?