Archive for January, 2022

Backup all the databases in postgres

Saturday, January 15th, 2022
pg_dumpall > all_pg_dbs.sql

Backup database in postgres

Saturday, January 15th, 2022
pg_dump tecmintdb > tecmintdb.sql

Check database size in Postgres

Saturday, January 15th, 2022

SELECT pg_size_pretty(pg_database_size(‘CreatioProDB’));

or

you can run the following command

postgres=# \l+ forumdb