Ekaterina Amez <ekaterina.amez@zunibal.com> writes:
> El 3/12/19 a las 16:14, Tom Lane escribió:
>> I believe the issue here is that you've got Red Hat's postgresql packages
>> installed,
> As I've mentioned, this Postgres version comes with CentOs installation,
> so I guess you're right.
>> and they're not set up to participate in alternatives
>> switching. I'd suggest removing those packages
> By "removing those packages" you mean uninstall v9.2? This is a test
> computer and it's not a problem, but I'm afraid this is going to happen
> also in production server, by doing this won't be my cluster be unavailable?
Um, wait a minute. Are you actually running a server with that 9.2
installation? And the goal is to upgrade that to 9.6 using PGDG
packages? If so, it's going to take some experimentation. I'm sure
that whatever upgrade script the PGDG packages provide isn't going
to work; you'll have to run pg_upgrade by hand. It's probably possible,
but bleats from yum are the least of your worries.
Once you do get the data converted over, probably the cleanest way to
resolve the installation conflict is to remove both sets of packages
and then reinstall only the PGDG ones.
> So what's happening is that I have installed a RH version of Postgres
> instead an official one? Am I right?
That would depend on what you want to call "official" ;-). But Red Hat's
postgres packages use a much different file layout than the PGDG packages,
so they don't interoperate terribly well.
regards, tom lane