Re: Identifying index files

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
Thread:
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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message David Rickard 2003-09-08 18:02:46 Identifying index files
Previous Message Derrick Betts 2003-09-08 16:06:30 Re: Fw: SQL Error: pqReadData() -- read() failed: errno=0 No error