pg_sql | Unsorted

Telegram-канал pg_sql - PostgreSQL

2830

English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.

Subscribe to a channel

PostgreSQL

hello fellas, do you recommend Barmen instead of pgBackRest?

Читать полностью…

PostgreSQL

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

Читать полностью…

PostgreSQL

This sucks. What's the next best thing?

Читать полностью…

PostgreSQL

Well he asked in a kind way and gave probable justification on why he didn't just download it

Читать полностью…

PostgreSQL

Thank you very much❤️

Читать полностью…

PostgreSQL

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.

Читать полностью…

PostgreSQL

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?

Читать полностью…

PostgreSQL

Any one has lernomate postgresql training videos

Читать полностью…

PostgreSQL

FerretDB might give you a migration path that is worth looking at.

Читать полностью…

PostgreSQL

I'd vote that without a proper relational schema, postgres is mostly useless.

Well not completely useless, but at least mongo do it better.

Читать полностью…

PostgreSQL

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.

Читать полностью…

PostgreSQL

Kathy Lien changed my trading journey, her guidance was clear and effective, I achieved a big breakthrough withdrawals were smooth and free.

Читать полностью…

PostgreSQL

You can register it using your gmail and enroll for yourself

Читать полностью…

PostgreSQL

Hi any one having postgresql videos?

Читать полностью…

PostgreSQL

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.

Читать полностью…

PostgreSQL

Alex Fergosen? 😂

Читать полностью…

PostgreSQL

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

Читать полностью…

PostgreSQL

pgBackRest is unmaintained 😱

https://github.com/pgbackrest/pgbackrest

Читать полностью…

PostgreSQL

Now that's a first 😅

Читать полностью…

PostgreSQL

Yeah just ask ai to program the entirety of postgresql from scratch

Читать полностью…

PostgreSQL

why don't u ask AI for such doubts

Читать полностью…

PostgreSQL

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

Читать полностью…

PostgreSQL

#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

Читать полностью…

PostgreSQL

Unless you care about backup and other mostly irrelevant stuff /s

Читать полностью…

PostgreSQL

Hire a programmer.

(Well, consulting with LLMs may also be an option, if you have at least some minimal programming skills).

Читать полностью…

PostgreSQL

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.

Читать полностью…

PostgreSQL

@PhaniSankar9

Читать полностью…

PostgreSQL

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

Читать полностью…

PostgreSQL

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.

Читать полностью…

PostgreSQL

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 :)

Читать полностью…
Subscribe to a channel