Skip site navigation (1) Skip section navigation (2)

Re: Fail to restore index tables by pg_dumpall

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jessica Ord" <jo(at)uk(dot)xo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Fail to restore index tables by pg_dumpall
Date: 2000-11-14 19:03:20
Message-ID: 6034.974228600@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Jessica Ord" <jo(at)uk(dot)xo(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: Vadim I. PassynkovDate: 2000-11-14 22:24:58
Subject: Problem with RULE system with condition between 3 tables.
Previous:From: Jessica OrdDate: 2000-11-14 17:46:59
Subject: Fail to restore index tables by pg_dumpall

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group