Postgres Pro
Downloads
Home   >   mailing lists

Re: Restoration query - Mailing list pgsql-admin

From Wasim Devale
Subject Re: Restoration query
Date
Msg-id CAB5fag5QvYec+0Tmyq08FXc5q+jkt6mSHOKR8aAwFua_Q8W6kQ@mail.gmail.com
Whole thread Raw
In response to Re: Restoration query  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view

I found some unusual it is not related to vaccum it is related to metadata stored in a table.

That table has only 1 lakh rows but it shows 97 GB of size anything you know about this?

On Sun, 28 Jul, 2024, 10:31 am David G. Johnston, <david.g.johnston@gmail.com> wrote:
On Saturday, July 27, 2024, Wasim Devale <wasimd60@gmail.com> wrote:

So the live data is not getting restored? Did not get you. I have checked the same data has been transferred to the tables rows match.


If you aren’t comparing vacuum full tables in the source database why do you expect the sizes to match?

David J.

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Restoration query
Next
From: Wasim Devale
Date:
Subject: Stream pg_dumpall directly from CentOS7 to Red Hat server