Then again, dumping is probably better, and deleting the database, and
then restoring it.
I am just curious if it is a database problem or a table problem.
If you can creat new tables that work fine, but it is a strange issue.
Mark
>
> 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
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>