Re: Size of PostgreSQL backup ./. Sybase DUMP

2021-04-17 Thread Thomas Kellerer
Matthias Apitz schrieb am 17.04.2021 um 08:59: As I said, the Sybase DUMP command dumps a single database, i.e. works more like pg_dump of PostgreSQL. Ofc, they're like apples and oranges, but the netto data of the tables must be written to disk, and as I said above in both cases compressed with

Re: Size of PostgreSQL backup ./. Sybase DUMP

2021-04-17 Thread Matthias Apitz
El día viernes, abril 16, 2021 a las 03:59:09p. m. +0200, Laurenz Albe escribió: > On Fri, 2021-04-16 at 15:47 +0200, Matthias Apitz wrote: > > 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 > > questio

Re: Size of PostgreSQL backup ./. Sybase DUMP

2021-04-16 Thread Wolff, Ken L
I don't know anything about Sybase, but if that dump is something akin to "pg_dump", then you are comparing apples and oranges. Moreover, the base backup is compressed, and I don't know if the Sybase dump is. If you had used PostgreSQL v13, you could check the backup for completenes. But the be

Re: Size of PostgreSQL backup ./. Sybase DUMP

2021-04-16 Thread Laurenz Albe
On Fri, 2021-04-16 at 15:47 +0200, Matthias Apitz wrote: > 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 Pos