pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Justin Clift <justin@postgresql.org>
To: pgsql-general@lists.postgresql.org
Subject: Re: PG minor version in data directory?
Date: Sun, 20 Aug 2023 04:04:20 +1000
Message-ID: <8653547ab62b71545f3ad87015877bbc@postgresql.org> (raw)
In-Reply-To: <20230819091422.ivqyk22fmiu7folp@hjp.at>
References: <d8bb494a0c3763309dfdfa5be41de37d@postgresql.org>
	<CAKFQuwYR_SFtiL3GJSPPotXBBNm=mGfBXzCkeGtCrxOYn4nmEQ@mail.gmail.com>
	<f166fe43501f1c9e08298ee6ba78e4a7@postgresql.org>
	<20230819091422.ivqyk22fmiu7folp@hjp.at>

On 2023-08-19 19:14, Peter J. Holzer wrote:
> On 2023-08-19 14:22:25 +1000, Justin Clift wrote:
<snip>
>> Thanks, that's what I figured.  I'll have to keep state in a
>> PG_VERSION_MINOR
>> there or something. :)
> 
> Wouldn't it be better to ask whatever system you use to install the
> software for the version?

In the general sense, yes. :)

For the very specific use case I'm working with (!), things are a bit
different.  It's for this, if that helps with context:

   * https://github.com/pgautoupgrade/docker-pgautoupgrade
   * https://hub.docker.com/r/pgautoupgrade/pgautoupgrade  <-- docker 
repo

It's a docker container that people use for running PostgreSQL, but
also has the ability to (automatically) upgrade the data files from
older versions.  That's the piece I'm working on.

Such a thing is useful for people that need a PG docker container,
and whose needs are fairly simple.  They can use point at this one,
and they'll have a self-upgrading PG version that's fairly "fire and
forget".

Thus far (1 month in), it seems to work ok (for us) and some other
people.

Am obviously looking to improve its capabilities over time too. :)

+ Justin





view thread (5+ messages)

Message-ID: <8653547ab62b71545f3ad87015877bbc@postgresql.org>
Permalink:  ../8653547ab62b71545f3ad87015877bbc@postgresql.org/
Also on:    postgresql.org/message-id/8653547ab62b71545f3ad87015877bbc@postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: justin@postgresql.org
  Subject: Re: PG minor version in data directory?
  In-Reply-To: <8653547ab62b71545f3ad87015877bbc@postgresql.org>
  References: <d8bb494a0c3763309dfdfa5be41de37d@postgresql.org> <CAKFQuwYR_SFtiL3GJSPPotXBBNm=mGfBXzCkeGtCrxOYn4nmEQ@mail.gmail.com> <f166fe43501f1c9e08298ee6ba78e4a7@postgresql.org> <20230819091422.ivqyk22fmiu7folp@hjp.at> <8653547ab62b71545f3ad87015877bbc@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox