From: | Matthias Apitz <guru(at)unixarea(dot)de> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Size of PostgreSQL backup ./. Sybase DUMP |
Date: | 2021-04-16 13:47:13 |
Message-ID: | YHmVYdr2uuMIz38Q@c720-r368166.fritz.box |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
We migrated a customer from Sybase ASE 15.7 to PostgreSQL 11.10, both on
Linux server. With Sybase you create DUMP of only the database in
question, not the server, and the gzip'ed DUMP files is around 2,6 GByte in size.
For PostgreSQL we do backup with something like this cmd:
pg_basebackup -U ${DBSUSER} -Ft -z -D ${BACKUPDIR}-${DATE}-${NUM}
The resulting files
# ls -lh backup-20210416-3
insgesamt 999M
-rw------- 1 postgres postgres 999M 16. Apr 14:02 base.tar.gz
-rw------- 1 postgres postgres 17K 16. Apr 14:02 pg_wal.tar.gz
are less than 1 GByte.
Any ideas about the cause of the difference? Can the backup somehow be
checked without doing a recovery-restore in a new server?
Thanks
matthias
--
Matthias Apitz, ✉ guru(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
¡Con Cuba no te metas! «» Don't mess with Cuba! «» Leg Dich nicht mit Kuba an!
http://www.cubadebate.cu/noticias/2020/12/25/en-video-con-cuba-no-te-metas/
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2021-04-16 13:59:09 | Re: Size of PostgreSQL backup ./. Sybase DUMP |
Previous Message | Condor | 2021-04-16 11:19:10 | Re: Question about PG_CONTROL_VERSION 1 |