Re: Fail to restore index tables by pg_dumpall - Mailing list pgsql-bugs

"Jessica Ord" <jo@uk.xo.com> 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 missing.

> I then scrutinized the file generated by the pg_dumpall.  For example, the
> following statement is found in the file but it didn't seem to create the
> 'status_index' table.

> CREATE  INDEX "status_index" on "ribs_log" using btree ( "status"
> "int4_ops" );

The only theory I can come up with is that the restore script failed
before it got as far as the CREATE INDEX commands.  Did you look for
any error messages that might've come out of the psql run?

            regards, tom lane