Re: finding file names

From: "omid omoomi" <oomoomi(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: finding file names
Date: 2002-01-17 15:21:33
Message-ID: F8bnCndg5oQJgAGeU7500000962@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)chava(at)wcom(dot)com>
>To: omid omoomi <oomoomi(at)hotmail(dot)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(dot)chava(at)wcom(dot)com>
> - Boss: Sean T Laduderdale <sean(dot)lauderdale(at)wcom(dot)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

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-01-17 15:33:24 Re: [ADMIN] CREATE OR REPLACE VIEW / TRIGGER
Previous Message Jan Wieck 2002-01-17 15:04:26 Re: [HACKERS] CREATE OR REPLACE VIEW / TRIGGER