Re: Postgres + Docker

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
>
>