[OpenIndiana-discuss] pkg update removes installed services ?!?

[Tim Mooney]

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.Mooney at ndsu.edu
Enterprise Computing & Infrastructure /
Division of Information Technology    /                701-231-1076 (Voice)
North Dakota State University, Fargo, ND 58105-5164