# Backup problem - booking data missing

**URL:** https://discuss.tryton.org/t/backup-problem-booking-data-missing/3183
**Category:** System Administrator
**Created:** [September 4, 2020, 8:08am UTC](https://discuss.tryton.org/t/backup-problem-booking-data-missing/3183 "2020-09-04T08:08:00Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![herrdeh](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/herrdeh/32/821_2.png) [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [September 4, 2020, 8:08am UTC](https://discuss.tryton.org/t/backup-problem-booking-data-missing/3183/1 "2020-09-04T08:08:00Z")

</div>

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.](https://discuss.tryton.org/t/delete-invoice-table-of-accounts-etc/2640/23)  
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

---

<div class="post-metadata">

### Author: ![herrdeh](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/herrdeh/32/821_2.png) [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [September 4, 2020, 12:06pm UTC](https://discuss.tryton.org/t/backup-problem-booking-data-missing/3183/2 "2020-09-04T12:06:38Z")

</div>

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…

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [September 4, 2020, 12:08pm UTC](https://discuss.tryton.org/t/backup-problem-booking-data-missing/3183/3 "2020-09-04T12:08:21Z")

</div>

Are you sure of the database name?

---

<div class="post-metadata">

### Author: ![herrdeh](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/herrdeh/32/821_2.png) [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [September 7, 2020, 4:55pm UTC](https://discuss.tryton.org/t/backup-problem-booking-data-missing/3183/4 "2020-09-07T16:55:01Z")

</div>

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

---

<div class="post-metadata">

### Author: ![system](https://discuss-cdn.tryton.org/uploads/default/original/1X/c6f8ec0a40525cdcd50058c734283450a4b3d38b.png) [@system](https://discuss.tryton.org/u/system)
#### Post date: [October 7, 2020, 4:55pm UTC](https://discuss.tryton.org/t/backup-problem-booking-data-missing/3183/5 "2020-10-07T16:55:06Z")

</div>

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