To take backup database in PostgreSQL in ubuntu follow these step in terminal
1- sudo su - postgres
2- psql
3- pg_dump abctest_db > /home/sachin/abc.sql
Here,
abctest_db = is a dbname whose backup I want to take
abc.sql file = this is backup file
/home/sachin/abc.sql= is the path where I am saving the backup.
0 Comment(s)