I would create new tables, copy the data over, then drop the old tables,
and rename the new tables.
I have had similar problems iwht MySQL, but never with PostgreSQL.
Mark
>
> Hi,
>
> I have been using PostgreSQL 7.2.2 for a while now on one of our live
> machines, however all of a sudden with no warning, we are no longer able to
> run any UPDATE statements on one of our databases. SELECT and INSERT
> statements have no issues.
>
> The error we are getting is:
> "The backend has broken the connection. Possibly the action you have
> attempted has caused it to close."
> Immediately after this call the database system restarts itself.
>
> We are using:
> Red Hat Linux
> Apache 1.3.26
> PostgreSQL 7.2.2
> Java 1.4 + the latest PostgreSQL jdbc driver from jdbc.postgresql.org
>
> Configuration:
> We are running postmaster -i listening on localhost only.
>
> We have 3 PostgreSQL databases on the same machine, and the other two have
> no problems at all (yet). They are all using the same software mentioned
> above.
>
> Things i have tried:
> Restarting JVM and Apache (problem still occurs)
> Restarting postmaster -i (problem still occurs)
> Vaccuming all databases (problem still occurs)
> Rebooting entire machine (problem still occurs)
> Dropping the database and creating another (worked for a while, but after
> processing SQL calls for about a day and a half the problem started up
> again)
>
> Is there anything i can do to fix this? Has anyone else seen this before?
> We need our database system back up and running ASAP.
>
> Regards,
>
> Brendon Matthews
> Analyst Programmer
> BBTech Ltd
> Ph: (03) 381 1127
> Fax: (03) 381 1185
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>