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.
Thanks
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.
Thanks