> Is there a way to automate the backup databases using pg_dump (like in> SQL server)?
You can use cron to automate your backup process with pg_dump.
regards,bhuvaneswaran