Quote:
Originally Posted by scubak1w1 
Hello,
What is a good approach to PostgreSQL backups? (yep, a newbie)
(The server crashed and IT was not able to bring it back from the Acronis images - so rebuilding from scratch - ugh! - want to have a secondary system, that lesson is learnt!)
Ideally, having the compressed backup that pgAdmin is able to do run on some sort of Task Scheduler would be ideal... but seemingly no functionality for this...
There actually is. If you look at the backup window in pg_admin, you'll see that it's running a command called pg_dump.exe. Take the whole command line that is running and you can have task scheduler run that for you automatically.
Quote:
So presumably write a DOS (sic) script to do a
pg_dump once a week for every database and a
pg_dumpall for the whole cluster (so I get the groups, roles, etc) say every month?? (to a separate network location)
You can just do a pg_dumpall -g to get only the users / groups / tablespaces, you don't need to actually dump EVERYTHING out.
Quote:
Is there a 'lessons learned' style documentation online that I can ingest?
I was reading about Slony - but for the size of the database cluster (at least presently) it seems overkill? Or should I look at that?
slony probably is overkill, take a look at point in time recovery (PITR)
http://www.enterprisedb.com/docs/en/...archiving.html
--
Scott Mead
EnterpriseDB
