On Fri, 2010-06-25 at 23:24 +0530, RP Khare wrote: > I never used PostgreSQL in production environment. Now I got an > opportunity to migrate a MySQL production database to PostgreSQL. > Before migrating, I have few queries on data recovery: > > 1. Is there any feature of scheduled backups?
You can schedule backups anyway you like :). If you are on Windows I believe you can use the job agent stuff in contrib. That might make your life easier. Otherwise you can write a batch file. > 1. In case there is no backup and I want to shift my data files > to a new PC, how to do that? You have to move the whole cluster. (Your data directory) > 1. Are the Redo Logs enabled by default? Yes, its called WAL. Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
