Upgrading PostgreSQL postgresql92 -> postgresql93
Peter Boosten
peter at boosten.org
Mon Mar 12 10:31:56 UTC 2018
> On 12 Mar 2018, at 05:26, Victor Sudakov <vas at mpeks.tomsk.su> wrote:
>
> Dear Colleagues,
>
> Anyone using PostgreSQL, how do you upgrade it?
>
> The pg_upgrade utility is not packaged in
> postgresql93-server-9.3.22.txz or postgresql93-client-9.3.22.txz, and
> even if it were, it requires the binaries from both the old version
> and the new version to be present while the pkg system simply replaces
> postgresql92-* with postgresql93-*
>
> Anything less radical than "pg_dumpall | psql" i.e. some in-place
> procedure?
>
>
Hi Victor,
I searched (and found) some procedure, which was basically this:
-Package the current postgresql and install that in /tmp
-rename the current data directory
-delete current packages and install new ones
-initdb new database
-use some command to ‘copy’ (not cp ;) ) to transport old data to new
I don’t have the url currently available, but it wasn’t that hard to find either.
Peter
More information about the freebsd-questions
mailing list