No, I did not have them at all in my script. I did not touch neither these three dbs, nor like some others that I did not intend to alter, but they are altered regardless. Or unless this is what pg_database reports back to me... What is even more interesting, if I use PGAdmin for one of the dbs that I was not intended to alter and leave it on vol3, this is what it shows to me now. Please note, it shows both - "Default tablespace" (as vol3), and "default_tablespace" (as vol4)... Hmm... [cid:45dce903-fa47-4e59-b3af-f07fa991f55b]
________________________________ From: Adrian Klaver <adrian.kla...@aklaver.com> Sent: Wednesday, May 15, 2019 2:48 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: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.kla...@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.kla...@aklaver.com -- Adrian Klaver adrian.kla...@aklaver.com
