Unanswered: Dumping postgres DB, time and .sql file weight
Hi guys and thank you all in advance,
I have a question regarding postgresql db dump with pg_dump command. Than I have a big db (nominatim db, for address geocoding reverse), is about 408 gb weight.
Now, to provide an estimate to the customer, I would like to know how long will take the export/reimport procedure and how big will .sql dump file be.
My postgresql version is 9.4, is installed on a centOS 6.7 virtual machine, with 16gb RAM and 500 gb disk space.