tablespace - datafile location
От | Birchall, Austen |
---|---|
Тема | tablespace - datafile location |
Дата | |
Msg-id | 4E154FB60786D74BB4DFDC97BF991CAC08A92C@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk обсуждение исходный текст |
Ответ на | Running psql commands from a remote location & pg_hba.conf? ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>) |
Ответы |
Re: tablespace - datafile location
|
Список | pgsql-novice |
9.2 on Red Hat 6 Up to now I have been creating the sub-directories that (hold) the OS level files that are associated with individual tablespacesdirectly under the ..../psql/data directory i.e. db=# create tablespace test owner test_admin location '/var/lib/pgsql/data/test'; Is this standard/best practise - I can see that the data directory could get 'cluttered' in a db that has many tablespaces. Is there a standard/recommended alternative for tablespace location for db which have many tablespaces? Thanks in advance as always Austen Austen Birchall Senior Database Administrator Met Office
В списке pgsql-novice по дате отправления: