[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: pg_upgrade custom table locations. Move table locations during upgrade?
From:       Tory M Blue <tmblue () gmail ! com>
Date:       2020-02-27 22:45:25
Message-ID: CAEaSS0avZN3MOUbQ-fjfKCnsqcMwu59TMjVQ5ZSUSDVzCOMcLg () mail ! gmail ! com
[Download RAW message or body]

Finally found it

http://bajis-postgres.blogspot.com/2014/04/anyone-wants-to-change-tablespaces.html

Thanks
Tory

On Thu, Feb 27, 2020 at 12:40 PM Tory M Blue <tmblue@gmail.com> wrote:

> Many decades ago (small fib).
>
> There was a write up of someone stopping the postgres upgrade at a certain
> point, editing a file with the table locations and then restarting the
> upgrade process.
>
> "Now, what are you trying to do?"
>
> I have version specific directories (good for you), but...
>
> /pgsql/9.5/tablespaces
>
> I am updating to 12 and thus
>
> /pgsql/12/tablespaces (is where I would like them).
>
> Using the -link, it simples creates the PG12, files under
> /pgsql/9.5/tablespace
>
> I'd like to , even when using link, to say don't do that, but instead
> please link the Ver 12 tables to /pgsql/12/tablespaces.
>
> The information is in the file
>
> pg_upgrade_dump_globals.sql:CREATE TABLESPACE "torquespace" OWNER "cls"
> LOCATION '/pgsql/9.5/torque';
>
> but while it's there, I'd like it not to be there (and it's possible that
> I'm running into an initial design flaw and the table spaces should really
> be under /pgsql and not /pgsql/$VERSION/
>
> However is there a way to say create the new links under /pgsql/12/ vs
> /pgsql/9.5/ using the pg_upgrade process?
>
> Thanks
> Tory
>

[Attachment #3 (text/html)]

<div dir="ltr">Finally found it<div><br></div><div><a \
href="http://bajis-postgres.blogspot.com/2014/04/anyone-wants-to-change-tablespaces.ht \
ml">http://bajis-postgres.blogspot.com/2014/04/anyone-wants-to-change-tablespaces.html</a><br></div><div><br></div><div>Thanks</div><div>Tory</div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Feb 27, 2020 at 12:40 \
PM Tory M Blue &lt;<a href="mailto:tmblue@gmail.com">tmblue@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Many \
decades ago (small fib).<div><br></div><div>There was a write up of someone stopping \
the postgres upgrade at a certain point, editing a file with the table locations and \
then restarting the upgrade process.</div><div><br></div><div>&quot;Now, what are you \
trying to do?&quot;</div><div><br></div><div>I have version specific directories \
(good for you), but...</div><div><br></div><div>/pgsql/9.5/tablespaces</div><div><br></div><div>I \
am updating to 12 and thus</div><div><br></div><div>/pgsql/12/tablespaces (is where I \
would like them).</div><div><br></div><div>Using the -link, it simples creates the \
PG12, files under /pgsql/9.5/tablespace</div><div><br></div><div>I&#39;d like to , \
even when using link, to say don&#39;t do that, but instead please link the Ver 12 \
tables to /pgsql/12/tablespaces.</div><div><br></div><div>The information is in the \
file  </div><div><br></div><div>pg_upgrade_dump_globals.sql:CREATE TABLESPACE \
&quot;torquespace&quot; OWNER &quot;cls&quot; LOCATION \
&#39;/pgsql/9.5/torque&#39;;<br></div><div><br></div><div>but while it&#39;s there, \
I&#39;d like it not to be there (and it&#39;s possible  that I&#39;m running into an \
initial design flaw and the table spaces should really be under /pgsql and not \
/pgsql/$VERSION/</div><div><br></div><div>However is there a way to say create the \
new links under /pgsql/12/ vs /pgsql/9.5/ using the pg_upgrade \
process?</div><div><br></div><div>Thanks</div><div>Tory</div></div> \
</blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread]