Hi, You can also do
Backuper backuperName="PostgreSQL" className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLPlainTextBackuper" options="dumpServer= x.x.x.x,pgDumpFlags=-i"/ On Wed, 26 Sep 2007 21:47:26 -0700 Robert Hodges <[EMAIL PROTECTED]> wrote: > Dear Christopher: > > Aha! We thought of a solution already. Look at the ScriptBackuper > class. It calls a shell script that wraps arbitrary backup > commands. Using ScriptBackuper you can invoke the PostgreSQL > pg_backup and pg_restore in any way you please. The Javadoc class > description should give you the information required to get started. > > Cheers, Robert > > Robert Hodges, CTO, Continuent, Inc. > Email: [EMAIL PROTECTED] > Mobile: +1-510-501-3728 Skype: hodgesrm > > > On Sep 26, 2007, at 8:36 PM, Christopher Gorge A. Marges wrote: > > > If the controller is installed on a different machine, > > the postgresql backuper wont work because it needs the > > postgres binaries (i.e., pg_dump). This means an > > *identical* version of postgres needs to be installed > > (the reason why the versions needs to be the same is > > because the pg_dump will complain about it unless a -i > > parameter is passed onto it). > > > > Here is the log (from full_cluster.log) > > 2007-09-26 19:49:26,093 INFO > > backup.backupers.NativeCommandExec Starting execution > > of "pg_dump -h 192.168.5.141 -p 5432 -U postgres -f > > test1.dump/pgtest1dump.sql sq" > > 2007-09-26 19:49:26,120 INFO > > backup.backupers.NativeCommandExec Command "pg_dump -h > > 192.168.5.141 -p 5432 -U postgres -f > > test1.dump/pgtest1dump.sql sq" logged 2 errors and > > terminated with exitcode 1 > > 2007-09-26 19:49:26,121 INFO > > backup.backupers.AbstractPostgreSQLBackuper pg_dump: > > server version: 8.2.4; pg_dump version: 8.2.3 > > 2007-09-26 19:49:26,121 INFO > > backup.backupers.AbstractPostgreSQLBackuper pg_dump: > > aborting because of version mismatch (Use the -i > > option to proceed anyway.) > > 2007-09-26 19:49:26,125 ERROR > > backup.backupers.PostgreSQLPlainTextBackuper Error > > while performing backup > > org.continuent.sequoia.common.exceptions.BackupException: > > pg_dump execution did not complete successfully! > > > > > > > > In summary the following should be an ideal design: > > The backuper should use the binary on the database > > server. This also simplifies the installation > > (install postgres on the db node only), as well as > > eliminates the version problem. > > > > If that is not possible, at least allowing to pass > > extra parameters to the backuper would be a temporary > > solution. > > > > > > > > > > Christopher Gorge A. Marges > > [EMAIL PROTECTED](recommended) > > > > [EMAIL PROTECTED] > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > ______________________________________________________________________ > > ______________ > > Check out the hottest 2008 models today at Yahoo! Autos. > > http://autos.yahoo.com/new_cars.html > > _______________________________________________ > > Sequoia mailing list > > [email protected] > > https://forge.continuent.org/mailman/listinfo/sequoia > -- Stuart James Senior Systems Administrator PayPoint Internet Payment Services 203 High Street, Tonbridge TN9 1BW, UK Direct: +44 (0)1732 300205 Mobile: +44 (0)7809 504773 SECPay Ltd registered offices. 1 The Boulevard, Shire Park, Welwyn Garden City, Hertfordshire, AL7 1EL This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. SECPay Ltd does not accept responsibility for changes made to this message after it was sent. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by SECPay Ltd in this regard and the recipient should carry out such virus and other checks as it considers appropriate. _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
