pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem with transaction ID wraparound
2+ messages / 2 participants
[nested] [flat]
* Problem with transaction ID wraparound
@ 2017-09-05 14:05 Carlos Augusto Machado <caugustom@gmail.com>
2017-09-06 15:37 ` Re: Problem with transaction ID wraparound Jerry Sievers <gsievers19@comcast.net>
0 siblings, 1 reply; 2+ messages in thread
From: Carlos Augusto Machado @ 2017-09-05 14:05 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Problem with transaction ID wraparound
2017-09-05 14:05 Problem with transaction ID wraparound Carlos Augusto Machado <caugustom@gmail.com>
@ 2017-09-06 15:37 ` Jerry Sievers <gsievers19@comcast.net>
0 siblings, 0 replies; 2+ messages in thread
From: Jerry Sievers @ 2017-09-06 15:37 UTC (permalink / raw)
To: Carlos Augusto Machado <caugustom@gmail.com>; +Cc: pgsql-admin
Carlos Augusto Machado <caugustom@gmail.com> writes:
> Hi,
>
> last week I faced a problem with transaction ID wraparound, even
> running VACUUM FULL or VACUUM FREEZE in single-user mode could not
> solve the problem.
>
> Running a vacuum in single-user I got the following error message.
>
> 2017-08-29 10:21:24 BRT Â postgres[13610]: [4-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999675
> transactions
> 2017-08-29 10:21:24 BRT Â postgres[13610]: [5-1] user=,db=,host= HINT:
> Â To avoid a database shutdown, execute a database-wide VACUUM in that
> database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
>
> I could identify the problem was due to a temporary table executing
> the following query and verifying the relfrozenxid was 2146484102.
>
> SELECT c.oid::regclass as table_name,
> Â Â Â Â greatest(age(c.relfrozenxid),age(t.relfrozenxid)) as age
> FROM pg_class c
> LEFT JOIN pg_class t ON c.reltoastrelid = t.oid
> WHERE c.relkind IN ('r', 'm');
>
>
>
>
> Checking the PostgreSQL documentation (https://www.postgresql.org/
> docs/9.5/static/routine-vacuuming.html) I realized auto vacuum can
> not vacuum temporary tables as explained on this text.
>
> Temporary tables cannot be accessed by autovacuum. Therefore,
> appropriate vacuum and analyze operations should be performed via
> session SQL commands.
>
> My doubt is about temporary tables not beeing removed even stopping
> the PostgreSQL service and avoiding me to run vacuum.
>
> Did I understood something wrong ? Or is it what was really happening
> ?
>
> To solve the problem I rejected all connections in pg_hba.conf only
> allowing local connections, did a pg_dump for this database, dropped
> the database and did a pg_restore.
>
> That was the only way on that moment came in my mind to solve the
> problem without loosing data. But this gave a 4 hours of downtime.
>
> There was any faster solution for this ?
Yes. You could have just manually dropped those temp tables during your
standalone session.
HTH
>
>
> My configuration:
>
> PostgreSQL 9.5.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
> 20150623 (Red Hat 4.8.5-4), 64-bit
> Linux gvtsvpx-ger01 4.1.12-61.1.16.el7uek.x86_64 #2 SMP Fri Oct 21
> 14:23:20 PDT 2016 x86_64 x86_64 x86_64 GNU/Linux
>
> 16 CPUs
> 78 GB RAM
>
> gerenciadora=# select name, setting from pg_settings where name
> ~*'vacuum';
>         name         |  setting
> -------------------------------------+-----------
>  autovacuum              | on
>  autovacuum_analyze_scale_factor   | 0.1
>  autovacuum_analyze_threshold     | 50
>  autovacuum_freeze_max_age      | 200000000
>  autovacuum_max_workers        | 3
> Â autovacuum_multixact_freeze_max_age | 400000000
>  autovacuum_naptime          | 60
>  autovacuum_vacuum_cost_delay     | 20
>  autovacuum_vacuum_cost_limit     | -1
>  autovacuum_vacuum_scale_factor    | 0.2
>  autovacuum_vacuum_threshold     | 50
>  autovacuum_work_mem         | -1
>  log_autovacuum_min_duration     | -1
>  vacuum_cost_delay          | 0
>  vacuum_cost_limit          | 200
>  vacuum_cost_page_dirty        | 20
>  vacuum_cost_page_hit         | 1
>  vacuum_cost_page_miss        | 10
>  vacuum_defer_cleanup_age       | 0
>  vacuum_freeze_min_age        | 50000000
>  vacuum_freeze_table_age       | 150000000
>  vacuum_multixact_freeze_min_age   | 5000000
>  vacuum_multixact_freeze_table_age  | 150000000
> (23 rows)
>
>
>
> gerenciadora=# show max_connections ;
> Â max_connections
> -----------------
> Â 3250
> (1 row)
>
>
> gerenciadora=# select name, setting from pg_settings where name
> ~*'mem';
>       name       | setting
> ----------------------------+---------
>  autovacuum_work_mem     | -1
> Â dynamic_shared_memory_type | sysv
>  maintenance_work_mem    | 5242880
>  work_mem          | 8192
> (4 rows)
>
>
> [root@gvtsvpx-ger01 carlos.machado.ext]# sysctl -a | grep kernel.shm
> kernel.shm_next_id = -1
> kernel.shm_rmid_forced = 0
> kernel.shmall = 4294967296
> kernel.shmmax = 68719476736
> kernel.shmmni = 10278078
>
> theese was the commands I executed in single-user.
>
> [root@gvtsvpx-ger01 carlos.machado.ext]# su - postgres
> Last login: Tue Aug 29 09:50:35 BRT 2017 on pts/2
> [postgres@gvtsvpx-ger01 ]# /usr/pgsql-9.5/bin/postgres --single -D /
> var/lib/pgsql/9.5/data/ -d gerenciadora
> 2017-08-29 10:21:13 BRT Â postgres[13610]: [1-1] user=,db=,host=
> NOTICE: Â database system was shut down at 2017-08-29 10:17:00 BRT
> 2017-08-29 10:21:13 BRT Â postgres[13610]: [2-1] user=,db=,host=
> WARNING: Â database with OID 729782 must be vacuumed within 999675
> transactions
> 2017-08-29 10:21:13 BRT Â postgres[13610]: [3-1] user=,db=,host= HINT:
> Â To avoid a database shutdown, execute a database-wide VACUUM in that
> database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
>
> PostgreSQL stand-alone backend 9.5.5
> backend> vacuum
> 2017-08-29 10:21:24 BRT Â postgres[13610]: [4-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999675
> transactions
> 2017-08-29 10:21:24 BRT Â postgres[13610]: [5-1] user=,db=,host= HINT:
> Â To avoid a database shutdown, execute a database-wide VACUUM in that
> database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> backend> vacuum full
> 2017-08-29 10:21:34 BRT Â postgres[13610]: [6-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999675
> transactions
> 2017-08-29 10:21:34 BRT Â postgres[13610]: [7-1] user=,db=,host= HINT:
> Â To avoid a database shutdown, execute a database-wide VACUUM in that
> database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:35 BRT Â postgres[13610]: [8-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999674
> transactions
> 2017-08-29 10:21:35 BRT Â postgres[13610]: [9-1] user=,db=,host= HINT:
> Â To avoid a database shutdown, execute a database-wide VACUUM in that
> database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:35 BRT Â postgres[13610]: [10-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999673
> transactions
> 2017-08-29 10:21:35 BRT Â postgres[13610]: [11-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:35 BRT Â postgres[13610]: [12-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999672
> transactions
> 2017-08-29 10:21:35 BRT Â postgres[13610]: [13-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:35 BRT Â postgres[13610]: [14-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999671
> transactions
> 2017-08-29 10:21:35 BRT Â postgres[13610]: [15-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:35 BRT Â postgres[13610]: [16-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999670
> transactions
> 2017-08-29 10:21:35 BRT Â postgres[13610]: [17-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:35 BRT Â postgres[13610]: [18-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999669
> transactions
> 2017-08-29 10:21:35 BRT Â postgres[13610]: [19-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [20-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999668
> transactions
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [21-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [22-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999667
> transactions
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [23-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [24-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999666
> transactions
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [25-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [26-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999665
> transactions
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [27-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [28-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999664
> transactions
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [29-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [30-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999663
> transactions
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [31-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [32-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999662
> transactions
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [33-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [34-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999661
> transactions
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [35-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [36-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999660
> transactions
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [37-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [38-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999659
> transactions
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [39-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [40-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999658
> transactions
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [41-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [42-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999657
> transactions
> 2017-08-29 10:21:41 BRT Â postgres[13610]: [43-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [44-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999656
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [45-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [46-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999655
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [47-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [48-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999654
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [49-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [50-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999653
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [51-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [52-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999652
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [53-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [54-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999651
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [55-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [56-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999650
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [57-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [58-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999649
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [59-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [60-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999648
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [61-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [62-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999647
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [63-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [64-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999646
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [65-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [66-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999645
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [67-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [68-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999644
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [69-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [70-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999643
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [71-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [72-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999642
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [73-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [74-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999641
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [75-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [76-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999640
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [77-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [78-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999639
> transactions
> 2017-08-29 10:21:42 BRT Â postgres[13610]: [79-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [80-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999638
> transactions
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [81-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [82-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999637
> transactions
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [83-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [84-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999636
> transactions
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [85-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [86-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999635
> transactions
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [87-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [88-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999634
> transactions
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [89-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [90-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999633
> transactions
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [91-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [92-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999632
> transactions
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [93-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [94-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999631
> transactions
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [95-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [96-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999630
> transactions
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [97-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [98-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999629
> transactions
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [99-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [100-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999628
> transactions
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [101-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [102-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999627
> transactions
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [103-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [104-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999626
> transactions
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [105-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [106-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999625
> transactions
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [107-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [108-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999624
> transactions
> 2017-08-29 10:21:43 BRT Â postgres[13610]: [109-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [110-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999623
> transactions
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [111-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [112-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999622
> transactions
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [113-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [114-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999621
> transactions
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [115-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [116-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999620
> transactions
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [117-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [118-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999619
> transactions
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [119-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [120-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999618
> transactions
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [121-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [122-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999617
> transactions
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [123-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [124-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999616
> transactions
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [125-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [126-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999615
> transactions
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [127-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [128-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999614
> transactions
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [129-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [130-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999613
> transactions
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [131-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [132-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999612
> transactions
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [133-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [134-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999611
> transactions
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [135-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [136-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999610
> transactions
> 2017-08-29 10:21:44 BRT Â postgres[13610]: [137-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> backend> vacuum freeze
> 2017-08-29 10:23:38 BRT Â postgres[13610]: [138-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999610
> transactions
> 2017-08-29 10:23:38 BRT Â postgres[13610]: [139-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> backend> vacuum full freeze
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [140-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999610
> transactions
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [141-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [142-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999609
> transactions
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [143-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [144-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999608
> transactions
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [145-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [146-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999607
> transactions
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [147-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [148-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999606
> transactions
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [149-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [150-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999605
> transactions
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [151-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [152-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999604
> transactions
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [153-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [154-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999603
> transactions
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [155-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [156-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999602
> transactions
> 2017-08-29 10:23:50 BRT Â postgres[13610]: [157-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [158-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999601
> transactions
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [159-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [160-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999600
> transactions
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [161-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [162-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999599
> transactions
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [163-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [164-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999598
> transactions
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [165-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [166-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999597
> transactions
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [167-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [168-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999596
> transactions
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [169-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [170-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999595
> transactions
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [171-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [172-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999594
> transactions
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [173-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [174-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999593
> transactions
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [175-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [176-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999592
> transactions
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [177-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [178-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999591
> transactions
> 2017-08-29 10:23:51 BRT Â postgres[13610]: [179-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:52 BRT Â postgres[13610]: [180-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999590
> transactions
> 2017-08-29 10:23:52 BRT Â postgres[13610]: [181-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:52 BRT Â postgres[13610]: [182-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999589
> transactions
> 2017-08-29 10:23:52 BRT Â postgres[13610]: [183-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:52 BRT Â postgres[13610]: [184-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999588
> transactions
> 2017-08-29 10:23:52 BRT Â postgres[13610]: [185-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:52 BRT Â postgres[13610]: [186-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999587
> transactions
> 2017-08-29 10:23:52 BRT Â postgres[13610]: [187-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:52 BRT Â postgres[13610]: [188-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999586
> transactions
> 2017-08-29 10:23:52 BRT Â postgres[13610]: [189-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:52 BRT Â postgres[13610]: [190-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999585
> transactions
> 2017-08-29 10:23:52 BRT Â postgres[13610]: [191-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:52 BRT Â postgres[13610]: [192-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999584
> transactions
> 2017-08-29 10:23:52 BRT Â postgres[13610]: [193-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [194-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999583
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [195-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [196-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999582
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [197-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [198-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999581
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [199-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [200-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999580
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [201-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [202-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999579
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [203-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [204-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999578
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [205-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [206-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999577
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [207-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [208-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999576
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [209-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [210-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999575
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [211-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [212-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999574
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [213-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [214-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999573
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [215-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [216-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999572
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [217-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [218-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999571
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [219-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [220-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999570
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [221-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [222-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999569
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [223-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [224-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999568
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [225-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [226-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999567
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [227-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [228-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999566
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [229-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [230-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999565
> transactions
> 2017-08-29 10:23:53 BRT Â postgres[13610]: [231-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [232-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999564
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [233-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [234-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999563
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [235-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [236-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999562
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [237-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [238-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999561
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [239-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [240-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999560
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [241-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [242-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999559
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [243-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [244-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999558
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [245-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [246-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999557
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [247-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [248-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999556
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [249-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [250-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999555
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [251-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [252-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999554
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [253-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [254-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999553
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [255-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [256-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999552
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [257-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [258-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999551
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [259-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [260-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999550
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [261-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [262-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999549
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [263-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [264-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999548
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [265-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [266-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999547
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [267-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [268-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999546
> transactions
> 2017-08-29 10:23:54 BRT Â postgres[13610]: [269-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> 2017-08-29 10:23:55 BRT Â postgres[13610]: [270-1] user=,db=,host=
> WARNING: Â database "gerenciadora" must be vacuumed within 999545
> transactions
> 2017-08-29 10:23:55 BRT Â postgres[13610]: [271-1] user=,db=,host=
> HINT: Â To avoid a database shutdown, execute a database-wide VACUUM
> in that database.
> Â Â Â Â You might also need to commit or roll back old prepared
> transactions.
> backend>
>
>
>
> Best regards,
> Carlos Augusto Machado
>
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-09-06 15:37 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-09-05 14:05 Problem with transaction ID wraparound Carlos Augusto Machado <caugustom@gmail.com>
2017-09-06 15:37 ` Jerry Sievers <gsievers19@comcast.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox