How do you correctly move a tablespace?
I am thinking this would be the process:
1. Cleanly shutdown Postgres
2. Move tablespace directory and all contents to new location
3. Create a symlink from the new location back to the old location
4. Restart Postgres
Would that be correct? Or is there a better way.
pgsql-admin by date
|Next:||From: Robert Treat||Date: 2007-06-23 04:29:42|
|Subject: Re: How to move a tablespace?|
|Previous:||From: Erik Jones||Date: 2007-06-22 17:24:50|
|Subject: Re: [GENERAL] Can I backup/restore a database in a sql script?|