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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-11-15 17:45:08 | WHERE-clause evaluation order (was Problem with BETWEEN and a view) |
Previous Message | netad24 | 2000-11-15 14:19:14 | aktuelle Viruswarnung - BITTE BEACHTEN |