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
