Folks, I am considering moving from SQL Server to Postgres. The per core licensing of SQL Server is too expensive for my needs.
My one concern is restoring Postgres from a dump. I believe that the pg_dump creates a file of SQL commands to build back up the DB and that this can be quite slow.
I am used to restoring large SQL Server databases in quite a short period of time.
Can anyone advise me here on what folks do for performant disaster recover solutions?
I am installing postgres on windows, so barman etc are probably not an option and without some backup software I would be concerned about doing WAL point in time restores manually. I believe you need to shut down the server and restore everything and that seems severe.