Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-hackers by date

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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group