Hello Laurenz,
Thank you so much for sending the query. It was exactly what I needed. I
just made 1 modification to beautify the transfer and replay lag and I can
see the size in bytes.
SELECT application_name,
pg_size_pretty(pg_wal_lsn_diff(pg_current_wal_lsn(), flush_lsn)) AS
transfer_lag,
p
Thank you Laurenz! I have a second question. I downloaded postgreSQl 11.11
to upgrade from 11.2. I am having trouble upgrading postgresql, it is
trying to install a new postgreSQL instead of upgrading.
On Thu, Apr 15, 2021 at 5:08 AM Laurenz Albe
wrote:
> On Wed, 2021-04-14 at 16:10 -0700, Mori
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
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
