pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
how do you automate database backups?
4+ messages / 4 participants
[nested] [flat]

* how do you automate database backups?
@ 2005-11-02 00:47 Ferindo Middleton Jr <fmiddleton@verizon.net>
  2005-11-02 16:35 ` Re: how do you automate database backups? Brad Nicholson <bnichols@ca.afilias.info>
  2005-11-02 16:43 ` Re: how do you automate database backups? Robert Treat <xzilla@users.sourceforge.net>
  0 siblings, 2 replies; 4+ messages in thread

From: Ferindo Middleton Jr @ 2005-11-02 00:47 UTC (permalink / raw)
  To: pgsql-admin

Are there tools available to automate backing up databases? I would like 
to setup my PostgreSQL install to automatically backup databases and 
save the file to specific location at specific times of the day with 
little to no user intervention... I'd like to know how to do this in 
both Windows and Linux. I imagine I could write some kind of script or 
something on my Linux server but I have absolutely no idea how to 
implement this on a computer running Windows.

I would imagine this could be implemented through the OS but are there 
built-in features of the database itself that can implement automated 
backups?

Ferindo



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: how do you automate database backups?
  2005-11-02 00:47 how do you automate database backups? Ferindo Middleton Jr <fmiddleton@verizon.net>
@ 2005-11-02 16:35 ` Brad Nicholson <bnichols@ca.afilias.info>
  1 sibling, 0 replies; 4+ messages in thread

From: Brad Nicholson @ 2005-11-02 16:35 UTC (permalink / raw)
  To: pgsql-admin

Ferindo Middleton Jr wrote:

> Are there tools available to automate backing up databases? I would 
> like to setup my PostgreSQL install to automatically backup databases 
> and save the file to specific location at specific times of the day 
> with little to no user intervention... I'd like to know how to do this 
> in both Windows and Linux. I imagine I could write some kind of script 
> or something on my Linux server but I have absolutely no idea how to 
> implement this on a computer running Windows.


On Linux, you'd do as you mentioned write a script to do the dump.  
You'd schedule the script to run at the approriate time using cron.

-- 
Brad Nicholson  416-673-4106    bnichols@ca.afilias.info
Database Administrator, Afilias Canada Corp.





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: how do you automate database backups?
  2005-11-02 00:47 how do you automate database backups? Ferindo Middleton Jr <fmiddleton@verizon.net>
@ 2005-11-02 16:43 ` Robert Treat <xzilla@users.sourceforge.net>
  1 sibling, 0 replies; 4+ messages in thread

From: Robert Treat @ 2005-11-02 16:43 UTC (permalink / raw)
  To: fmiddleton@verizon.net; +Cc: pgsql-admin

On Tue, 2005-11-01 at 19:47, Ferindo Middleton Jr wrote:
> Are there tools available to automate backing up databases? I would like 
> to setup my PostgreSQL install to automatically backup databases and 
> save the file to specific location at specific times of the day with 
> little to no user intervention... I'd like to know how to do this in 
> both Windows and Linux. I imagine I could write some kind of script or 
> something on my Linux server but I have absolutely no idea how to 
> implement this on a computer running Windows.
> 
> I would imagine this could be implemented through the OS but are there 
> built-in features of the database itself that can implement automated 
> backups?
> 

It's not built into the database, you need some function of the os to
run a script that makes use of pg_dump. In 'nix you can use cron, in
winders I believe you can use 'task scheduler'. 


Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: how do you automate database backups?
@ 2005-11-02 21:35 Kevin Grittner <Kevin.Grittner@wicourts.gov>
  0 siblings, 0 replies; 4+ messages in thread

From: Kevin Grittner @ 2005-11-02 21:35 UTC (permalink / raw)
  To: pgsql-admin; fmiddleton@verizon.net

Since you mentioned multiple backups per day, I thought you
might want to look at the the Point In Time Recovery option, as
well as the pg_dump approach.

http://www.postgresql.org/docs/8.0/interactive/backup.html


>>> Ferindo Middleton Jr <fmiddleton@verizon.net>  >>>
Are there tools available to automate backing up databases? I would like

to setup my PostgreSQL install to automatically backup databases and 
save the file to specific location at specific times of the day with 
little to no user intervention... I'd like to know how to do this in 
both Windows and Linux. I imagine I could write some kind of script or 
something on my Linux server but I have absolutely no idea how to 
implement this on a computer running Windows.

I would imagine this could be implemented through the OS but are there 
built-in features of the database itself that can implement automated 
backups?

Ferindo




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2005-11-02 21:35 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-02 00:47 how do you automate database backups? Ferindo Middleton Jr <fmiddleton@verizon.net>
2005-11-02 16:35 ` Brad Nicholson <bnichols@ca.afilias.info>
2005-11-02 16:43 ` Robert Treat <xzilla@users.sourceforge.net>
2005-11-02 21:35 Re: how do you automate database backups? Kevin Grittner <Kevin.Grittner@wicourts.gov>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox