Re: Files overwritten when installing v9.6 in machine with v8.4 previously running

The  9.6 binaries *should *be installed in their own directories, so no need
to move anything around.

On 9/27/19 9:23 AM, Ekaterina Amez wrote:
> Hi again,
>
> I previously asked in another list about what version would be the best to
> make a pg_upgrade from v8.4. I've finally chosen 9.6 to make version jump
> less drastic, though I've been testing pg_upgrade whole process with both
> 9.6 and 10. But after reinstalling my test machine several times now I
> have 9.6 so that's what I'll be talking about.
>
> The problem I have is that when I install PG9.6 in a machine with CentOS
> and PG8.4 (version that comes with OS) then v8.4 becomes unavailable.
> Finally I've found that psql binary changes after v9.6 installation. But
> checking files that are installed with this version, I can't see what
> package causes the problem. And as I'm not used to *nix systems, I'm not
> sure how can I solve this. The process I've done:
>
> - Installed a new machine with CentOS installation CD, which installs
> CentOS and PG8.4
>
> - Made InitDB, started service (with "service postgresql start" instruction).
>
> - Without changing pg_hba.conf (nor postgresql.conf) file, I've connected
> with psql, created some roles and some empty databases. Disconnected from
> database ("\q") and restored some backups with psql command.
>
> - After all this, I can connect to v8.4 with root user and postgres user.
> Finally I've stopped postgresql (service stop).
>
> - Tried to start postgres again but using pg_ctl. Tested connection with
> psql again (ok) and stopped.
>
> - v8.4 is installed in /usr/bin and /var/lib/pgsql folders, that seemed
> quite generic for me, so I made a copy of both (with "cp -pr" command):
> /usr/bin ==> /usr/bin_8.4
> /var/lib/pgsl ==> /var/lib/pgsl_8.4
>
> - I've tested copy: started with pg_ctl (the one that was copied to
> /usr/bin_8.4) pointing to copied data folder (/var/lib/pgsl_8.4/data).
> Started ok. Tried to connect with psql (ok) and stopped again.
>
> - At this point, I've followed
> https://www.postgresql.org/download/linux/rdhat/ instructions to install
> v9.6: download repo, install client and install server.
>
> - Made InitDB in v9.6 and changed listening port in postgresql.conf (v9.6
> config file)
>
> - After this installation, if I make "service postgresql start" I can see
> "something" running (I can list processes with ps -ef) but when trying to
> connect with psql it won't connect exiting with a message like (sorry,
> it's my translation as original message is not in english):
> psql: could not connect to server: file or directory does not exist.
>     Is server locally running and listening at Unix domain socket
> «/var/run/postgresql/.s.PGSQL.5432»?
> Also "/usr/bin/psql" file is different than it's copy at bin_8.4 (some
> Kbytes bigger than the original file).
>
>
> Older PG version is now unavailable, and I can't run pg_upgrade to migrate
> to a newer version. I've managed to make the whole process in Ubuntu 18,
> but Production server is CentOS 6.8. Any clue about why is this happening
> and how can I deal with this situation? During CentOS installation I can't
> (or haven't seen) change installation directory for Postgres. I now about
> data_directory in postgresql.conf, but not sure how to manage binaries dir.
>
> I have recorded all the commands I've run, just in case anyone need more
> detailed info.
>
>
> Thanks in advance,
>
> Ekaterina
>
>
>

--
Angular momentum makes the world go 'round.