sounds like time to resurrect: http://track.sipfoundry.org/browse/XX-9067
On Tue, Aug 2, 2011 at 1:09 PM, Joe Conway <[email protected]> wrote: > 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/ > -- ====================== Tony Graziano, Manager Telephone: 434.984.8430 sip: [email protected] Fax: 434.326.5325 Email: [email protected] LAN/Telephony/Security and Control Systems Helpdesk: Telephone: 434.984.8426 sip: [email protected] Helpdesk Contract Customers: http://support.myitdepartment.net <http://support.myitdepartment.net>Blog: http://blog.myitdepartment.net Linked-In Profile: http://www.linkedin.com/pub/tony-graziano/14/4a6/7a4 Ask about our voip fax services!
_______________________________________________ sipx-users mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-users/
