Re: [BUGS] Fail to restore index tables by pg_dumpall

2000-11-15 Thread Tom Lane
"Jessica Ord" <[EMAIL PROTECTED]> writes: > I am not sure if the 'initdb --template' command has also cleared away all > the system index tables as well. initdb --template? Why are you using that? I think that's a poorly debugged (to put it kindly) feature. I'd recommend staying away from it.

RE: [BUGS] Fail to restore index tables by pg_dumpall

2000-11-15 Thread Jessica Ord
ssible. Many many thanks. regards, Jessica > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED]] > Sent: 14 November 2000 19:03 > To: Jessica Ord > Cc: [EMAIL PROTECTED] > Subject: Re: [BUGS] Fail to restore index tables by pg_dumpall > > > "Jessica Ord&q

Re: [BUGS] Fail to restore index tables by pg_dumpall

2000-11-14 Thread Tom Lane
"Jessica Ord" <[EMAIL PROTECTED]> writes: > After that, I restored this file onto a newer version of PostgreSQL 7.0.2 by > the below command. > # psql -e template1 < db.all > However, I login to the database and I noticed that all the tables are > restored properly except all my index tables are