Thanks Jeff for your quick response. I inherited this system and they had cron job which uses pg_dump for back up. I recently used to rsync to bring back my hot standby when it was out of sync and offline for few days because of space issue. That is when the thought that I might be able to use rsync to clone database.
If I understood your reply correctly, you are currently using rsync for both clone and backup. Is that correct? Thanks Again. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Clone-database-using-rsync-tp5777141p5777150.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general