[OFBiz] Users - Backup and Restore OFBIZ Data / Postgres

[Lance Goodship]

I use replication between active and passive database instances, so that I
have point in time recovery. Then if you want to archive your data you can
do a cold system back-up on the passive node without the site going down.
This is pretty easy with MySQL, but I presume with Postgres there must be
similar features. I know there are hot back-up scripts with open source
databases but generally you have to pay fairly big license fees to obtain
them.

-----Original Message-----
From: mpf at zentric.com [mailto:mpf at zentric.com] 
Sent: 05 August 2004 10:43
To: users at ofbiz.dev.java.net
Subject: [Norton AntiSpam] [OFBiz] Users - Backup and Restore OFBIZ Data /
Postgres

I would like to setup some docs in the wiki on how to backup / restore 
ofbiz data.

I tested it with native functionality of postgres
pg_dump -C $SOURCEDB | psql -d $TARGETDB -U $OWNER_OF_TARGETDB
but that just throws a lot of errors. 

Im using postgres 7.4.2.

Now does anybody do regulary backup and restore their postgres odbizdb? 
Any hints appreciated!

everbody welcome to improve some standard operating procedures for ODBIZ 
/Postgress Administration
http://ofbizwiki.go-integral.com/Wiki.jsp?page=UsingPostgres


mit freundlichen Grüssen/ Kind regards / muchos saludos
--
Dipl. Wirt.-Ing. (FH) Michael Pfurtscheller, Geschäftsführer
zentric  GmbH & Co. KG
mobil: +49-172-5457143
fon: +49-6101-556060
fax: +49-6101-556065
icq# 8724822
mailto:michael.pfurtscheller at zentric.com
http://www.zentric.com

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at ofbiz.dev.java.net
For additional commands, e-mail: users-help at ofbiz.dev.java.net



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at ofbiz.dev.java.net
For additional commands, e-mail: users-help at ofbiz.dev.java.net