Re: Size of PostgreSQL backup ./. Sybase DUMP

From: "Wolff, Ken L" <ken(dot)l(dot)wolff(at)lmco(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Size of PostgreSQL backup ./. Sybase DUMP
Date: 2021-04-16 14:06:39
Message-ID: 48541fc7939d44969042cdc183b33b82@lmco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 best test for a backup is to restore it.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

FWIW, if this is of any help, Sybase dumps are conceptually very similar to those of MS SQL Server. That being said, I don't have any other insight to offer but hoping this might help someone else.

- Ken W

Browse pgsql-general by date

  From Date Subject
Next Message greg1457 2021-04-16 15:30:12 vaccumdb fails saying function unaccent(text) doesn't exist
Previous Message Laurenz Albe 2021-04-16 13:59:09 Re: Size of PostgreSQL backup ./. Sybase DUMP