Re: default_tablespace in 8.3 postgresql

On 5/15/19 2:45 PM, Julie Nishimura wrote:
> Adrian, only first 3 (which are template0, postgres, control). Rest of 
> them are set to vol4.

Do the script(s) reflect this?

In other words did you have a script for each and every database and was 
the default_tablespace set different in some of them?

> 
> The only explanation I would have that all of those databases which have 
> tablespace vol4 as default were copied from template1 without explicitly 
> specified tablespace name, and "control" was created with the explicit 
> tablespace in it?... I dont have any other good explanations...
> 
> ------------------------------------------------------------------------
> *From:* Adrian Klaver <adrian.klaver@aklaver.com>
> *Sent:* Wednesday, May 15, 2019 2:18 PM
> *To:* Julie Nishimura; David G. Johnston
> *Cc:* pgsql-general@lists.postgresql.org
> *Subject:* Re: default_tablespace in 8.3 postgresql
> On 5/15/19 2:15 PM, Julie Nishimura wrote:
>> Sure, thank you guys!
>> 
>> CREATE TABLESPACE vol4
>>   OWNER postgres
>>   LOCATION '/data/vol4';
>> 
>> ALTER DATABASE tables_ericb
>> SET default_tablespace = 'vol4';
>>   ALTER DATABASE conversion_feasibility_too
>>   SET default_tablespace = 'vol4';
>> 
>> ... and so on for 60 dbs...
>> 
>> but not for all 70+
> 
> But it was not for all 70+. The control db still is still set at vol1.
> 
> Are there others not set to vol4?
> 
> 
> -- 
> Adrian Klaver
> adrian.klaver@aklaver.com


-- 
Adrian Klaver
adrian.klaver@aklaver.com