Thread: Identifying index files

Identifying index files

From
David Rickard
Date:
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.Rickard@GTSCompanies.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]

Re: Identifying index files

From
Bruce Momjian
Date:
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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073