Basically you just use pg_dumpall as the database superuser. (See the
manual). Then you uninstall the postgresql installation and install the
new version (it's make clean with source, not sure what the command is
with rpms). Then you start up psql as the superuser with the new
version and use the command:
$psql -f whatever.you.named.the.pg_dumpall.file
Installing via source isn't that hard. You just need to remember to
read the INSTALL file. :-D
-Dan
On Sun, 2003-03-30 at 23:28, Richard Welty wrote:
> anyone have any recommendations on upgrading postgresql on a redhat 7.1
> system?
>
> there are no redhat 7.1 rpms for postgresql 7.2 or 7.3. the 7.3 rpms
> require a newer version of openssl, and that wants to drag in all kinds of
> stuff.
>
> it's an operational box, i am reluctant to take too many risks, but
> there's nothing operational dependent on postgresql right now, so i can
> take some risks there. anyone got a method that works?
>
> note that when i eventually upgrade the redhat installation on this box, i
> would like to go back to rpm installs if i have to get away from that now.
>
> thanks,
> richard
> --
> Richard Welty rwelty@averillpark.net
> Averill Park Networking 518-573-7592
> Unix, Linux, IP Network Engineering, Security
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
