Re: releasing space

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Julie Nishimura <juliezain(at)hotmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: releasing space
Date: 2019-10-19 23:53:34
Message-ID: 20191019235334.6surfhxnd2af4bnq@development
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Oct 19, 2019 at 04:34:32PM -0700, Adrian Klaver wrote:
>On 10/19/19 4:17 PM, Julie Nishimura wrote:
>>Thank you, Thomas. Do you know if it is safe to replicate 9.6.2
>>(smaller) db to 9.6.15 (larger capacity) using pg_basebackup? Would
>>it be considered as an upgrade?
>
>pg_basebackup backups an entire Postgres cluster which will be many
>databases. So when you say db do mean a Postgres cluster or an
>individual database?
>

My understanding is Julie wants to create a copy of a 9.6.2 cluster
using pg_basebackup and then run 9.6.15 on it. That's OK, it's
essentially a minor version upgrade.

FWIW Julie, please don't top post - it just makes it harder to follow
the discussion. Also, this seems like a completely separate question,
unrelated to the DROP DATABLASE one. It might be better to start a new
thread instead of repurposing an existing one.

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-10-20 00:21:17 Re: releasing space
Previous Message Adrian Klaver 2019-10-19 23:34:32 Re: releasing space