Thread: Database out of sync

Database out of sync

From
M Simms
Date:
Hi.

I am having a problem

I have looked at manpages, I have gone through the mailing list
archives and faq and looked at all the documentation that exists, and
have no solution.

I am trying to create a database.

I have created it before, so I destroydb, then createdb
I have a script to create the tables, and when I try, I get the
following error:

ERROR:  amcreate: other relation already exists

This is immediately after a createdb was called.

I have tried to remove the directory from the database area, no joy. I
tried vacuum analize (someone said that may work) and it crashed the
backend. Nothing seems to fix this problem.

I have a similar problem with another database. There is a sequence
that exists, but is empty when I examine it. I cannot drop it, it just
says it is dropped, but it is still there.

I tried pg_dumpall, and that failed.

I am out of ideas. There seems to be no way to repair a broken
database, do I just have to live with this?

Thanks in advance for any ideas.

                    M Simms