N
N
Nikolai Savelyev2017-12-06 07:06:12
linux
Nikolai Savelyev, 2017-12-06 07:06:12

How to properly update postgresql built from source?

There is a postgresql 9.6.2 compiled from source
It works, everything is ok.
There was a need to update it to postgresql 9.6.6 compiled from other sources.
In theory, when installing from packages, everything would be updated independently and the same cluster would continue to work. There wouldn't even be a need to do pg_upgrade.
But how to be with collected from source codes? Specify prefixes with old paths? By default, make install installs the new version to a different location. And asks to initialize a new cluster. Maybe somehow you can initialize it with old files?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Moris Haos, 2017-12-06
@morihaos

Hello,
In the case when there was a non-standard installation (your own assembly, your own paths, etc.), it is better to do this:
1. Make a full backup of the databases.
2. Stop the server.
3. Remove the old server.
4. Build and install a new server.
5. Start a new server, initialize the database.
6. Roll back up.
And in order not to suffer later within the limits of updating minor versions, then set the server to default, at least in the paths, if of course this is possible.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question