Re: Database size will be Huge difference while Restoring

2023-05-22 Thread Adrian Klaver
On 5/22/23 04:38, Rajmohan Masa wrote: Hi Adrian, I Found one thing in my base Directory. Generally we are having OID in the Base Directory with a unique OID But in my machine I found some object Id's with sequence like 121193051,121193051.1 121193051.1200 and each file having the same

Re: Database size will be Huge difference while Restoring

2023-05-05 Thread Adrian Klaver
On 5/5/23 10:55 AM, Rajmohan Masa wrote: Hi Adrian, Are both the above the same for the original and restored database? We are using a Windows server so By Using the PgAdmin4 tool, I'm taking Backup and restore. From here https://www.pgadmin.org/docs/pgadmin4/7.1/restore_dialog.html you

Re: Database size will be Huge difference while Restoring

2023-05-05 Thread Adrian Klaver
On 5/5/23 10:55 AM, Rajmohan Masa wrote: Please reply to list also. Ccing list. Hi Adrian, Are both the above the same for the original and restored database? No, * * *Backup Server Details:* Postgres version : *PostgreSQL 14.5* OS and version : *Windows server 2019 Datacenter* *Restore

Re: Database size will be Huge difference while Restoring

2023-05-05 Thread Adrian Klaver
On 5/5/23 08:35, Rajmohan Masa wrote: Hi Team, I took Postgres database Backup through Directory format with compression.These are the details Postgres version? OS and version? Are both the above the same for the original and restored database? Provide the commands you used to arrive at

Database size will be Huge difference while Restoring

2023-05-05 Thread Rajmohan Masa
Hi Team, I took Postgres database Backup through Directory format with compression.These are the details Database Size: *3985 GB* Backup file Size will be* 212 GB.* After that I Restored this backup file (212GB), but I'm getting Database size will be 456 GB. So immediately I checked with *Table