title: clone postgres database with new name
body: <p>I have a <code>users-production</code> database on <code>157.157.35.333</code> </p>
  
  <p>I would like to clone it to another host as <code>users-sandbox</code></p>
  
  <p>here is what I tried:</p>
  
  <pre><code>    PRODUCTION_HOST=111.111.11.111
      SANDBOX_HOST=222.222.22.222
  
      echo "creating db on sanbox"
      psql -h ${SANDBOX_HOST} -U postgres  -c "CREATE DATABASE \"users-sandbox\";"
  
      pg_dump -h ${PRODUCTION_HOST} -U postgres  -d users-production -F c -b -v  | \
         pg_restore -C -c -h ${SANDBOX_HOST} -U postgres  -d users-sandbox -v
  </code></pre>
  
  <p>but this creates the database with the old name</p>
  
  <p>how do I create with a new name?</p>