What utility to administer PostgreSQL?

Question

CentOS

Good afternoon.
I set up my project on Django on CentOS 7. I installed
everything via PuTTY - and uploaded files via SSH (FileZilla).
Now I want to set up work with the database (backups) - PostgreSQL.
Question: are there any convenient utilities and ways to do this, or is it again PuTTY and the console?

Answer 1

There is a graphical pgAdminIII. They can connect to the database via ssh, you can make a backup copy and restore from it. Sometimes this is enough.
For more advanced settings, I still recommend using command line utilities. On the organization of backup copying, you can read / look at the DBA1 course record

Answer 2

psql