RE: Automation/scheduling of Backup stratetgy

It is already built in. Use pg_dump or pg_dumpall when online. Only problem
is OIDs and large objects. pg_dump -o to keep OIDs not sure about large
objects.

Hope this is what you mean by live/hot backup.

Ben

> -----Original Message-----
> From: Matthew H. North [mailto:ctsmhn(at)cts(dot)com]
> Sent: 19 October 2000 16:41
> To: pgsql-admin(at)postgresql(dot)org
> Subject: [ADMIN] Automation/scheduling of Backup stratetgy
>
>
>
> Any word on when (if?) live/hot backup will be available?
>
> Matthew H. North
> Software Engineer
> CTSnet Internet Services
> t (858) 637-3600
> f (858) 637-3630
> mailto:ctsmhn(at)cts(dot)com
>
> -----Original Message-----
> From: pgsql-admin-owner(at)hub(dot)org [mailto:pgsql-admin-owner(at)hub(dot)org]On
> Behalf Of Michel Decima
> Sent: Thursday, October 19, 2000 6:04 AM
> To: pgsql-admin(at)postgresql(dot)org; CScheepers(at)mweb(dot)com
> Subject: Re: [ADMIN] Automation/scheduling of Backup stratetgy
>
>
> >Is it posible to schedule / automate a backup task and
> functions to execute
> >at a pre-defined time at a pre-defined recurrence rate?
>
> yes, using the cron daemon and the commands pg_dump or pg_dumpall.
>
> The following entry in the postgres user crontab will backup the
> database every day at 03:01 AM in /dev/null (very usefull)
>
> 1 3 * * * /usr/local/pgsql/bin/pg_dumpall > /dev/null
>
> just look at
> man cron
> man crontab
> man pg_dumpall
>
> MD.
>
>