snipt

Ctrl+h for KB shortcuts

Text only

copy psql db from local to remote

pg_dump -C dbname | bzip2 | ssh  [email protected] -p 99 "bunzip2 | psql dbname"
https://snipt.net/embed/42502787170385059b0bf15f30bd5313/
/raw/42502787170385059b0bf15f30bd5313/
42502787170385059b0bf15f30bd5313
text
Text only
2
2019-08-19T07:26:52
True
False
False
/api/public/snipt/10416/
copy-psql-db
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>pg_dump -C dbname | bzip2 | ssh [email protected] -p 99 &quot;bunzip2 | psql dbname&quot; </span></pre></div> </td></tr></table>
db, dump, psql