Re: finding file names - Mailing list pgsql-admin

From omid omoomi
Subject Re: finding file names
Date
Msg-id F8bnCndg5oQJgAGeU7500000962@hotmail.com
Whole thread Raw
In response to finding file names  (s.chava@wcom.com (Srinivasa Rao Chava))
List pgsql-admin
At the moment I am using an old PG version on my machine. and it shows all
the file names by their real name under :
/usr/local/psql/data/base/mydatabasename/

Having pgdump or copy commands, why one might need to know the relation
between the numbers and the names at all? Data base recovery or data backup
process or... ?

>From: Srinivasa R Chava <s.chava@wcom.com>
>To: omid omoomi <oomoomi@hotmail.com>
>Subject: Re: [ADMIN] finding file names
>Date: Thu, 17 Jan 2002 08:51:43 -0600
>
>hi,
>My question is not how to copy a text file into  a table or
>moving data from table to text file.
>The postgresql database file will be located in PGDATA     directory
>and they are in numbered, not named. and their  directory is also
>numbered like 1820. under 1820, there are several data file.
>How to know which data file belong to which object.
>Thanks
>chava
>--
>
>Srinivasa R Chava (Chava) <s.chava@wcom.com>
>  - Boss: Sean T Laduderdale <sean.lauderdale@wcom.com>
>vnet4603575
>Application Developer
>Corporate Intra/Internet Systems
>WORLDCOM - http://www.worldcom.com/ - NASDAQ:WCOM
>500 Clinton Center Drive (Corporate Headquarters)
>Clinton, Mississippi (MS) USA  39056
>(601)460-3122 / vnet4603122 / (800)844-1009 / FAX(601)460-8257




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com


pgsql-admin by date:

Previous
From: "omid omoomi"
Date:
Subject: Re: finding file names
Next
From: Tom Lane
Date:
Subject: Re: CREATE OR REPLACE VIEW / TRIGGER