Hello Robert Thank you for the prompt response. I will try the PostgreSQL jdbc driver tomorrow. Regarding the correction you mentioned, will that be a 2.10.11 release, or ? Basically, how should I check out for it ?
Regards Willie > Hi Willie, > > This looks like a bug that needs to be fixed. I suspect we are not > correctly parsing the URL to get the name of the host and other > information to connect to the database with pg_dump. Here are two > options: > > 1.) Use a regular PostgreSQL JDBC driver rather than the EDB driver. This > is what we normally do. > 2.) Wait a few days for a fix. We will correct this within the next few > days. > > Thanks, Robert > > > On 5/20/08 6:10 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > wrote: > > 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 > > > > -- > Robert Hodges, CTO, Continuent, Inc. > Email: [EMAIL PROTECTED] > Mobile: +1-510-501-3728 Skype: hodgesrm > _______________________________________________ > Sequoia mailing list > [email protected] > https://forge.continuent.org/mailman/listinfo/sequoia ------------------------------------------- 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
