[GENERAL] replication

2008-06-23 Thread Adrian Moisey
of my DB in the office with as little transfer as possible. A few ideas I've been toying with are rsyncing a dump of the db, or replication. Any ideas? -- Adrian Moisey Systems Administrator | CareerJunction | Your Future Starts Here. Web: www.careerjunction.co.za | Email: [EMAIL PROTEC

[GENERAL] rollback

2008-07-09 Thread Adrian Moisey
Hi I would like to be able to "mark" a point in my postgres database. After that I want to change a few things and "rollback" to that point. Does postgres support such a thing? Is it possible for me to do this? -- Adrian Moisey Systems Administrator | CareerJunction

Re: [GENERAL] rollback

2008-07-09 Thread Adrian Moisey
e a transaction, the term you're looking for is "savepoints". I would like to do this globally over the entire DB, is that possible? -- Adrian Moisey Systems Administrator | CareerJunction | Your Future Starts Here. Web: www.careerjunction.co.za | Email: [EMAIL PROTECTED] Phone: +27 21

Re: [GENERAL] rollback

2008-07-09 Thread Adrian Moisey
d schemas. After that, rollback. No problem. Can I do this outside of a transaction? -- Adrian Moisey Systems Administrator | CareerJunction | Your Future Starts Here. Web: www.careerjunction.co.za | Email: [EMAIL PROTECTED] Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842