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

[Ian Gilbert]

I am also running PG 7.4.2.  I now have two systems running at the same
time.  One is the live and one a staging server.  I also have a
development system on my workstation.  The first two have similar
databases underneath them.  When I want to duplicate my live system for my
development box I do the following

Do a database dump:
pg_dump -F c stuff > stuff.dump

Then restore it onto the staging or development server (workstation):
pg_restore -d newdatabasename stuff.dump

I don't have to take the server down to do this and it seems to work a
treat.  I find this particularly useful as my machines aren't too powerful
so if I want to analyse data without bringing my system to a crawl then I
can do the dump (excuse the expression), compress it, scp it to my
localhost and perform analysis locally.

Hope this helps

Ian


> 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
>
>


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