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