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-15 15:40:01
Message-ID: 13212.974302801@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Jessica Ord" <jo(at)uk(dot)xo(dot)com> 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.  Assuming that you are careful not to put any user data into
template1, there is no reason ever to reinitialize template1 after the
initial initdb.

At this point I think you may have to do a full initdb to get back into
a good state.  If you have backups of everything, that seems like the
way to go rather than trying to dig your way out of the hole bit by bit.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2000-11-15 17:45:08
Subject: WHERE-clause evaluation order (was Problem with BETWEEN and a view)
Previous:From: netad24Date: 2000-11-15 14:19:14
Subject: aktuelle Viruswarnung - BITTE BEACHTEN

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