> 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.
You can create it wherever you want as long as the database server has
permissions to access it.
You'll have to specify the full path in the CREATE TABLESPACE statement.
Are you sure that you need a tablespace at all?
Yours,
Laurenz Albe