Hello all :) I'm busy setting up a proof of concept on two nodes using Sequoia 2.10.10 and Postgres Plus Advanced Server 8.3 on Red Hat 5.1 with JDK 6 Update 6. I can start the controllers on both nodes, however I still need to create the dump, and restore it to the other nodes before I can continue (page 49 of the installation guide).
I log onto node 1, and try to perform the following: localhost:1090 > admin Virtual Database Name > myDB Virtual database Administrator Login > admin Virtual database Administrator Password > Ready to administrate virtual database myDB myDB(admin) > backup localhost1 initial_dump.sql PostgreSQL /tmp/ Backend login for backup process > enterprisedb Backend password for backup process > Backup backend localhost1 in dump file initial_dump.sql pg_dump execution did not complete successfully! I open the tab for controller 1: 14:53:49,450 INFO backup.backupers.NativeCommandExec Starting execution of "pg_dump -h null -p null -U enterprisedb -f /tmp/initial_dump.sql.sql null" 14:53:49,497 INFO backup.backupers.NativeCommandExec Command "pg_dump -h null -p null -U enterprisedb -f /tmp/initial_dump.sql.sql null" logged 1 errors and terminated with exitcode 1 14:53:49,497 INFO backup.backupers.AbstractPostgreSQLBackuper pg_dump: [archiver (db)] connection to database "null" failed: could not translate host name "null" to address: Name or service not known 14:53:49,499 ERROR backup.backupers.PostgreSQLPlainTextBackuper Error while performing backup org.continuent.sequoia.common.exceptions.BackupException: pg_dump execution did not complete successfully! And the config file looks like: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.10//EN" "http://sequoia.continuent.org/dtds/sequoia-2.10.10.dtd";> <SEQUOIA> <VirtualDatabase name="myDB"> <Monitoring> <SQLMonitoring defaultMonitoring="off"> <SQLMonitoringRule queryPattern="^select" caseSensitive="false" applyToSkeleton ="false" monitoring="on"/> </SQLMonitoring> </Monitoring> <Backup> <Backuper backuperName="PostgreSQL" className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLPlainTextBackuper" options=""/> </Backup> <AuthenticationManager> <Admin> <User username="admin" password="admin"/> </Admin> <VirtualUsers> <VirtualLogin vLogin="user" vPassword="user"/> </VirtualUsers> </AuthenticationManager> <DatabaseBackend name="localhost1" driver="com.edb.Driver" url="jdbc:edb://10.0.0.80:5432/db1" connectionTestStatement="select 1"> <ConnectionManager vLogin="user" rLogin="user" rPassword="user"> <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> </ConnectionManager> </DatabaseBackend> <DatabaseBackend name="localhost2" driver="com.edb.Driver" url="jdbc:edb://10.0.0.81:5432/db1" connectionTestStatement="select 1"> <ConnectionManager vLogin="user" rLogin="user" rPassword="user"> <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> </ConnectionManager> </DatabaseBackend> <RequestManager> <RequestScheduler> <RAIDb-1Scheduler level="passThrough"/> </RequestScheduler> <RequestCache> <MetadataCache/> <ParsingCache/> <!-- <ResultCache granularity="table"/> --> </RequestCache> <LoadBalancer> <RAIDb-1> <WaitForCompletion policy="first"/> <RAIDb-1-LeastPendingRequestsFirst/> </RAIDb-1> </LoadBalancer> <RecoveryLog driver="com.edb.Driver" url="jdbc:edb://10.0.0.80:5432/reclog" login="user" password="user"> <RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT NOT NULL" vloginColumnType="VARCHAR NOT NULL" sqlColumnType="VARCHAR NOT NULL" extraStatementDefinition=",PRIMARY KEY (log_id)"/> <CheckpointTable tableName="CHECKPOINT" checkpointNameColumnType="VARCHAR NOT NULL"/> <BackendTable tableName="BACKEND" databaseNameColumnType="VARCHAR NOT NULL" backendNameColumnType="VARCHAR NOT NULL" checkpointNameColumnType="VARCHAR NOT NULL"/> <DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR NOT NULL" dumpDateColumnType="TIMESTAMP" dumpPathColumnType="VARCHAR NOT NULL" dumpFormatColumnType="VARCHAR NOT NULL" checkpointNameColumnType="VARCHAR NOT NULL" backendNameColumnType="VARCHAR NOT NULL" tablesColumnType="VARCHAR NOT NULL"/> </RecoveryLog> </RequestManager> </VirtualDatabase> </SEQUOIA> ----------------------------------------------------------------------------------------- What am I doing wrong that makes the controller wanting to pass 'null' as parameters to pg_dump ? Any help is appreciated. Regards Willie ------------------------------------------- South Africas premier free email service - www.webmail.co.za ------------------------------------------------------------------ For super low premiums, click here http://www.webmail.co.za/dd.pwm _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
