happysundar
5/15/2014 - 3:31 AM

Commands to backup and restore postgres database

Commands to backup and restore postgres database

postgres_backup_restore.sh
content_copyfile_download
/usr/pgsql-9.3/bin/pg_dump -U <user_name> -d <db_name> -f <backup_file>.sql -h <db_host>
/usr/pgsql-9.3/bin/psql -U <user_name> -d <db_name> -f <backup_file>.sql -h <db_host>