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@xxxxxxxxxxx>
*Sent:* Wednesday, May 15, 2019 2:18 PM
*To:* Julie Nishimura; David G. Johnston
*Cc:* pgsql-general@xxxxxxxxxxxxxxxxxxxx
*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@xxxxxxxxxxx
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
