backup PostgresQL-Clusters 10

Last post 08-17-2018, 6:02 AM by smithse. 0 replies.
Sort Posts: Previous Next
  • backup PostgresQL-Clusters 10
    Posted: 08-17-2018, 6:02 AM

    Hi,

     

    we had some problems with an PostgresQL-Clusters 10 backup

     

    We did all steps from here: https://documentation.commvault.com/commvault/v11/article?p=93038.htm

    Infos:

    Node 1: Ubuntu 18.04, PostgreSQL 10.4:5432, master
    Node2: Ubuntu 18.04, PostgreSQL 10.4:5432, hot-standby

    The Enviroment is on V11 SP12+

     

    I collected the Job logs and used the log analyser but there is niothing which i can see directly.

     

    Here are the following log cuts with an error which comes up again and again:

     

     5418 152a 08/16 13:07:33 726200 AnalyzeResult() - eRRoR --  PQresultStatus indicates failure for select pg_xlogfile_name ( '0/83000028' );. Error:FEHLER:  Funktion pg_xlogfile_name(unknown) existiert nicht
     LINE 1: select pg_xlogfile_name ( '0/83000028' );
                    ^
     HINT:  Keine Funktion stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.
     5418 152a 08/16 13:07:33 726200 GetLogFilesNeeded() - eRRoR -- failed to execute query[select pg_xlogfile_name ( '0/83000028' );]
     5418 152a 08/16 13:07:33 726200 GetLogFilesNeeded() - eRRoR -- Exception in [PGFsBackup :: GetLogFilesNeeded] Type:[POSTGRE_EXCEPTION] Msg:[Could not obtain start log location]
     5418 152a 08/16 13:07:33 726200 PostGreFsBackupInterfaceStart() - eRRoR -- Exception in [PGFsBackup :: GetLogFilesNeeded] Type:[POSTGRE_EXCEPTION] Msg:[Could not obtain start log location]

     

    20065 4e61 08/16 13:28:33 726200 PostgresHelperClass::ValidateWalDirectory() - Warning: Unable to find Archive WAL directory [/var/lib/pgsql/archivedir/%f] in archive command [true].

     


     5680 1630 08/16 14:52:46 726200 ConnectDb() - Connection Info string: port = '5432' dbname = 'postgres' user = 'backup_admin' connect_timeout = '' password = **********
     5680 1630 08/16 14:52:46 726200 AnalyzeResult() - eRRoR --  PQresultStatus indicates failure for SELECT pg_last_xlog_replay_location();. Error:FEHLER:  Funktion pg_last_xlog_replay_location() existiert nicht
     LINE 1: SELECT pg_last_xlog_replay_location();
                    ^
     HINT:  Keine Funktion stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.
     5680 1630 08/16 14:52:46 726200 ExecutePostgre::postgre_Query() - eRRoR -- failed to execute query[SELECT pg_last_xlog_replay_location();]
     5680 1630 08/16 14:52:46 726200 PostgresStandbyBackup::WaitForLogTobeApplied() - exepg.postgre_exe  failed
     5680 1630 08/16 14:52:46 726200 PostGresClBackupBase::Initialize() - Error in running command to start server in Master server
     5680 1630 08/16 14:52:46 726200 ClBackupBase::parent(2596) - exiting after base.initialize
     5680 1630 08/16 14:52:46 726200 ResultFile::openForWrite() - opening file '/opt/commvault/iDataAgent/jobResults/2/2205/Failures.cvf.5680-139674642384704'
     5680 1630 08/16 14:52:46 726200 ResultFile::finalize() - processing file '/opt/commvault/iDataAgent/jobResults/2/2205/Failures.cvf.5680-139674642384704'
     5680 1630 08/16 14:52:46 726200 ResultFile::finalize() - complete
     5680 1630 08/16 14:52:46 726200 ClBackupBase::exitHere(11852) - Notifying Job Manager of backup phase failure.
     5680 1630 08/16 14:52:46 726200 BKP CALLED COMPLETE (PHASE Status::FAIL), 726200. Token [726200:6:10]

     

    The sequenze log is also attached to this post.

     

    Befor we open an support case maybe you can help us ?

     

    Best regards

    Attachment: postgres-error.zip
The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2018 Commvault | All Rights Reserved. | Legal | Privacy Policy