By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,619 Members | 2,698 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,619 IT Pros & Developers. It's quick & easy.

Postgres Restore Performance concerns

P: 1
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.
Jul 3 '18 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.