Re: Upgrading postgresql minor version

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(dot)klaver(at)aklaver(dot)com