Re: [GENERAL] [asking about how to upgrade docker postgresql withoutlosing the data] - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] [asking about how to upgrade docker postgresql withoutlosing the data]
Date
Msg-id CAKFQuwb9Vq+krDUJ3_xn4oyCV-pWvZuN8kGj5BHG=5O2cSeSAA@mail.gmail.com
Whole thread Raw
In response to [GENERAL] [asking about how to upgrade docker postgresql without losing the data]  (Olivani Prisila <olivaniph@gmail.com>)
List pgsql-general
On Tue, Oct 10, 2017 at 4:25 AM, Olivani Prisila <olivaniph@gmail.com> wrote:
Hi,

I am beginner both of docker and postgresql.

How do i upgrade docker postgresql 9.5 into 9.6 without losing my
current database?
fyi: im using ubuntu verison 14 and docker 17.09

​More of a Docker forum question than PostgreSQL.  It depends on whether you setup a distinct data container and/or mounted a host location into the container to store the data.  In that case you should be able to link that external dependency into the new runtime container in the same manner as it is linked into the existing one.

If the data is directly within the runtime container it will be considerably more difficult - though pg_dump/pg_restore might prove easiest to accomplish.

David J.

pgsql-general by date:

Previous
From: Vladimir Nicolici
Date:
Subject: Re: [GENERAL] Strange checkpoint behavior - checkpoints takealongtime
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] startup process stuck in recovery