agora inbox for pgsql-admin@postgresql.org  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Stepan Neretin <sncfmgg@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: SubTablespaces(Recursive) expected behaviour?
Date: Sun, 28 Jul 2024 12:10:10 -0400
Message-ID: <2253443.1722183010@sss.pgh.pa.us> (raw)
In-Reply-To: <CAKFQuwaCugbGWf35=TGJJqbSybjfD8DW2PWcZva1grAN1kv+Ow@mail.gmail.com>
References: <CAN-sa+COZ3g6QrQKE_BaVTvTXa8WjMYdJPQZXR6oj3z9NJYMZQ@mail.gmail.com>
	<CAKFQuwazpwNRG4XJYGzzzrCwfYXMFrJAwijW3HMxv63Medf0fQ@mail.gmail.com>
	<CAN-sa+B4o_Jpimxfa09SmBZQTpjdRGjtvV=-ip=WRGEikAB5Zg@mail.gmail.com>
	<CAKFQuwaCugbGWf35=TGJJqbSybjfD8DW2PWcZva1grAN1kv+Ow@mail.gmail.com>

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Sunday, July 28, 2024, Stepan Neretin <sncfmgg@gmail.com> wrote:
>> Hi, David. I have read this page several times and have not answered my
>> question. I'm probably not paying attention. Can you, I wanted to quote
>> what I'm missing out on

>  “The location must be an existing, empty directory that is owned by the
> PostgreSQL operating system user.”

Indeed, that doesn't directly answer the question, but I think the
implication is clear: we do not expect a tablespace directory to
contain anything except files that Postgres itself puts there.

I don't actually see the point of the described setup anyway.  There
is zero value that I can see in putting two tablespaces on the same
physical volume --- they won't provide any interesting separation.

			regards, tom lane

view thread (6+ messages)  latest in thread

Message-ID: <2253443.1722183010@sss.pgh.pa.us>
Permalink:  ../2253443.1722183010@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/2253443.1722183010@sss.pgh.pa.us

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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, david.g.johnston@gmail.com, sncfmgg@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: SubTablespaces(Recursive) expected behaviour?
  In-Reply-To: <2253443.1722183010@sss.pgh.pa.us>

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

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