pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: David Steele <david@pgmasters.net>
To: Andres Freund <andres@anarazel.de>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: Stephen Frost <sfrost@snowman.net>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: tablespaces inside $PGDATA considered harmful
Date: Thu, 23 Apr 2015 16:42:23 -0400
Message-ID: <5539592F.1020909@pgmasters.net> (raw)
In-Reply-To: <20150423203040.GN3055@alap3.anarazel.de>
References: <WM!43fd2162c8c08343aade3fbea02e9c2844064c7f40cf603f5080ab78b7a3fbf2728d833090982f0743f5367f06e5a45b!@asav-2.01.com>
	<54CBD519.8030502@agliodbs.com>
	<WM!eb076638a020a207a4a7725ea9d3d99d976a0bfbbd2697fb45c5ea8dd966ae07a6f89f0fffaf4a7cd23e49aaf7416845!@asav-3.01.com>
	<54CBF6FE.8030209@agliodbs.com>
	<20150423024102.GJ13362@momjian.us>
	<CA+TgmoZiCt5=4TRvLofhKWLkxphgsyPAGWueFn1bSgt+m9CzKQ@mail.gmail.com>
	<20150423150043.GA17899@momjian.us>
	<CA+TgmoaEqZJAqPqa-snZWTy9=cOui5AJgaVDBpBDLk2+Za-KAw@mail.gmail.com>
	<20150423195742.GK3055@alap3.anarazel.de>
	<CA+Tgmob+5jCELs_mb=fFHBHJJhOaE=gTkU-6Cr0rvcUrvXpnDQ@mail.gmail.com>
	<20150423203040.GN3055@alap3.anarazel.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

On 4/23/15 4:30 PM, Andres Freund wrote:
> On 2015-04-23 16:26:09 -0400, Robert Haas wrote:
>> But pg_upgrade automates all that, so you can't use pg_upgrade in that
>> case.  If we add a GUC as I suggested, you can still use pg_upgrade.
> 
> But we also have to live with data directories being in a shit state
> forever onward. We won't really be able to remove the option
> realistically.
> 
> It's not that hard to just move the tablespace out of the data directory
> while the server. As long as you move it on the same partition, it's
> even fast.

I agree.  It wouldn't be that hard to do a bit of directory manipulation
before upgrading - and that's only for the people who have put
tablespaces in $PGDATA.  I've never seen it before, but I have no doubt
that it happens.  I can see how it might make a weird sort of sense
depending on the level of experience.

-- 
- David Steele
david@pgmasters.net

Attachments:

  signature.asc (application/pgp-signature, 818B) download

view thread (29+ messages)  latest in thread

Message-ID: <5539592F.1020909@pgmasters.net>
Permalink:  ../5539592F.1020909@pgmasters.net/
Also on:    postgresql.org/message-id/5539592F.1020909@pgmasters.net

 · 

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-hackers@postgresql.org
  Cc: david@pgmasters.net, andres@anarazel.de, robertmhaas@gmail.com, bruce@momjian.us, josh@agliodbs.com, sfrost@snowman.net
  Subject: Re: tablespaces inside $PGDATA considered harmful
  In-Reply-To: <5539592F.1020909@pgmasters.net>

* 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