Can't import dump database to PostgreSQL
<p>I'm using pybossa and PostgreSQL. 
My list of databases are like this:</p>

<p><a href="https://i.stack.imgur.com/2qyKZ.png" rel="nofollow"><img src="https://i.stack.imgur.com/2qyKZ.png" alt="db"></a>
I have a dump collection for pybosssa database named: <code>pybossa-db-oct2-final.bak</code></p>

<p>I want to import it on the pybossa db. The problem is that I'm not so familiar with PostgreSQL. I checked this page <a href="https://www.postgresql.org/docs/9.5/static/backup-dump.html" rel="nofollow">https://www.postgresql.org/docs/9.5/static/backup-dump.html</a> but there are some instructions only for compressed dumps but not for <code>.bak</code> files.</p>

<p>I tried like this: </p>

<pre><code>pg_dump pybossa pybossa-db-oct2-final.bak
</code></pre>

<p>But this didn't work? I need help can someone help me, please?</p>

<p>Edit: </p>

<p>I tried this command:</p>

<pre><code> pg_restore -d pybossa /home/sagar/Download/sample_dbump
</code></pre>

<p>I get this: </p>

<pre><code>perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
    LANGUAGE = (unset),
    LC_ALL = (unset),
    LC_CTYPE = "UTF-8",
    LANG = "en_US.UTF-8"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
pg_restore: [archiver] could not open input file "/home/sagar/Download/sample_dbump
": No such file or directory
</code></pre>

<p>In this <code>/home/sagar/Download/sample_dbump</code> my file <code>pybossa-db-oct2-final.bak</code> is found, I used <code>pwd</code> command to define the path</p>