Hi team! We make backups of the "polylogyx" postgresql db with command:

pg_dump -U polylogyx polylogyx > 03_24_dump.dmp

and restore:

psql -U polylogyx polylogyx < 03_24_dump.dmp

As a result we can observe many errors:

Hi @Eugene, The way you are trying to export and import db dumps is exactly correct. As part of ESP compose, we populate some default data into ESP. So when you are trying to import the db backup, it is trying to add the relations, indexes and etc., again to the same db where those are already present. So resulting errors

Ok, thx

If you want to import the db into a fresh server( or a server where you don't have an important db), we recommend dropping the postgres docker volume and recreating the postgres docker container(But not along with plgx-esp docker service, as plgx-esp service creates relations again).