Hi Dave, Excerpts from Dave Cramer's message of lun oct 18 12:23:40 -0300 2010: > as seen below create tablespace does not throw an error or appear to > do anything other than register the tablespace. > > postg...@db01:~> less /opt/pg/data/jnj_indexes/PG_VERSION > 8.4 > postg...@db01:~> /opt/pg91/bin/psql -p 5433 > psql (9.0.1) > Type "help" for help. > > postgres=# select version(); > version > ------------------------------------------------------------------------------------------------------------------- > PostgreSQL 9.0.1 on x86_64-unknown-linux-gnu, compiled by GCC gcc > (GCC) 3.4.6 20060404 (Red Hat 3.4.6-11), 64-bit > (1 row) > > postgres=# create TABLESPACE jnj_indexes location '/opt/pg/data/jnj_indexes'; > CREATE TABLESPACE
IIRC the reason this works is that the tablespace code now creates a version-specific subdirectory inside the specified directory. This was done to help binary upgrades. -- Álvaro Herrera <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
