On 08/02/2011 07:13 AM, Douglas Hubler wrote:
> On Tue, Aug 2, 2011 at 9:56 AM, jnolen <[email protected]> wrote:
>> I have the following error on a version 4.2.1-18890.6.1 system:
>> psql: FATAL: database is not accepting commands to avoid wraparound
>> data loss in database "postgres"
>> HINT: Stop the postmaster and use a standalone backend to vacuum
>> database "postgres".
>> Can someone provide a specific procedure for sipxecs?
> but I'm not sure this will help you start postgres, but it might help
> to avoid the problem in the future.
>
> So my question is : what does the message means?
> "stop the postmaster and use a standalone backend to vacuum
> database "postgres"."
Wraparound is a situation which will cause data loss if not attended to
-- therefore when the situation becomes dire the database stubbornly
refuses to run until you correct it. In short, every table in every
database needs to be vacuumed at least once every 2 billion transactions
to prevent wraparound failure.
sipxecs is using the default PostgreSQL for CentOS 5.x which is by now
so old it isn't even supported by the Postgres community. There have
been huge improvements in autovacuum and the handling of wraparound
between pg 8.1 and the current (pg 9.0) version.
The procedure for a standalone backend is shown on the man page for
postgres:
To start a single-user mode server, use a command like
postgres -D /usr/local/pgsql/data other-options my_database
So, the following should work on a default sipxecs install:
postgres -D /var/lib/pgsql/data postgres
vacuum
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
_______________________________________________
sipx-users mailing list
[email protected]
List Archive: http://list.sipfoundry.org/archive/sipx-users/
