Backup problem - booking data missing

Support System Administrator
1

Hello,

I used backup my postgres database with this command:
sudo docker exec [ID-of-my-postgres-container] pg_dump -C -c -U postgres -O tryton >[name-of-your-backup-file].sql

@dave provided this solution here.
For some time now, I do no longer get something like 6MB, but just 600kB of data - missing all my bookings, parties, accounts etc.

$ sudo docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 7ec663f2e052 postgres "docker-entrypoint.s…" 3 weeks ago Up 23 minutes 5432/tcp tryton-postgres

My tryton still is working, all data are present. When I check the database with pgAdmin, I can see my data.

Can somebody guess what could be wrong with my backup command, which used to work nicely?

Thanks a lot in advance,
Wolf

2

It seems to work with
sudo docker exec [ID-of-postgres-container] pg_dumpall -c -U postgres >[name-ob-my-backupfile].sql

I dont yet know why…

3

Are you sure of the database name?

4

Most time, I called the command with a script, so there should be no mistakes. But for unknown reasons, it’s now back at work.
Thanks for your time&attention anyway…

Cheers,
Wolf

5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.