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]