2830
English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
Dear people
According to you,
How to learn kunbernetes best way?
I was following Nana's youtube tutorials it was good, but I am not able to absorb all the knowledge.
Thank you in advance
And switch to a proper solution. cp to some path and fiddling with archive_cleanup & co. is soooo 90s 😏
Question: if I shut down the secondary for 4 hours and start it again , will it be able to recover from archivevlog location and then start applying the wall log again as usual.With archive_cleanup_command used in recovery.conf ,it's deleting the archive ,so when the secondary instance is down ,it will not delete those archieve logs , but when I am starting secondary instance using pg_ctl -D ,will it apply first the archive and then start wall apply ,if not what will I need to do so (excluding recreating the whole secondary db with fresh backup)
Читать полностью…
Greeting Gurus ! Rather a lame question from newbie ,using streaming replication the recovery.conf from standby and relevant parameter from postgressql.conf from primary is as below
Читать полностью…
That's all good. So, even more important to have backups and source control.
If it's just you, I would run it locally. Learning to move it is part of the learning curve, IMO.
I am starting development
It is going to be a saas based product with 1000+ tables
Well, if you're not hitting the max connections, then your high limit is not likely to be the issue.
I suggest you collect some more data to look at, to point you in the right direction. Get some monitoring on the number of active connections in pgagroal and pgsql. Some metrics on avtive TCP connections and bandwidth. And some metrics on the queries being run.
You're unlikely to find the cause, and thus be able to fix the issue, without any data.
But do you mean it's making 30k queries or 30k connections?
Читать полностью…
pgagroal max connection limit is 900 , idle timeout is 600, what else needs to be discovered there?
Читать полностью…
App is not in my hand. The client sends a bulk request and then an error occurs.
Читать полностью…
Yeah! Use the cloud! Spin up a kubernetes cluster that will copy the file over AWS
Читать полностью…
1. Upgrade your postgresql version, 9.3 is EOL
2. archive_cleanup_command, assuming you have used the "%r" parameter properly, will keep all the needed wal files (including future ones that might not be applied yet)
Hello and welcome to this chat. Here we discuss PostgreSQL and provide best-effort voluntary support on Postgresql issues.
If you have any question, try asking kindly, including log files, error descriptions and perhaps what you're trying to do.
- 🚫 photos and screenshots
- 🚫 spam and offtopic
- ✅ questions with log files and clear explanation of what's gone wrong
⬇️ Press the button down here ⬇️
using streaming replicaton , my recovery.conf on standby :
standby_mode = 'on'
primary_conninfo = 'host=163.189.13.114 port=5432 user=replication password=replication'
archive_cleanup_command = 'pg_archivecleanup /mnt/backups/Local01/archiving %r' ## NAS share between Primary and standby
restore_command = 'cp /mnt/db_data_2/pg_xlog/%f "%p"'
-------
On Primary postsql.conf
archive_mode = on # allows archiving to be done (change requires restart)
archive_command = 'cp %p /mnt/backups/Local01/archiving/%f'
Single developer or multiple?
If multiple will you guys work on your own copies and then merge?
Also, how will you manage tracking your changes over time?
(We push all of our DDL into SVN at least once/day and commit the changes).
This helps if someone drops a structure you need to create.
it also helps, because ours goes back DECADES and I can see the first time someone CHANGED something 5 years ago.
Yes, it adds some work up front. But it SMART work.
Also, if you cannot stop RIGHT NOW and RESTORE your DB.... you are doing it wrong.
A Database without TESTED backups... Is a Disaster waiting to happen.
it's good Hygiene!
Hello and welcome to this chat. Here we discuss PostgreSQL and provide best-effort voluntary support on Postgresql issues.
If you have any question, try asking kindly, including log files, error descriptions and perhaps what you're trying to do.
- 🚫 photos and screenshots
- 🚫 spam and offtopic
- ✅ questions with log files and clear explanation of what's gone wrong
⬇️ Press the button down here ⬇️
Yes if a limit were the issue, then related errors should have been captured in pgagroal logs.
The number of active connections in pgagroal and postgresql are under the max limit.
It can use all 900 connections but currently it is only 30
Читать полностью…
Multiple write requests at a particular point of time
Читать полностью…
Given that pgagroal is the component accepting connections, I'd look there first.
Читать полностью…