Re: Postgres + Docker

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Dimitris,

there's nothing to worry about both messages, there are normal during bulk loading your database and are not docker-related.

I you want to avoid them you can disable the autovacuum daemon before starting the restore, autovacuum = off in your postgresql.conf and do the vacuum/analyze afterwards manually with: vacuum analyze verbose.

But don't forget to reenable the autovacuum daemon!

Marco


Am 19.08.2016 um 11:08 schrieb Κοκμάδης Δημήτριος:
Dear All,

I try to restore a big database inside docker in order to provide a
docker image with database inside it.

During restoration in tables with a lot of entries, I have the following
error

 [91m2016-08-19 08:58:37 UTC [92-3] ERROR:  canceling autovacuum task
2016-08-19 08:58:37 UTC [92-4] CONTEXT:  automatic analyze of table "XXXX.XXX.XXX"



Same procedure ( cat filename | gunzip | psql databasename) in plain
server works without any error.

How can I avoid those errors inside docker?

Best Regards,

Dimitris Kokmadis




--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux