English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
Then a dump and restore (probably including some tweaks to the locale information in the schema) will be necessary anyway, I think.
Читать полностью…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
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.
Читать полностью…It's safe! Are you experiencing any issues after doing so?
Читать полностью…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.
Hello guys, i need an postgres / stackgres expert to fix an issu on our server, dm me for info
Читать полностью…Chennai or bangalore location with flexible hybrid mode. Strong in postgresql dba with GCP or Azure cloud and Terraform experience
Читать полностью…You're better off asking AWS about AWS's products. But you'll find it in the AWS console.
Читать полностью…PostgreSQL Person of the Week interview with: Shruthi K C
https://postgresql.life/post/shruthi_k_c/
user maybe in rush. Or needs it before the place starts to burn ❤️🔥
Читать полностью…For backing up with postgresql, check this out: https://www.postgresql.org/docs/current/backup.html
Читать полностью…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 binaries can probably be found in very very old repositories of very very old systems, there's plenty of archives
Читать полностью…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?
Читать полностью…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
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 😅
Читать полностью…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?
Читать полностью…Around 5 years of relevant experience, please reach out to me. No fake experience please
Читать полностью…That's an attitude right there. His reaction means that this is an unbelievably terrible idea.
Читать полностью…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.
Читать полностью…How to take postgresql data backup on the SharePoint folder? Please give me the example
Читать полностью…Or, looking at htop you can easily see what postgresql is doing with the tree view (F5)
Читать полностью…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 🤔
Читать полностью…