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

Size of PostgreSQL backup ./. Sybase DUMP

2021-04-16 Thread Matthias Apitz
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_base