Hi everyone,
I’m currently using Aiven for my PostgreSQL database and would like to export all of my data. Could someone guide me on the best way to do this? Are there any tools or Aiven-specific features I should consider?
Thanks in advance for your help!
Hi Nikhil Kalloli
There’s a few different ways of doing this.
The simplest way is to use pg_dump, but this works best if you don’t need to keep the Aiven database in sync with whatever your target is. You can also use Aiven’s pghoard tool, which is a more reliable pg_dump.
Where are you migrating the database to?