postgresql - How to backup a huge Postgres database

Question

I have a table with 2.5 million rows and want to export it to a .sql file using pgAdmin4. After the completion of the export to .sql file, the file can not be opened, because it is too large. So, now I don't know whether my table has been backed up or not.

What are some other ways to backup such a huge PostgreSQL database, so that I can easily transfer my table to my second laptop.

question from:https://stackoverflow.com/questions/65854579/how-to-backup-a-huge-postgres-database

Answer 1

Waitting for answers