Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dpcPH-00040q-Qd for pgsql-admin@arkaria.postgresql.org; Wed, 06 Sep 2017 15:38:24 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dpcPH-0000bI-Cx for pgsql-admin@arkaria.postgresql.org; Wed, 06 Sep 2017 15:38:23 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dpcP4-0008BQ-9s for pgsql-admin@postgresql.org; Wed, 06 Sep 2017 15:38:10 +0000 Received: from resqmta-ch2-06v.sys.comcast.net ([2001:558:fe21:29:69:252:207:38]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dpcOz-0007Jl-86 for pgsql-admin@postgresql.org; Wed, 06 Sep 2017 15:38:09 +0000 Received: from resomta-ch2-19v.sys.comcast.net ([69.252.207.115]) by resqmta-ch2-06v.sys.comcast.net with ESMTP id pcNIdksvDp6YqpcOwdfbgB; Wed, 06 Sep 2017 15:38:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=q20161114; t=1504712282; bh=8xz/v6vMxOfDmK6Z2TN1lDLiIa8eMzBlTLmiMYmxg1A=; h=Received:Received:Received:From:To:Subject:Date:Message-ID: MIME-Version:Content-Type; b=fIsLAqnWosEA/k79WgyyMaXSk3KSJGOLNoSUAe3q6bYHFkvxN8Xi6av5vqBaFsS5o br6S+xbKdQH7dImSf4ul1HA68NGhpg5et3J6b900Kg0Xnh+PhTJvl4wll3yzZjIAcH ASGJ/+QtjnlBRa6usv2zoRVC+iDhZOzSEvvfGit6ZQCDnYUN51TOJAykaQrtFG5dSD K05iElX/HG0EWSvXuuyuiHwNDBSZ9nF/yk8qjyOUMAQUzDxFNjYNKvQJ3y2Y6laZgZ EyzDhQ7UssNeJsv1WmyPXKHKcdHDX7gedyR2FjaUzEqBczhZ/NshrW0Uqx9e47aUT4 wded0NI3FClQg== Received: from jsievers.comcast.net ([12.187.116.132]) by resomta-ch2-19v.sys.comcast.net with SMTP id pcOld8NjkET5spcOndjH6M; Wed, 06 Sep 2017 15:38:00 +0000 Received: from jsievers.enova.com (localhost [127.0.0.1]) by jsievers.comcast.net (Postfix) with ESMTP id 3168626005E; Wed, 6 Sep 2017 10:37:51 -0500 (CDT) From: Jerry Sievers To: Carlos Augusto Machado Cc: pgsql-admin@postgresql.org Subject: Re: Problem with transaction ID wraparound References: Date: Wed, 06 Sep 2017 10:37:51 -0500 In-Reply-To: (Carlos Augusto Machado's message of "Tue, 05 Sep 2017 14:05:48 +0000") Message-ID: <878thrbzxs.fsf@jsievers.enova.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-CMAE-Envelope: MS4wfA4oKAJk9Oj9ix5rHEGVR9aJLqntXOV7bJEIlg3rmwaZbG9ecTZ0Be52s92YsYZPVqOAf42eP9187WMZu+ABpwg1rdPS6lDTZ6lduivKBrfmHlfOvGfn YJOUBeGTNB9UUyCIMVB91eJn6lZijF6VLGO5yN+AWVcqYApD3SEQN7gWezrXoO3prA2bytqwkauuIF0rCm1POb8PqC/55KHy+ofHwoo/+ff2EcDjHrpt0/1/ List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Carlos Augusto Machado writes: > Hi, > > last week I faced a problem with transaction ID wraparound, even > running VACUUM FULL or VACUUM FREEZE in single-user mode could not > solve the problem. > > Running a vacuum in single-user I got the following error message. > > 2017-08-29 10:21:24 BRT =C2=A0postgres[13610]: [4-1] user=3D,db=3D,host=3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999675 > transactions > 2017-08-29 10:21:24 BRT =C2=A0postgres[13610]: [5-1] user=3D,db=3D,host= =3D HINT: > =C2=A0To avoid a database shutdown, execute a database-wide VACUUM in that > database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > > I could identify the problem was due to a temporary table executing > the following query and verifying the relfrozenxid was 2146484102. > > SELECT c.oid::regclass as table_name, > =C2=A0 =C2=A0 =C2=A0 =C2=A0greatest(age(c.relfrozenxid),age(t.relfrozenxi= d)) as age > FROM pg_class c > LEFT JOIN pg_class t ON c.reltoastrelid =3D t.oid > WHERE c.relkind IN ('r', 'm'); > > > > > Checking the PostgreSQL documentation (https://www.postgresql.org/ > docs/9.5/static/routine-vacuuming.html) I realized auto vacuum can > not vacuum temporary tables as explained on this text. > > Temporary tables cannot be accessed by autovacuum. Therefore, > appropriate vacuum and analyze operations should be performed via > session SQL commands. > > My doubt is about temporary tables not beeing removed even stopping > the PostgreSQL service and avoiding me to run vacuum. > > Did I understood something wrong ? Or is it what was really happening > ? > > To solve the problem I rejected all connections in pg_hba.conf only > allowing local connections, did a pg_dump for this database, dropped > the database and did a pg_restore. > > That was the only way on that moment came in my mind to solve the > problem without loosing data. But this gave a 4 hours of downtime. > > There was any faster solution for this ? Yes. You could have just manually dropped those temp tables during your standalone session. HTH > > > My configuration: > > PostgreSQL 9.5.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 > 20150623 (Red Hat 4.8.5-4), 64-bit > Linux gvtsvpx-ger01 4.1.12-61.1.16.el7uek.x86_64 #2 SMP Fri Oct 21 > 14:23:20 PDT 2016 x86_64 x86_64 x86_64 GNU/Linux > > 16 CPUs > 78 GB RAM > > gerenciadora=3D# select name, setting from pg_settings where name > ~*'vacuum'; > =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 name =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | =C2=A0setting > -------------------------------------+----------- > =C2=A0autovacuum =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| on > =C2=A0autovacuum_analyze_scale_factor =C2=A0 =C2=A0 | 0.1 > =C2=A0autovacuum_analyze_threshold =C2=A0 =C2=A0 =C2=A0 =C2=A0| 50 > =C2=A0autovacuum_freeze_max_age =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | 2000= 00000 > =C2=A0autovacuum_max_workers =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0| 3 > =C2=A0autovacuum_multixact_freeze_max_age | 400000000 > =C2=A0autovacuum_naptime =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0| 60 > =C2=A0autovacuum_vacuum_cost_delay =C2=A0 =C2=A0 =C2=A0 =C2=A0| 20 > =C2=A0autovacuum_vacuum_cost_limit =C2=A0 =C2=A0 =C2=A0 =C2=A0| -1 > =C2=A0autovacuum_vacuum_scale_factor =C2=A0 =C2=A0 =C2=A0| 0.2 > =C2=A0autovacuum_vacuum_threshold =C2=A0 =C2=A0 =C2=A0 =C2=A0 | 50 > =C2=A0autovacuum_work_mem =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 | -1 > =C2=A0log_autovacuum_min_duration =C2=A0 =C2=A0 =C2=A0 =C2=A0 | -1 > =C2=A0vacuum_cost_delay =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 | 0 > =C2=A0vacuum_cost_limit =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 | 200 > =C2=A0vacuum_cost_page_dirty =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0| 20 > =C2=A0vacuum_cost_page_hit =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0| 1 > =C2=A0vacuum_cost_page_miss =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 | 10 > =C2=A0vacuum_defer_cleanup_age =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0|= 0 > =C2=A0vacuum_freeze_min_age =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 | 50000000 > =C2=A0vacuum_freeze_table_age =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |= 150000000 > =C2=A0vacuum_multixact_freeze_min_age =C2=A0 =C2=A0 | 5000000 > =C2=A0vacuum_multixact_freeze_table_age =C2=A0 | 150000000 > (23 rows) > > > > gerenciadora=3D# show max_connections ; > =C2=A0max_connections > ----------------- > =C2=A03250 > (1 row) > > > gerenciadora=3D# select name, setting from pg_settings where name > ~*'mem'; > =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 name =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0| setting > ----------------------------+--------- > =C2=A0autovacuum_work_mem =C2=A0 =C2=A0 =C2=A0 =C2=A0| -1 > =C2=A0dynamic_shared_memory_type | sysv > =C2=A0maintenance_work_mem =C2=A0 =C2=A0 =C2=A0 | 5242880 > =C2=A0work_mem =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 | 8192 > (4 rows) > > > [root@gvtsvpx-ger01 carlos.machado.ext]# sysctl -a | grep kernel.shm > kernel.shm_next_id =3D -1 > kernel.shm_rmid_forced =3D 0 > kernel.shmall =3D 4294967296 > kernel.shmmax =3D 68719476736 > kernel.shmmni =3D 10278078 > > theese was the commands I executed in single-user. > > [root@gvtsvpx-ger01 carlos.machado.ext]# su - postgres > Last login: Tue Aug 29 09:50:35 BRT 2017 on pts/2 > [postgres@gvtsvpx-ger01 ]# /usr/pgsql-9.5/bin/postgres --single -D / > var/lib/pgsql/9.5/data/ -d gerenciadora > 2017-08-29 10:21:13 BRT =C2=A0postgres[13610]: [1-1] user=3D,db=3D,host=3D > NOTICE: =C2=A0database system was shut down at 2017-08-29 10:17:00 BRT > 2017-08-29 10:21:13 BRT =C2=A0postgres[13610]: [2-1] user=3D,db=3D,host=3D > WARNING: =C2=A0database with OID 729782 must be vacuumed within 999675 > transactions > 2017-08-29 10:21:13 BRT =C2=A0postgres[13610]: [3-1] user=3D,db=3D,host= =3D HINT: > =C2=A0To avoid a database shutdown, execute a database-wide VACUUM in that > database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > > PostgreSQL stand-alone backend 9.5.5 > backend> vacuum > 2017-08-29 10:21:24 BRT =C2=A0postgres[13610]: [4-1] user=3D,db=3D,host=3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999675 > transactions > 2017-08-29 10:21:24 BRT =C2=A0postgres[13610]: [5-1] user=3D,db=3D,host= =3D HINT: > =C2=A0To avoid a database shutdown, execute a database-wide VACUUM in that > database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > backend> vacuum full > 2017-08-29 10:21:34 BRT =C2=A0postgres[13610]: [6-1] user=3D,db=3D,host=3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999675 > transactions > 2017-08-29 10:21:34 BRT =C2=A0postgres[13610]: [7-1] user=3D,db=3D,host= =3D HINT: > =C2=A0To avoid a database shutdown, execute a database-wide VACUUM in that > database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:35 BRT =C2=A0postgres[13610]: [8-1] user=3D,db=3D,host=3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999674 > transactions > 2017-08-29 10:21:35 BRT =C2=A0postgres[13610]: [9-1] user=3D,db=3D,host= =3D HINT: > =C2=A0To avoid a database shutdown, execute a database-wide VACUUM in that > database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:35 BRT =C2=A0postgres[13610]: [10-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999673 > transactions > 2017-08-29 10:21:35 BRT =C2=A0postgres[13610]: [11-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:35 BRT =C2=A0postgres[13610]: [12-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999672 > transactions > 2017-08-29 10:21:35 BRT =C2=A0postgres[13610]: [13-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:35 BRT =C2=A0postgres[13610]: [14-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999671 > transactions > 2017-08-29 10:21:35 BRT =C2=A0postgres[13610]: [15-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:35 BRT =C2=A0postgres[13610]: [16-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999670 > transactions > 2017-08-29 10:21:35 BRT =C2=A0postgres[13610]: [17-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:35 BRT =C2=A0postgres[13610]: [18-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999669 > transactions > 2017-08-29 10:21:35 BRT =C2=A0postgres[13610]: [19-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [20-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999668 > transactions > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [21-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [22-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999667 > transactions > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [23-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [24-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999666 > transactions > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [25-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [26-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999665 > transactions > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [27-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [28-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999664 > transactions > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [29-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [30-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999663 > transactions > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [31-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [32-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999662 > transactions > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [33-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [34-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999661 > transactions > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [35-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [36-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999660 > transactions > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [37-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [38-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999659 > transactions > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [39-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [40-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999658 > transactions > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [41-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [42-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999657 > transactions > 2017-08-29 10:21:41 BRT =C2=A0postgres[13610]: [43-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [44-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999656 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [45-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [46-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999655 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [47-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [48-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999654 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [49-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [50-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999653 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [51-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [52-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999652 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [53-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [54-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999651 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [55-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [56-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999650 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [57-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [58-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999649 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [59-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [60-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999648 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [61-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [62-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999647 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [63-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [64-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999646 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [65-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [66-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999645 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [67-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [68-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999644 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [69-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [70-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999643 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [71-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [72-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999642 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [73-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [74-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999641 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [75-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [76-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999640 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [77-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [78-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999639 > transactions > 2017-08-29 10:21:42 BRT =C2=A0postgres[13610]: [79-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [80-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999638 > transactions > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [81-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [82-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999637 > transactions > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [83-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [84-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999636 > transactions > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [85-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [86-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999635 > transactions > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [87-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [88-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999634 > transactions > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [89-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [90-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999633 > transactions > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [91-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [92-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999632 > transactions > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [93-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [94-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999631 > transactions > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [95-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [96-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999630 > transactions > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [97-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [98-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999629 > transactions > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [99-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [100-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999628 > transactions > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [101-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [102-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999627 > transactions > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [103-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [104-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999626 > transactions > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [105-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [106-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999625 > transactions > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [107-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [108-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999624 > transactions > 2017-08-29 10:21:43 BRT =C2=A0postgres[13610]: [109-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [110-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999623 > transactions > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [111-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [112-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999622 > transactions > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [113-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [114-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999621 > transactions > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [115-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [116-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999620 > transactions > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [117-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [118-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999619 > transactions > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [119-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [120-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999618 > transactions > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [121-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [122-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999617 > transactions > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [123-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [124-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999616 > transactions > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [125-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [126-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999615 > transactions > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [127-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [128-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999614 > transactions > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [129-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [130-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999613 > transactions > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [131-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [132-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999612 > transactions > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [133-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [134-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999611 > transactions > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [135-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [136-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999610 > transactions > 2017-08-29 10:21:44 BRT =C2=A0postgres[13610]: [137-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > backend> vacuum freeze > 2017-08-29 10:23:38 BRT =C2=A0postgres[13610]: [138-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999610 > transactions > 2017-08-29 10:23:38 BRT =C2=A0postgres[13610]: [139-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > backend> vacuum full freeze > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [140-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999610 > transactions > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [141-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [142-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999609 > transactions > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [143-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [144-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999608 > transactions > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [145-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [146-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999607 > transactions > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [147-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [148-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999606 > transactions > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [149-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [150-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999605 > transactions > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [151-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [152-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999604 > transactions > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [153-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [154-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999603 > transactions > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [155-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [156-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999602 > transactions > 2017-08-29 10:23:50 BRT =C2=A0postgres[13610]: [157-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [158-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999601 > transactions > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [159-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [160-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999600 > transactions > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [161-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [162-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999599 > transactions > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [163-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [164-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999598 > transactions > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [165-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [166-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999597 > transactions > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [167-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [168-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999596 > transactions > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [169-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [170-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999595 > transactions > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [171-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [172-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999594 > transactions > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [173-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [174-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999593 > transactions > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [175-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [176-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999592 > transactions > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [177-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [178-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999591 > transactions > 2017-08-29 10:23:51 BRT =C2=A0postgres[13610]: [179-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:52 BRT =C2=A0postgres[13610]: [180-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999590 > transactions > 2017-08-29 10:23:52 BRT =C2=A0postgres[13610]: [181-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:52 BRT =C2=A0postgres[13610]: [182-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999589 > transactions > 2017-08-29 10:23:52 BRT =C2=A0postgres[13610]: [183-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:52 BRT =C2=A0postgres[13610]: [184-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999588 > transactions > 2017-08-29 10:23:52 BRT =C2=A0postgres[13610]: [185-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:52 BRT =C2=A0postgres[13610]: [186-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999587 > transactions > 2017-08-29 10:23:52 BRT =C2=A0postgres[13610]: [187-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:52 BRT =C2=A0postgres[13610]: [188-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999586 > transactions > 2017-08-29 10:23:52 BRT =C2=A0postgres[13610]: [189-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:52 BRT =C2=A0postgres[13610]: [190-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999585 > transactions > 2017-08-29 10:23:52 BRT =C2=A0postgres[13610]: [191-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:52 BRT =C2=A0postgres[13610]: [192-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999584 > transactions > 2017-08-29 10:23:52 BRT =C2=A0postgres[13610]: [193-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [194-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999583 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [195-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [196-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999582 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [197-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [198-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999581 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [199-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [200-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999580 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [201-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [202-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999579 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [203-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [204-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999578 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [205-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [206-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999577 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [207-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [208-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999576 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [209-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [210-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999575 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [211-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [212-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999574 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [213-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [214-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999573 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [215-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [216-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999572 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [217-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [218-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999571 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [219-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [220-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999570 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [221-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [222-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999569 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [223-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [224-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999568 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [225-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [226-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999567 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [227-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [228-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999566 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [229-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [230-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999565 > transactions > 2017-08-29 10:23:53 BRT =C2=A0postgres[13610]: [231-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [232-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999564 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [233-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [234-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999563 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [235-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [236-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999562 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [237-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [238-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999561 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [239-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [240-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999560 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [241-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [242-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999559 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [243-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [244-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999558 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [245-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [246-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999557 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [247-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [248-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999556 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [249-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [250-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999555 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [251-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [252-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999554 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [253-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [254-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999553 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [255-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [256-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999552 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [257-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [258-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999551 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [259-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [260-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999550 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [261-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [262-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999549 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [263-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [264-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999548 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [265-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [266-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999547 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [267-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [268-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999546 > transactions > 2017-08-29 10:23:54 BRT =C2=A0postgres[13610]: [269-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > 2017-08-29 10:23:55 BRT =C2=A0postgres[13610]: [270-1] user=3D,db=3D,host= =3D > WARNING: =C2=A0database "gerenciadora" must be vacuumed within 999545 > transactions > 2017-08-29 10:23:55 BRT =C2=A0postgres[13610]: [271-1] user=3D,db=3D,host= =3D > HINT: =C2=A0To avoid a database shutdown, execute a database-wide VACUUM > in that database. > =C2=A0 =C2=A0 =C2=A0 =C2=A0 You might also need to commit or roll back ol= d prepared > transactions. > backend> > > > > Best regards, > Carlos Augusto Machado > > --=20 Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@comcast.net p: 312.241.7800 --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin