|
Hi,
I'm now trying 1,5 day to get Sequoia to work with
Postgres (the backup/restore part). I started using a Windows machine with
Postgres on it, but couldn't get it to work. I'm getting an error on "CREATE PROCEDURAL LANGUAGE plpgsql;" that is in de dump file.
After a while I gave up and installed Postgres (7.4.7) on a
Debian Linux machine (latest version from stable) and configured Sequoia. First
I couldn't get the restore to work because it looks like the user must be a
superuser or the restore will return an error on "SET SESSION AUTHORIZATION
'postgres';". So I made the user a superuser. After that the restore finishes
successfull with a notice like 'pg_restore: NOTICE: ALTER TABLE / ADD
PRIMARY KEY will create implicit index "student_pkey" for table "student"'. But
because the notice is outputted Sequoia thinks this is an error and the restore
won't finish successfull. The output from the controller is like the message at
the bottom.
I hope someone can help me with this, because I'm getting a headache from it. Tnx, Igor ------------------------------------- 15:27:35,735 INFO backup.backupers.NativeCommandExec Command "dropdb
-h localhost -p 5432 -U test test2" logged 0 errors and terminated
with exitcode 0
15:27:36,354 INFO backup.backupers.NativeCommandExec Command "createdb -h localhost -p 5432 -U test test2" logged 0 errors and terminated with exitcode 0 15:27:36,678 INFO backup.backupers.NativeCommandExec Command "pg_restore -h localhost -p 5432 -U test --format=t -d test2 /tmp/backup/init_dump.tar test2" logged 1 errors and terminated with exitcode 0 15:27:36,679 INFO backup.backupers.AbstractPostgreSQLBackuper pg_restore: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "student_pkey" for table "student" 15:27:36,722 ERROR backup.backupers.PostgreSQLTarBackuper Error while performing backup org.continuent.sequoia.common.exceptions.BackupException: pg_restore execution did not complete successfully! at org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackTrace(SequoiaException.java:103) at java.lang.Throwable.<init>(Unknown Source) at java.lang.Exception.<init>(Unknown Source) at org.continuent.sequoia.common.exceptions.SequoiaException.<init>(SequoiaException.java:57) at org.continuent.sequoia.common.exceptions.BackupException.<init>(BackupException.java:50) at org.continuent.sequoia.controller.backup.backupers.PostgreSQLTarBackuper.restore(PostgreSQLTarBackuper.java:376) at org.continuent.sequoia.controller.requestmanager.RequestManager.restoreBackendFromBackupCheckpoint(RequestManager.java:2921) at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.restoreDumpOnBackend(VirtualDatabase.java:2608) at org.continuent.sequoia.controller.virtualdatabase.management.VirtualDatabase.restoreDumpOnBackend(VirtualDatabase.java:488) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jmx.mbeanserver.StandardMetaDataImpl.invoke(Unknown Source) at javax.management.StandardMBean.invoke(Unknown Source) at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(Unknown Source) at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(Unknown Source) at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(Unknown Source) at org.continuent.sequoia.controller.jmx.ChainedMBeanServer.invoke(ChainedMBeanServer.java:318) at org.continuent.sequoia.controller.jmx.AuthenticatingMBeanServer.invoke(AuthenticatingMBeanServer.java:127) at javax.management.remote.rmi.RMIConnectionImpl.doOperation(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl.access$100(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl.invoke(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source) at sun.rmi.transport.Transport$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Unknown Source) at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 15:27:36,756 ERROR controller.RequestManager.myDB Recovery could not complete org.continuent.sequoia.common.exceptions.BackupException: pg_restore execution did not complete successfully! at org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackTrace(SequoiaException.java:103) at java.lang.Throwable.<init>(Unknown Source) at java.lang.Exception.<init>(Unknown Source) at org.continuent.sequoia.common.exceptions.SequoiaException.<init>(SequoiaException.java:57) at org.continuent.sequoia.common.exceptions.BackupException.<init>(BackupException.java:50) at org.continuent.sequoia.controller.backup.backupers.PostgreSQLTarBackuper.restore(PostgreSQLTarBackuper.java:376) at org.continuent.sequoia.controller.requestmanager.RequestManager.restoreBackendFromBackupCheckpoint(RequestManager.java:2921) at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.restoreDumpOnBackend(VirtualDatabase.java:2608) at org.continuent.sequoia.controller.virtualdatabase.management.VirtualDatabase.restoreDumpOnBackend(VirtualDatabase.java:488) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jmx.mbeanserver.StandardMetaDataImpl.invoke(Unknown Source) at javax.management.StandardMBean.invoke(Unknown Source) at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(Unknown Source) at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(Unknown Source) at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(Unknown Source) at org.continuent.sequoia.controller.jmx.ChainedMBeanServer.invoke(ChainedMBeanServer.java:318) at org.continuent.sequoia.controller.jmx.AuthenticatingMBeanServer.invoke(AuthenticatingMBeanServer.java:127) at javax.management.remote.rmi.RMIConnectionImpl.doOperation(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl.access$100(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl.invoke(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source) at sun.rmi.transport.Transport$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Unknown Source) at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 15:27:36,757 INFO controller.RequestManager.myDB Recovery of backend ge2db done. ---------------------------------------------------
|
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
