Hi,
I migrated a MySQL database to pgsql 9.0.1. I have never used pgsql before and therefore want to learn all the possible ways to keep the database up and running. Following are my queries:
If pgsql service fails to start or due to any reason pgsql database is not connecting, how to restart the service. Where to check for errors?Imagine a scenario where there is no backup of the database and all I have is the present installation. I want to move my existing database to another PC where a fresh installation of pgsql awaits. Which are those files that need to be moved and how to attach these files on the other installation?I want to enable all types of Redo logs like things and all types of backup options. I also want to take automatic scheduled backups. How to do this?
Regards,
Rohit P. Khare