restoring database in postgresql takes a long time

1

I have the following problem. I generate the .backup from my database that weighs 210 megabytes. When I restore from the pgadmin 3 it takes an eternity (it's a whole afternoon or an entire night). I've even restored it from the console thinking that the pgadmin delayed me the restored one, but no, it's just as delayed. The database has 1745 tables and a lot of information, it is mounted on a server with 16 GB of ram. I would like to know if there is any method to restore the database faster, or that delay is normal for a database of these dimensions. Thank you very much

    
asked by julian rincon 27.10.2017 в 18:36
source

0 answers