[ADMIN] Problem with transaction ID wraparound

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 ?

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