Jim Archer wrote:
> Hi All...
>
> We are getting ready to put a system into production and a question
> occured to us. Our plan is to use jBoss/Tomcat 2.2.1 with PostgreSQL on
> Debian/Linux. Postgres has a pgdump utility that will allow an online
> backup that is guaranteed correct (from a referential integrity
> standpoint). Of course, we had planned to use commit option 'A' for
> performance reasons.
>
> So, the problem is, how do we do an online backup of a database when
> jBoss is running commit option 'A'? Will a backup be logically
> consistent with jBoss caching EBs and queries and such if we use pgdump
> while jBoss is running? We would prefer not to have to take the server
> down to do a backup.
Under commit option A, entities are still synchronized _to_ the database
on commit, so you won't miss any data. They're not necessarily read
_from_ the database when they join a transaction, but that shouldn't be
a problem with backups.
-danch
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
