Here is what I would do:
locate all Postgresql binaries. I suppose it's in /usr/bin
dump _all_ your data (maybe stopping the postmaster and making a filesystem backup is the most certain way to do this)
download postgres sources and 7.2.5 rpm
shutdown the postmaster
upgrade to 7.2.5 by rpm
start postmaster
dump _all_ your data if succesfull
look for any other configuration files and store them separately (there may be something in /etc and /etc/rc.d ...)
unpack 7.4 sources
./configure --help to see all the flags you can set
./configure <all your needed flags>
if succesfull: make
if succesfull: stop postmaster
uninstall postgres 7.2.5 with rpm
make install the sources
initdb
start postmaster
restore your data
check all config files and see if they're still the same, check /etc/rc.d startup stuff too (I honestly must say I have no idea how this is really implemented)
enjoy!
Mind: you can also do the following starting from the ./configure part, all that was to be done previously still applies:
stop postmaster
uninstall postgres 7.2.5 with rpm
./configure --with-all-your-flags && make && make install && initdb -D <bladidbla>
(make will only run if configure was succesfull, make install will only run when make was succesfull and so on)
If this is a first-timer, try this out on a non-critical system where everything may fail! If it's not a first-timer you might still want to do that, since one easily forgets a flag or two or makes a slight mistake.
Storing all your commands in a shell-script makes it easier to do exactly the same stuff on another machine...
Hope it helps...
Michiel
scott.marlowe wrote:
On Thu, 4 Mar 2004, Indibil wrote:
Hi:
I have a PostgreSQL 7.2.2 running in a Linux Mandrake 8.2 Server.
I want to upgrade to PostgreSQL 7.3
I would like to accomplish this by installing fit rpm packages, because my
linux skills are limited.
However, there aren't any packages of PostgreSQL 7.3 for Mandrake 8.2
I must be careful because the database is in a production environment.
What would be the best way to upgrade?
Unless there is a known problem for you with 7.4, I'd recommend upgrading to that. 7.4.2 is due out soon (today or something like it) and it is a much easier upgrade than 7.2 to 7.3 was.
You might want to upgrade to 7.2.5 first though, as there were some issues with early 7.2s upgrading to 7.4 I remember running into.
I don';t use RPMs for postgresql, so I'm not much help there.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
