| Lists: | pgsql-novice |
|---|
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | David Rickard <David(dot)Rickard(at)GTScompanies(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org, Judith Strawser <judiths(at)GTScompanies(dot)com> |
| Subject: | Re: Identifying index files |
| Date: | 2003-09-08 17:41:19 |
| Message-ID: | 200309081741.h88HfJn06546@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
David Rickard wrote:
> We're building a PostGreSQL 7.3.4 system; we want to place database index
> files on an external drive (for security and backup robustness); we have
> seen in the documentation that is is possible to move the index files to a
> new directory (after they are created) and making symbolic links to their
> new location. Our problem is distinguishing the index files from data
> files; does PostGreSQL have a naming convention for the index files? Or
> is there any particular content we could grep for to identify these files?
See the manual section on "Managing Disk Space".
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From: | David Rickard <David(dot)Rickard(at)GTScompanies(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Cc: | Judith Strawser <judiths(at)GTScompanies(dot)com> |
| Subject: | Identifying index files |
| Date: | 2003-09-08 18:02:46 |
| Message-ID: | 5.2.1.1.0.20030908105409.00ab4b60@mail.gtscompanies.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
We're building a PostGreSQL 7.3.4 system; we want to place database index
files on an external drive (for security and backup robustness); we have
seen in the documentation that is is possible to move the index files to a
new directory (after they are created) and making symbolic links to their
new location. Our problem is distinguishing the index files from data
files; does PostGreSQL have a naming convention for the index files? Or
is there any particular content we could grep for to identify these files?
--
David Rickard
Software Engineer
The GTS Companies
A TechBooks Company
----------------------------------------------------------------------------------
The GTS Companies:
GTS Publishing Services, GTS Graphics, GTS Innova:
Your Single-Source Solution!
Los Angeles CA * York, PA * Boston MA * New Delhi, India
----------------------------------------------------------------------------------
David(dot)Rickard(at)GTSCompanies(dot)com
Visit us on the World Wide Web
http://www.gtscompanies.com
5650 Jillson St., Los Angeles, CA 90040
(323) 888-8889 x331
(323) 888-1849 [fax]