user12: Db-sync takes about 48 hours to follow the tip, starting from a fresh installation fully. Is there a way to improve the sync time? Is it possible to dump the database and transfer it to a fresh installation?

user28: You cannot dump the PostgreSQL directly, as cardano-db-sync depends on other states as well.
You need to use the cardano-db-tool to take and restore the snapshot.

user899: You can use the official snapshots, provided by IOHK. Just restore them after setting up the database.
They are usually linked in the release description on Github: https://github.com/input-output-hk/cardano-db-sync/releases
You will find a link to the list of snapshots, grouped by schema version.
As of today, the current schema version is 11 and the list of snapshots are listed here: https://update-cardano-mainnet.iohk.io/cardano-db-sync/index.html#11/

12: <p>Db-sync takes about 48 hours to follow the tip, starting from a fresh installation fully. Is there a way to improve the sync time? Is it possible to dump the database and transfer it to a fresh installation?</p>
 28: <p>You cannot dump the PostgreSQL directly, as <code>cardano-db-sync</code> depends on other states as well.</p>
<p><a href="https://github.com/input-output-hk/cardano-db-sync/blob/master/doc/state-snapshot.md" rel="nofollow noreferrer">You need to use the <code>cardano-db-tool</code></a> to take and restore the snapshot.</p>
 899: <p>You can use the official snapshots, provided by IOHK. Just restore them after setting up the database.</p>
<p>They are usually linked in the release description on Github: <a href="https://github.com/input-output-hk/cardano-db-sync/releases" rel="nofollow noreferrer">https://github.com/input-output-hk/cardano-db-sync/releases</a></p>
<p>You will find a link to the list of snapshots, grouped by schema version.</p>
<p>As of today, the current schema version is 11 and the list of snapshots are listed here: <a href="https://update-cardano-mainnet.iohk.io/cardano-db-sync/index.html#11/" rel="nofollow noreferrer">https://update-cardano-mainnet.iohk.io/cardano-db-sync/index.html#11/</a></p>
