Re: Tablespaces

John Gardner wrote:
> I've been testing one of our apps on PostgreSQL for the last few months
> and I'm about ready to put it on the production server, but I need
> advice on where to locate the tablespace.  I've been so concerned
> getting the app working, I haven't even considered this yet.
>
> I'm using a RPM install of Postgres, so the data directory is located at
> /var/lib/pgsql/data/.  Shall I just create a directory under here and
> point the tablespace to there?  Any advice would be appreciated.

If you're not going to be spreading your installation over multiple
disks (well, mount-points), there's no need to play with tablespaces at all.

--
   Richard Huxton
   Archonet Ltd