| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | John Gardner <john(dot)gardner(at)tagish(dot)co(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Tablespaces |
| Date: | 2007-06-04 08:53:51 |
| Message-ID: | 4663D31F.4080906@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erol KAHRAMAN | 2007-06-04 09:12:01 | simple select question |
| Previous Message | Enrico Sirola | 2007-06-04 08:53:36 | Re: [HACKERS] table partitioning pl/pgsql helpers |