Thank you Bruce.
Really, what I would want to know is how PostgreSQL assigns a physical name to files what represent the database objects. I noticed that if I lose a file of the database, the pg_restore program does not recover it, giving an error because the associated table exists on the database. On the other hand I can't drop the table because an error occurs: the file or directory does not exist. How I can to solve this problem ? Regards, Fabio Bon -----Mensaje original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Bruce Momjian Enviado el: martes 8 de octubre de 2002 23:22 Para: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Asunto: Re: [ADMIN] Two questions. [EMAIL PROTECTED] wrote: > Hello ! > > Where I can find information, to know since one is organized the system of > files of a PostgreSQL database ? ( files of database objects ). > > If I have a " disc crash " or lose accidental one or several files, since I > can realize which lack? I wrote something up for 7.3: http://developer.postgresql.org/docs/postgres/diskusage.html -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
