Differential Backups in Windows server

[Rajmohan Masa]

Hi Team,
Is it possible to take differential Backup in* Windows Server ? *If
possible please explain clearly?
I tried with different scenarios but I'm unable to take *Diff Backup* of
the postgresql database  in *Windows server.*

*Much appreciated for Response.*


*Thank you,*
*Rajamohan M.*

Database size will be Huge difference while Restoring

[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 Bloats,latest statistics and last
vacuum status*. After that I applied "*Vacuum Full Verbose analyze*" and "
*Reindex*  " on that Database. Here I achieved Database size will be R*educed
from 3985 GB to 2582GB.*

After this process,again I took  Backup through Directory format with
compression.These are the details
Database Size: *2582 GB*
Backup file Size will be* 212 GB.*

After that I Restored this backup file (212 GB), but I'm getting Database
size will be 456 GB.

Here I checked with Object Counts, I'm getting the same count in Both Db's.

*why am I unable to get Original Database size/Approximately nearby
original DB size in restore location ?*



Thanks & Regards,
Rajamohan M.

[no subject]

[Rajmohan Masa]

Hi Team,

1. We are using Windows server . How to set up Kerberos authentication?
2.How to set up/create/use SSPI authentication?
3.Like MSSQL server windows authentication is it possible in postgresql
server?

I tried to search through Google,youtube and chatgpt also. I'm unable to
get clarity on these 3 Questions so please help me out.
[image: image.png]

Thanks & Regards,
Rajamohan M.