Re: [ADMIN] Problem with transaction ID wraparound

Carlos Augusto Machado <caugustom@gmail.com> 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  postgres[13610]: [4-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999675
> transactions
> 2017-08-29 10:21:24 BRT  postgres[13610]: [5-1] user=,db=,host= HINT:
>  To avoid a database shutdown, execute a database-wide VACUUM in that
> database.
>         You might also need to commit or roll back old 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,
>        greatest(age(c.relfrozenxid),age(t.relfrozenxid)) as age
> FROM pg_class c
> LEFT JOIN pg_class t ON c.reltoastrelid = 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=# select name, setting from pg_settings where name
> ~*'vacuum';
>                 name                 |  setting
> -------------------------------------+-----------
>  autovacuum                          | on
>  autovacuum_analyze_scale_factor     | 0.1
>  autovacuum_analyze_threshold        | 50
>  autovacuum_freeze_max_age           | 200000000
>  autovacuum_max_workers              | 3
>  autovacuum_multixact_freeze_max_age | 400000000
>  autovacuum_naptime                  | 60
>  autovacuum_vacuum_cost_delay        | 20
>  autovacuum_vacuum_cost_limit        | -1
>  autovacuum_vacuum_scale_factor      | 0.2
>  autovacuum_vacuum_threshold         | 50
>  autovacuum_work_mem                 | -1
>  log_autovacuum_min_duration         | -1
>  vacuum_cost_delay                   | 0
>  vacuum_cost_limit                   | 200
>  vacuum_cost_page_dirty              | 20
>  vacuum_cost_page_hit                | 1
>  vacuum_cost_page_miss               | 10
>  vacuum_defer_cleanup_age            | 0
>  vacuum_freeze_min_age               | 50000000
>  vacuum_freeze_table_age             | 150000000
>  vacuum_multixact_freeze_min_age     | 5000000
>  vacuum_multixact_freeze_table_age   | 150000000
> (23 rows)
>
>
>
> gerenciadora=# show max_connections ;
>  max_connections
> -----------------
>  3250
> (1 row)
>
>
> gerenciadora=# select name, setting from pg_settings where name
> ~*'mem';
>             name            | setting
> ----------------------------+---------
>  autovacuum_work_mem        | -1
>  dynamic_shared_memory_type | sysv
>  maintenance_work_mem       | 5242880
>  work_mem                   | 8192
> (4 rows)
>
>
> [root@gvtsvpx-ger01 carlos.machado.ext]# sysctl -a | grep kernel.shm
> kernel.shm_next_id = -1
> kernel.shm_rmid_forced = 0
> kernel.shmall = 4294967296
> kernel.shmmax = 68719476736
> kernel.shmmni = 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  postgres[13610]: [1-1] user=,db=,host=
> NOTICE:  database system was shut down at 2017-08-29 10:17:00 BRT
> 2017-08-29 10:21:13 BRT  postgres[13610]: [2-1] user=,db=,host=
> WARNING:  database with OID 729782 must be vacuumed within 999675
> transactions
> 2017-08-29 10:21:13 BRT  postgres[13610]: [3-1] user=,db=,host= HINT:
>  To avoid a database shutdown, execute a database-wide VACUUM in that
> database.
>         You might also need to commit or roll back old prepared
> transactions.
>
> PostgreSQL stand-alone backend 9.5.5
> backend> vacuum
> 2017-08-29 10:21:24 BRT  postgres[13610]: [4-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999675
> transactions
> 2017-08-29 10:21:24 BRT  postgres[13610]: [5-1] user=,db=,host= HINT:
>  To avoid a database shutdown, execute a database-wide VACUUM in that
> database.
>         You might also need to commit or roll back old prepared
> transactions.
> backend> vacuum full
> 2017-08-29 10:21:34 BRT  postgres[13610]: [6-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999675
> transactions
> 2017-08-29 10:21:34 BRT  postgres[13610]: [7-1] user=,db=,host= HINT:
>  To avoid a database shutdown, execute a database-wide VACUUM in that
> database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:35 BRT  postgres[13610]: [8-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999674
> transactions
> 2017-08-29 10:21:35 BRT  postgres[13610]: [9-1] user=,db=,host= HINT:
>  To avoid a database shutdown, execute a database-wide VACUUM in that
> database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:35 BRT  postgres[13610]: [10-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999673
> transactions
> 2017-08-29 10:21:35 BRT  postgres[13610]: [11-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:35 BRT  postgres[13610]: [12-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999672
> transactions
> 2017-08-29 10:21:35 BRT  postgres[13610]: [13-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:35 BRT  postgres[13610]: [14-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999671
> transactions
> 2017-08-29 10:21:35 BRT  postgres[13610]: [15-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:35 BRT  postgres[13610]: [16-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999670
> transactions
> 2017-08-29 10:21:35 BRT  postgres[13610]: [17-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:35 BRT  postgres[13610]: [18-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999669
> transactions
> 2017-08-29 10:21:35 BRT  postgres[13610]: [19-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT  postgres[13610]: [20-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999668
> transactions
> 2017-08-29 10:21:41 BRT  postgres[13610]: [21-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT  postgres[13610]: [22-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999667
> transactions
> 2017-08-29 10:21:41 BRT  postgres[13610]: [23-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT  postgres[13610]: [24-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999666
> transactions
> 2017-08-29 10:21:41 BRT  postgres[13610]: [25-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT  postgres[13610]: [26-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999665
> transactions
> 2017-08-29 10:21:41 BRT  postgres[13610]: [27-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT  postgres[13610]: [28-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999664
> transactions
> 2017-08-29 10:21:41 BRT  postgres[13610]: [29-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT  postgres[13610]: [30-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999663
> transactions
> 2017-08-29 10:21:41 BRT  postgres[13610]: [31-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT  postgres[13610]: [32-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999662
> transactions
> 2017-08-29 10:21:41 BRT  postgres[13610]: [33-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT  postgres[13610]: [34-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999661
> transactions
> 2017-08-29 10:21:41 BRT  postgres[13610]: [35-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT  postgres[13610]: [36-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999660
> transactions
> 2017-08-29 10:21:41 BRT  postgres[13610]: [37-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT  postgres[13610]: [38-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999659
> transactions
> 2017-08-29 10:21:41 BRT  postgres[13610]: [39-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT  postgres[13610]: [40-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999658
> transactions
> 2017-08-29 10:21:41 BRT  postgres[13610]: [41-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT  postgres[13610]: [42-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999657
> transactions
> 2017-08-29 10:21:41 BRT  postgres[13610]: [43-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [44-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999656
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [45-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [46-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999655
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [47-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [48-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999654
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [49-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [50-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999653
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [51-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [52-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999652
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [53-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [54-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999651
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [55-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [56-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999650
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [57-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [58-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999649
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [59-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [60-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999648
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [61-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [62-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999647
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [63-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [64-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999646
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [65-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [66-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999645
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [67-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [68-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999644
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [69-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [70-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999643
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [71-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [72-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999642
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [73-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [74-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999641
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [75-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [76-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999640
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [77-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT  postgres[13610]: [78-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999639
> transactions
> 2017-08-29 10:21:42 BRT  postgres[13610]: [79-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT  postgres[13610]: [80-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999638
> transactions
> 2017-08-29 10:21:43 BRT  postgres[13610]: [81-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT  postgres[13610]: [82-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999637
> transactions
> 2017-08-29 10:21:43 BRT  postgres[13610]: [83-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT  postgres[13610]: [84-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999636
> transactions
> 2017-08-29 10:21:43 BRT  postgres[13610]: [85-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT  postgres[13610]: [86-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999635
> transactions
> 2017-08-29 10:21:43 BRT  postgres[13610]: [87-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT  postgres[13610]: [88-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999634
> transactions
> 2017-08-29 10:21:43 BRT  postgres[13610]: [89-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT  postgres[13610]: [90-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999633
> transactions
> 2017-08-29 10:21:43 BRT  postgres[13610]: [91-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT  postgres[13610]: [92-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999632
> transactions
> 2017-08-29 10:21:43 BRT  postgres[13610]: [93-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT  postgres[13610]: [94-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999631
> transactions
> 2017-08-29 10:21:43 BRT  postgres[13610]: [95-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT  postgres[13610]: [96-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999630
> transactions
> 2017-08-29 10:21:43 BRT  postgres[13610]: [97-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT  postgres[13610]: [98-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999629
> transactions
> 2017-08-29 10:21:43 BRT  postgres[13610]: [99-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT  postgres[13610]: [100-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999628
> transactions
> 2017-08-29 10:21:43 BRT  postgres[13610]: [101-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT  postgres[13610]: [102-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999627
> transactions
> 2017-08-29 10:21:43 BRT  postgres[13610]: [103-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT  postgres[13610]: [104-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999626
> transactions
> 2017-08-29 10:21:43 BRT  postgres[13610]: [105-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT  postgres[13610]: [106-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999625
> transactions
> 2017-08-29 10:21:43 BRT  postgres[13610]: [107-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT  postgres[13610]: [108-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999624
> transactions
> 2017-08-29 10:21:43 BRT  postgres[13610]: [109-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT  postgres[13610]: [110-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999623
> transactions
> 2017-08-29 10:21:44 BRT  postgres[13610]: [111-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT  postgres[13610]: [112-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999622
> transactions
> 2017-08-29 10:21:44 BRT  postgres[13610]: [113-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT  postgres[13610]: [114-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999621
> transactions
> 2017-08-29 10:21:44 BRT  postgres[13610]: [115-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT  postgres[13610]: [116-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999620
> transactions
> 2017-08-29 10:21:44 BRT  postgres[13610]: [117-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT  postgres[13610]: [118-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999619
> transactions
> 2017-08-29 10:21:44 BRT  postgres[13610]: [119-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT  postgres[13610]: [120-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999618
> transactions
> 2017-08-29 10:21:44 BRT  postgres[13610]: [121-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT  postgres[13610]: [122-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999617
> transactions
> 2017-08-29 10:21:44 BRT  postgres[13610]: [123-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT  postgres[13610]: [124-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999616
> transactions
> 2017-08-29 10:21:44 BRT  postgres[13610]: [125-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT  postgres[13610]: [126-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999615
> transactions
> 2017-08-29 10:21:44 BRT  postgres[13610]: [127-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT  postgres[13610]: [128-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999614
> transactions
> 2017-08-29 10:21:44 BRT  postgres[13610]: [129-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT  postgres[13610]: [130-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999613
> transactions
> 2017-08-29 10:21:44 BRT  postgres[13610]: [131-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT  postgres[13610]: [132-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999612
> transactions
> 2017-08-29 10:21:44 BRT  postgres[13610]: [133-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT  postgres[13610]: [134-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999611
> transactions
> 2017-08-29 10:21:44 BRT  postgres[13610]: [135-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT  postgres[13610]: [136-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999610
> transactions
> 2017-08-29 10:21:44 BRT  postgres[13610]: [137-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> backend> vacuum freeze
> 2017-08-29 10:23:38 BRT  postgres[13610]: [138-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999610
> transactions
> 2017-08-29 10:23:38 BRT  postgres[13610]: [139-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> backend> vacuum full freeze
> 2017-08-29 10:23:50 BRT  postgres[13610]: [140-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999610
> transactions
> 2017-08-29 10:23:50 BRT  postgres[13610]: [141-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:50 BRT  postgres[13610]: [142-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999609
> transactions
> 2017-08-29 10:23:50 BRT  postgres[13610]: [143-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:50 BRT  postgres[13610]: [144-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999608
> transactions
> 2017-08-29 10:23:50 BRT  postgres[13610]: [145-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:50 BRT  postgres[13610]: [146-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999607
> transactions
> 2017-08-29 10:23:50 BRT  postgres[13610]: [147-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:50 BRT  postgres[13610]: [148-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999606
> transactions
> 2017-08-29 10:23:50 BRT  postgres[13610]: [149-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:50 BRT  postgres[13610]: [150-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999605
> transactions
> 2017-08-29 10:23:50 BRT  postgres[13610]: [151-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:50 BRT  postgres[13610]: [152-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999604
> transactions
> 2017-08-29 10:23:50 BRT  postgres[13610]: [153-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:50 BRT  postgres[13610]: [154-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999603
> transactions
> 2017-08-29 10:23:50 BRT  postgres[13610]: [155-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:50 BRT  postgres[13610]: [156-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999602
> transactions
> 2017-08-29 10:23:50 BRT  postgres[13610]: [157-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT  postgres[13610]: [158-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999601
> transactions
> 2017-08-29 10:23:51 BRT  postgres[13610]: [159-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT  postgres[13610]: [160-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999600
> transactions
> 2017-08-29 10:23:51 BRT  postgres[13610]: [161-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT  postgres[13610]: [162-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999599
> transactions
> 2017-08-29 10:23:51 BRT  postgres[13610]: [163-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT  postgres[13610]: [164-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999598
> transactions
> 2017-08-29 10:23:51 BRT  postgres[13610]: [165-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT  postgres[13610]: [166-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999597
> transactions
> 2017-08-29 10:23:51 BRT  postgres[13610]: [167-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT  postgres[13610]: [168-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999596
> transactions
> 2017-08-29 10:23:51 BRT  postgres[13610]: [169-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT  postgres[13610]: [170-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999595
> transactions
> 2017-08-29 10:23:51 BRT  postgres[13610]: [171-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT  postgres[13610]: [172-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999594
> transactions
> 2017-08-29 10:23:51 BRT  postgres[13610]: [173-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT  postgres[13610]: [174-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999593
> transactions
> 2017-08-29 10:23:51 BRT  postgres[13610]: [175-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT  postgres[13610]: [176-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999592
> transactions
> 2017-08-29 10:23:51 BRT  postgres[13610]: [177-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT  postgres[13610]: [178-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999591
> transactions
> 2017-08-29 10:23:51 BRT  postgres[13610]: [179-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:52 BRT  postgres[13610]: [180-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999590
> transactions
> 2017-08-29 10:23:52 BRT  postgres[13610]: [181-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:52 BRT  postgres[13610]: [182-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999589
> transactions
> 2017-08-29 10:23:52 BRT  postgres[13610]: [183-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:52 BRT  postgres[13610]: [184-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999588
> transactions
> 2017-08-29 10:23:52 BRT  postgres[13610]: [185-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:52 BRT  postgres[13610]: [186-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999587
> transactions
> 2017-08-29 10:23:52 BRT  postgres[13610]: [187-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:52 BRT  postgres[13610]: [188-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999586
> transactions
> 2017-08-29 10:23:52 BRT  postgres[13610]: [189-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:52 BRT  postgres[13610]: [190-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999585
> transactions
> 2017-08-29 10:23:52 BRT  postgres[13610]: [191-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:52 BRT  postgres[13610]: [192-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999584
> transactions
> 2017-08-29 10:23:52 BRT  postgres[13610]: [193-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [194-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999583
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [195-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [196-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999582
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [197-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [198-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999581
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [199-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [200-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999580
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [201-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [202-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999579
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [203-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [204-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999578
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [205-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [206-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999577
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [207-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [208-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999576
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [209-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [210-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999575
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [211-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [212-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999574
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [213-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [214-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999573
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [215-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [216-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999572
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [217-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [218-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999571
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [219-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [220-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999570
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [221-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [222-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999569
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [223-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [224-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999568
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [225-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [226-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999567
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [227-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [228-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999566
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [229-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT  postgres[13610]: [230-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999565
> transactions
> 2017-08-29 10:23:53 BRT  postgres[13610]: [231-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [232-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999564
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [233-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [234-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999563
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [235-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [236-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999562
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [237-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [238-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999561
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [239-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [240-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999560
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [241-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [242-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999559
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [243-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [244-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999558
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [245-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [246-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999557
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [247-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [248-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999556
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [249-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [250-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999555
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [251-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [252-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999554
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [253-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [254-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999553
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [255-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [256-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999552
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [257-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [258-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999551
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [259-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [260-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999550
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [261-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [262-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999549
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [263-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [264-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999548
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [265-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [266-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999547
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [267-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT  postgres[13610]: [268-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999546
> transactions
> 2017-08-29 10:23:54 BRT  postgres[13610]: [269-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:55 BRT  postgres[13610]: [270-1] user=,db=,host=
> WARNING:  database "gerenciadora" must be vacuumed within 999545
> transactions
> 2017-08-29 10:23:55 BRT  postgres[13610]: [271-1] user=,db=,host=
> HINT:  To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
>         You might also need to commit or roll back old prepared
> transactions.
> backend>
>
>
>
> Best regards,
> Carlos Augusto Machado
>
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800