On 14/09/2010 11:02 AM, 夏武 wrote:
> I reconvery it by \copy command.
> thanks very much.
Glad to help.
In future, it might be a good idea to:
- Keep regular pg_dump backups; and
- Avoid trying to alter the system catalogs
With Slony you can never completely avoid needing to mess with the
catalogs, as it seems to be able to get things into a nasty state
sometimes. However, if you do have to do catalog work it's a good idea
to ask for help here *before* doing anything, because it'll be easier to
fix if you haven't deleted catalog entries etc.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/