On 05/10/2017 06:08 AM, Ron Ben wrote:
I'm about to upgrade my postgresql to the latest 9.3 version
On my test server eveything works.
However I want to save a backup of my production server before the
upgrade...
I'm not sure how I do that.
https://www.postgresql.org/docs/9.3/static/app-pg-dumpall.html
It says that only system files are changed during upgrade... which
folders exactly I need to save on the side for roll back?
I would say that would depend on the nature of the release changes.
I know I can take a snap shoot of my server before the update but i'm
affried that rolling back to this snap shoot will also roll back the
data itself?
Since after the update the users continue to work I don't want to lose
thier data.
Well if the upgrade takes then you don't need to rollback. If it did not
then the users did not get any work done or any data they entered would
be considered suspect. If you are concerned then take another pg_dumpall
before rolling back.
How do I do that?
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
