You can use pg_restore to restore a db. ( Try pg_restore --help )
You can use a cron job to run it everyday.
But don't you mean Backup the database?
-Dennis
Jacky Cheang wrote:
> Dear sir/mdm,
>
> How do I automatic restore a database everyday in the morning?
>
>
>
>
> Pls advise,
>
> Jacky
>