2830
English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
hello fellas, do you recommend Barmen instead of pgBackRest?
Читать полностью…
I've never used anything other than pgBackRest. The way I see this is:
1. Short-medium term: use what I've learned from pgBackRest to explore the rest of the ecosystem and better understand how the rest of the tools work and what the differences are
2. Long term: if the project doesn't get funding or doesn't get forked by reputable maintainers, switch to something else
Well he asked in a kind way and gave probable justification on why he didn't just download it
Читать полностью…
I asked a lot, but I can't do those things because of a lack of internet, and there hasn't been a solution for this situation regarding having the file.
Читать полностью…
Hi,
I want to install PostgreSQL, but I don't have access to the PostgreSQL installer file.
Can somebody upload these files to Telegram, please?
FerretDB might give you a migration path that is worth looking at.
Читать полностью…
I'd vote that without a proper relational schema, postgres is mostly useless.
Well not completely useless, but at least mongo do it better.
If the size will _stay_ minimal, you're probably fine just transferring the BSON to a JSONB table in Postgres, using some hacked together tool.
If there's any chance the DB will grow, I'd strongly recommend to design a proper relational schema and convert the data into it.
Kathy Lien changed my trading journey, her guidance was clear and effective, I achieved a big breakthrough withdrawals were smooth and free.
You can register it using your gmail and enroll for yourself
Читать полностью…
First of all, you need create the extension pg_repack in RDS and grant write access to temporary log tables created by pg_repack. After that on separate host (EC2) with connectivity to RDS install pg_repack binary, then run it from that host by providing RDS dns after "-h" .
Typically LLM confuses create extension step with client installation cause AWS documentation was written by a human.
We'll need to figure it out. It was maintained until a few days ago, it's stable and it works. You don't need to migrate away tomorrow
Читать полностью…
pgBackRest is unmaintained 😱
https://github.com/pgbackrest/pgbackrest
Yeah just ask ai to program the entirety of postgresql from scratch
Читать полностью…
Hello folks, we're inviting 5 or 10 minute Lightning Talks for May 7th's PostgreSQL Edinburgh Meetup! If you have a Postgres-adjacent story to share, please let me know and we'll put you on the programme! We would especially encourage first-time speakers to take the plunge!
https://luma.com/91uvudnu
#job #dba #postgresql #blockchain #database #remote
Job: PostgreSQL DBA (Blockchain)
Company: Lagrange Labs
Salary range: $4,500–$6,500
Work arrangement: remote, full-time
Responsibilities:
— Administration, optimization, and scaling of high-load PostgreSQL databases.
— Designing storage architectures for massive arrays of indexed data from various blockchain networks.
— Tuning the performance of complex SQL queries and optimizing data schemas to minimize latency.
— Configuring and monitoring backup, replication, and disaster recovery systems.
— Monitoring database health, identifying bottlenecks, and preventing incidents.
— Working with PostgreSQL extensions and integrating with analytical tools.
Requirements:
— At least 4 years of experience as a Database Administrator.
— Expert knowledge of PostgreSQL (internal architecture, vacuuming, partitioning, indexing).
— Experience working with high-load systems and terabyte-scale data sets.
— Skills in automating routine tasks (Python/Bash) and working with infrastructure in Docker/Kubernetes.
— An understanding of the specifics of blockchain data (immutability, block and transaction structure) would be a significant plus.
Contact: Gorskines
Unless you care about backup and other mostly irrelevant stuff /s
Читать полностью…
Hire a programmer.
(Well, consulting with LLMs may also be an option, if you have at least some minimal programming skills).
Hello. The requirement is to migrate from MongoDB 8.0.9 to the latest version of PostgreSQL. Could you please advise on the most appropriate method for this activity, considering the database size is minimal?
Please help on this.
There will be plenty of free courses available in EDB learning. Try below
https://training.enterprisedb.com/learn/learning-plans/34/open-source-postgresqlr-learning-plan-v17
Well... I'm really was too hasty, I beg your pardon.
I was expecting something about extension create on rds, confirmation that it exists in rds (at least sometimes, not sure), links to official docs etc.
Just a short "drop in, go on" seemed to me an extrapolation of non-rds case... I was really wrong on that.
I think then they probably misunderstood that the message is from LLM and reacted with the clown emoji.
If @tzirechnoy thinks something is wrong with your answer on technical grounds, then I think they will explain it, which willl be more fruitful :)