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

Then a dump and restore (probably including some tweaks to the locale information in the schema) will be necessary anyway, I think.

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

PostgreSQL

Db cassandra 2025>>

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

PostgreSQL

You can export from the current version using pg_dumpall, restore the database on the test system and check it, then do the same on the real system

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

PostgreSQL

Just having dead rows in a PostgreSQL database is completely normal. Any database that is getting updates or deletes will have some. Reindexing a database after a major version upgrade is generally good practice. Be sure you do a VACUUM ANALYZE of the database as well.

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

PostgreSQL

It's safe! Are you experiencing any issues after doing so?

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

PostgreSQL

First, 9.6 is ANCIENT.
I would make this a real project and plan to upgrade to V17.
Dump it and restore it into 17. Test it. Measure how long that took.

I have no idea bout your requirements, and while I LOATHE constantly upgrading a system that works.
You will get few BETTER chances than this.

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

PostgreSQL

Hello guys, i need an postgres / stackgres expert to fix an issu on our server, dm me for info

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

PostgreSQL

Chennai or bangalore location with flexible hybrid mode. Strong in postgresql dba with GCP or Azure cloud and Terraform experience

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

PostgreSQL

You're better off asking AWS about AWS's products. But you'll find it in the AWS console.

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

PostgreSQL

PostgreSQL Person of the Week interview with: Shruthi K C

https://postgresql.life/post/shruthi_k_c/

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

PostgreSQL

user maybe in rush. Or needs it before the place starts to burn ❤️‍🔥

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

PostgreSQL

For backing up with postgresql, check this out: https://www.postgresql.org/docs/current/backup.html

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

PostgreSQL

If you know please tell me otherwise don't reply

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

PostgreSQL

That will say "COMMIT" though.

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

PostgreSQL

When I had similar issues, I would just stop the transaction and it would tell "transaction aborted during seq_scan of relation xxxxxx (PID xxxxx)"

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

PostgreSQL

This azure paas was based on windows...

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

PostgreSQL

Postgresql binaries can probably be found in very very old repositories of very very old systems, there's plenty of archives

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

PostgreSQL

It is a legacy system ans just work with postgres 9.6. Azure single server is retired this Friday. That why we need to build a VM as this postgres version is obsolete. Any place where I can look at to find the binaries?

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

PostgreSQL

Ok, thanks!
I haven't seen any problems after this operation yet. The only thing is, I did a database analysis and an error appeared there - dead rows, I don't know yet how to fix it and whether it's worth fixing at all

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

PostgreSQL

After upgrading the postgresql version, I re-indexed the main postgre database. Isn't this a safe procedure? I'm worried that I might have messed up something for the system 😅

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

PostgreSQL

Hello, we are moving a legacy system running postgres 9.6 + Azure single server (PaaS) to IaaS. is there any place to download the 9.6 binaries?

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

PostgreSQL

Around 5 years of relevant experience, please reach out to me. No fake experience please

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

PostgreSQL

Anyone interested in Postgresql DBA role ?

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

PostgreSQL

Hi, how to check the logs in Aurora postgresql

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

PostgreSQL

woah blue badge, is this twitter now

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

PostgreSQL

That's an attitude right there. His reaction means that this is an unbelievably terrible idea.

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

PostgreSQL

Postgresql does not have any integration with SharePoint. You're gonna need to get an external program that does so, for example OneDrive with the sync option enabled and a backup to the synced OneDrive folder.

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

PostgreSQL

How to take postgresql data backup on the SharePoint folder? Please give me the example

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

PostgreSQL

Or, looking at htop you can easily see what postgresql is doing with the tree view (F5)

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

PostgreSQL

Hmmm, that's an interesting question. I don't think we currently have any way to introspect such a situation. I do think we should have one though, and if it's just a separate system view similar to pg_stat_activity 🤔

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