| From: | David Johnston <polobo(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: wrong database name in error message? |
| Date: | 2013-09-14 02:25:15 |
| Message-ID: | 1379125515329-5770822.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Rural Hunter wrote
> I'm on 9.2.4 and I have several databases on the instance say db1, db2,
> db2 etc. Today I got this error message on connection of any of the
> databases:
> ERROR: database is not accepting commands to avoid wraparound data loss
> in database "db1"
> Suggestion：Stop the postmaster and use a standalone backend to
> vacuum that database.
>
> The error messages says problem is on db1 when I connected to any
> database. But after I did vacuum full on some other databases such as db2,
> db2, but not db1, the problem disappeared.
> Was that just a wrong database name in the error message?
Likely auto-vacuum kicked in and took care of the wraparound issue while the
system was handling your manual vacuum routines...but that is just a theory
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/wrong-database-name-in-error-message-tp5770815p5770822.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rural Hunter | 2013-09-14 03:53:41 | Re: wrong database name in error message? |
| Previous Message | Rural Hunter | 2013-09-14 01:23:28 | wrong database name in error message? |