Re: default_tablespace in 8.3 postgresql
От | Adrian Klaver |
---|---|
Тема | Re: default_tablespace in 8.3 postgresql |
Дата | |
Msg-id | 7174210f-991c-3f9c-c4b6-86c9a1325569@aklaver.com обсуждение исходный текст |
Ответ на | Re: default_tablespace in 8.3 postgresql (Julie Nishimura <juliezain@hotmail.com>) |
Ответы |
Re: default_tablespace in 8.3 postgresql
(Julie Nishimura <juliezain@hotmail.com>)
|
Список | pgsql-general |
On 5/15/19 3:01 PM, Julie Nishimura wrote: > 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... One is from the postgresql.conf setting(vol3). The other is from the database default_tablespace setting. > > > > > ------------------------------------------------------------------------ > *From:* Adrian Klaver <adrian.klaver@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.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 -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: