Example pg_dump command against a render.com postgres instance

I was playing around with pg_dump the other day and had a little bit of trouble getting the parameters just right. Here is the command that worked for me:

pg_dump \
    --file=$OUTFILE \
    --username=$USER \
    --host=dpg-myhost-a.ohio-postgres.render.com \
    --port=5432 \
    $SCHEMA

You’ll then be prompted for your password

No SSL configuration or protocol need to be specified, pg_dump can manage the connection with the above params.