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