Skip site navigation (1) Skip section navigation (2)

Re: postgres 8.2.9 transaction id wraparound failure

From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
To: Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, "Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS APPLICATIONS]" <m(dot)l(dot)wilson(at)nasa(dot)gov>, "jd(at)commandprompt(dot)com" <jd(at)commandprompt(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: postgres 8.2.9 transaction id wraparound failure
Date: 2009-04-20 18:55:12
Message-ID: 3073cc9b0904201155k2e78b2e0p8d6751eef87e4781@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Mon, Apr 20, 2009 at 1:43 PM, Maria L. Wilson
<Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov> wrote:
> ouch!!  ok - this may take me all week!
> i'm opening each database when I start up the server ( postgres --single -D
> /data/pg_devices /database1/ )

is database1 the directory where you initialized the server?

> i run the vacuum - just a plain old vacuum - nothing else...
> i am getting output like this with each vacuum...
>
> backend> [postgres(at)n116 ~]$ postgres --single -D /data/pg_devices n015ecs

can't understand this one... you have initialized several directories?
so you have variuos instances of postgresql running? if so, you only
have to vacuum the one that is giving you troubles...

> vacuum;

you execute this inside psql... rigth?

-- 
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

In response to

pgsql-admin by date

Next:From: Scott MarloweDate: 2009-04-20 18:55:24
Subject: Re: postgres 8.2.9 transaction id wraparound failure
Previous:From: Maria L. WilsonDate: 2009-04-20 18:43:23
Subject: Re: postgres 8.2.9 transaction id wraparound failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group