title: Dumping postgres DB, time and .sql file weight
body: <p>I have a big db (nominatim db, for address geocoding reverse), is about 408gb big.</p>
  
  <p>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.</p>
  
  <p>Can you help me?</p>
  
  <p>Thank you all guys for your answer, anyway to restore the dumped db I don't use the command <code>pg_restore</code> but <code>psql -d newdb -f dump.sql</code> (I read this way to do in a official doc). This because I have to set-up this db on another machine to avoid the nominatim db indexing procedure! I don't know if someone knows nominatim (is a openstreetmap opensource product) but the db indexing process of European map (15.8 gb), in a CentOS 6.7 machine with 16gb ram tooks me 32 days...
  Than another possible question should be: <code>pg_restore</code> is equal to <code>psql -d -f</code>? Wich is faster?</p>
  
  <p>Thanks again</p>