[GENERAL] How to store data on an external drive

2009-09-07 Thread Jia Chen
Hi there, As a beginner of PostgreSQL, I installed PostgreSQL 8.3.7 on Ubuntu 9.04 by using sudo apt-get install. Now, I want to store PostgreSQL data on an external drive because I work both on my office machine and on my home machine a lot. This way, I can always bring my external drive t

Re: [GENERAL] How to store data on an external drive

2009-09-07 Thread Jia Chen
Hi Martin, Thanks for reply. However, your answer confuses me. your tables are probably not using the new default tablespace SET default_tablespace = new_tablespace_name any new tables will be placed into new default tablespace by inserting TABLESPACE clause This is what I did: I created t