SysAdmin

Thomas Bucaioni

<div>
<div class="content wysiwyg-content fr-view">
<p>We need to backup a PostgreSQL database. But it seems the version of it is too old and when the dump is done, we can't import it.</p><p>We're about to export the tables one by one with a script and import them one by one too. Any better idea maybe?</p><p><br></p><p>(Secondary question: my tunnel <strong>ssh psql-server -L 5432:127.0.0.1:5432</strong> doesn't work, would you see the error?)</p>
</div>
</div>



We need to backup a PostgreSQL database. But it seems the version of it is too old and when the dump is done, we can't import it.
We're about to export the tables one by one with a script and import them one by one too. Any better idea maybe?
(Secondary question: my tunnel
ssh psql-server -L 5432:127.0.0.1:5432
doesn't work, would you see the error?)

[psql] backup doesn't work due to different versions

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.

PostgreSQL

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.