pg_dumpall is handy but doesn't scale because it does not know how to make custom format backup. That's why I usually prefer to use it only for global objects (--globals-only) when the dbs are big (and I cannot use pg_upgrade for some reason)
pg_upgrade is waaaayy faster indeed. Like orders of magnitude faster on some cluster
Btw can you have several versions of postgresql installed together on OpenBSD? It is handy to still allow read in the old cluster while you are migrating.
Hi, @autra
, merci for your comments and sharing your precious knowledge😃
Actually, I didn't know about the difference between pg_dumpall and pg_upgrade.
can you have several versions of postgresql installed together on OpenBSD?
Unfortunately, I don't think so with OpenBSD Ports packages system. It's because it's unable to choose the version in installing PostgreSQL.
You seemingly have to install the old version by building it from source code. There might be another way but, at least, I don't know. I'm sorry.
Besides, as to php (+ php-fpm), it's able to choose the version which is installed and also install multiple versions at the same time on OpenBSD. (Well, /etc/php-fpm.conf is, however, shared by php-fpm daemons by default.)
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Nice write-up! Some remarks:
Btw can you have several versions of postgresql installed together on OpenBSD? It is handy to still allow read in the old cluster while you are migrating.
Hi, @autra , merci for your comments and sharing your precious knowledge😃
Actually, I didn't know about the difference between
pg_dumpall
andpg_upgrade
.Unfortunately, I don't think so with OpenBSD Ports packages system. It's because it's unable to choose the version in installing PostgreSQL.
You seemingly have to install the old version by building it from source code. There might be another way but, at least, I don't know. I'm sorry.
Besides, as to php (+ php-fpm), it's able to choose the version which is installed and also install multiple versions at the same time on OpenBSD. (Well, /etc/php-fpm.conf is, however, shared by php-fpm daemons by default.)