In regard to: Re: [OpenIndiana-discuss] pkg update removes installed...:
just FYI freezing postgres-10 packages prevents pkg update from doing any useful work, it does not update most of the system, just less than 20 packages get updated.
I figured that would be the case. I'm actually a little surprised even 20 packages would upgrade. Updates are meant to be applied in a set, and blocking the update of even one of the packages has a cascading effect that often makes the entire set not apply. If you were really desperate, you could try turning off the version-lock for the package, to see if that allows everything else to be updated. By doing that, you would effectively be saying that you're going to go into uncharted territory, and you're taking that risk on yourself. "Here there be dragons", all that kind of stuff. To do that, you would need to read up on 'pkg facet', but it would amount to something like pkg facet -a 2>&1 | tee /tmp/pkg-facet-a.txt to get a list of all of the facets (the version-lock facets are at the end), and then something like egrep '^FACET|postgres-' /tmp/pkg-facet-a.txt to get a list of version lock settings. From there, to disable a version-lock, it's something like pkg change-facet version-lock.<package-fmri>=false It's extra complicated for PostgreSQL because I don't know if you need to unlock the version-lock.service/database/postgres-10 *and* a bunch of other stuff like version-lock.database/postgres-10 version-lock.database/postgres-10/library etc. I expect it's going to be a bunch of stuff, which gets pretty messy. Definitely a last resort for the truly desperate.
So, I'll do a pg_dumpall inside the old BE and a pg_restore once inside the new one and with an updated postgres.
That is definitely the best path forward. I hope your software works well with an updated PostgreSQL. Database updates can often have knock-on effects, but hopefully your upgrade is easy. Good luck! Tim -- Tim Mooney tim.moo...@ndsu.edu Enterprise Computing & Infrastructure / Division of Information Technology / 701-231-1076 (Voice) North Dakota State University, Fargo, ND 58105-5164 _______________________________________________ openindiana-discuss mailing list openindiana-discuss@openindiana.org https://openindiana.org/mailman/listinfo/openindiana-discuss