Thanks Aaron. No. pg_dump, psql do not "see" those files. As I said, psql -l shows "nothing". pg_dumpall outputs nothing. strings 3476895975 for example, does show a lot of text, some of them seem to be actual data that I am interested in extracting. If I create a new db and create new tables in the new db, then they work as usual. --- Aaron Bono <postgresql@xxxxxxxxxx> wrote: > On 7/22/06, Shen, Mingzuo <mshen@xxxxxxx> wrote: > > > > Hello, > > > > I see some OS files (50+ GB total) but cannot see > anything in psql -l. > > There seem to be some big tables there. > > I wonder if there are some tools that would dump > the tables in text. > > or, how to make PostgreSQL "connect" to these > files again? > > > > You can dump the whole database contents with > pg_dump. This dumps your > whole database with data into a text file. Is this > what you mean? > > ================================================================== > Aaron Bono > Aranya Software Technologies, Inc. > http://www.aranya.com > ================================================================== >
