PostGreSQL Backup fails a restore with FATAL message and connection termination
- Views:
- 16
- Visibility:
- Public
- Votes:
- 0
- Category:
- snapcenter
- Specialty:
- snapx
- Last Updated:
- 4/15/2025, 3:26:43 PM
Applies to
- SnapCenter Plug-in for Creator
- PostGreSQL Plug-in from 6.0, 6.0.1,...
Issue
When running a restore for a PostGreSQL database, the following occurs, ending in FATAL error:
com.netapp.plugincreator.agent.nextgen.executionmanager.OperationExecutorImpl -Trying to call method restorePre with classloader com.netapp.plugincreator.agent.nextgen.pluginfactory.PluginClassLoader$ChildURLClassLoader@1922e6d
Starting execution of the command : [su, -, postgres, /bin/sh, -c, /usr/pgsql-17/bin/pg_ctl -D /testvol/postgres/TEST/PGDATA status]
Command execution completed with exitCode:0
com.netapp.snapcenter.plugin.common.operation.OperationExecutor -org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command
java.util.concurrent.ExecutionException: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command
java.util.concurrent.ExecutionException: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command
at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
at com.netapp.snapcenter.plugin.common.operation.OperationExecutor.waitOnFutureTasks(OperationExecutor.java:119)
at com.netapp.snapcenter.plugin.common.operation.OperationExecutor.executeOperationOnResources(OperationExecutor.java:66)
at com.netapp.snapcenter.plugin.PostgreSQL.PostgreSQL.executeOperation(PostgreSQL.java:123)