RE: Automation/scheduling of Backup stratetgy

From: "Trewern, Ben" <Ben(dot)Trewern(at)mowlem(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: RE: Automation/scheduling of Backup stratetgy
Date: 2000-10-19 16:31:52
Message-ID: 996802F75C3CD411B424001083FA445B0594E4@CET_PONXX_FP001
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

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.
>
>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message pgsql-admin 2000-10-19 18:00:50 Re(2): db server is too slow, real slow
Previous Message Stephan Szabo 2000-10-19 15:55:20 Re: db server is too slow, real slow

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-10-19 17:17:58 Re: make depend (Re: Coming attractions: VPATH build; make variables issue)
Previous Message Peter Eisentraut 2000-10-19 16:14:26 Re: Solaris FAQ