Skip to Content.
Sympa Menu

perfsonar-user - Re: [perfsonar-user] Issue with creating a migration backup on CentOS 6

Subject: perfSONAR User Q&A and Other Discussion

List archive

Re: [perfsonar-user] Issue with creating a migration backup on CentOS 6


Chronological Thread 
  • From: Simon Peter Green <>
  • To: Szymon Trocha <>
  • Cc:
  • Subject: Re: [perfsonar-user] Issue with creating a migration backup on CentOS 6
  • Date: Tue, 8 Jan 2019 11:35:27 +0800
  • Autocrypt: ; prefer-encrypt=mutual; keydata= mQINBFiYEdkBEAC7UPAIzGFW4bGf/E5WtbwvPZQQ2WT59iSD+/qA3p4rf5KNojVHke4IiYgn S7bd/C3Z8uV3vGGCrLC55zQNnLUXMR0Vx6dXHlQOfnanmAIJEfXeYaa/cFac/RkG5ACoV5Ix t307bGbe+itMrEzkHdmxOSki8ClyY3db/jpRUdpBfCFjrgXRw2qi1UxHbZccLGPqxChoFrkD QQQCdVfp3vMlTXyc53w8rZRYPg4shdJjnbAbHR6KeR8w+hxUB66VB+PHT15rg41U12cHxNNC l+bm3lZqFjvFwIU6TxXa69a72Q3W4IDEa/QF5Qn7hRLLCONHYWsnSVQ6/z6bE6gdXIBkCkxB TOK2CtS/lUbPekN91s8Ld0Givtk3YyG2TkAW57Yz/VcBxrhXMDNYueOS1o6Vo5w2+fRZ+yPE iRpeZvmaprsrpKwFdR4qa5pV0RhoqXusaH5rqJmvu4zTI/l1R00KiYAtl6FsSlox05p9cY5l HhKbJeIJSYnIjSILTKYWpjUOfC5xlot+zvlvxRQu52PG6qt5FzkEj7rW+NDCnXdZQFEIwZMY HACHLmMGcURuCPDlKKapuKppabZUbKiUTanUZX9P0lYVJiEehDknQTD5sB8FsnYoM/34jAod 82mWpDsU9GDp9slgNiDxb8lVTdlRtFLs7c4B650qmi/bPhy23wARAQABtC1TaW1vbiBHcmVl biA8c2ltb25wZXRlcmdyZWVuQHNpbmdhcmVuLm5ldC5zZz6JAjUEEAEIACkFAliYEdoGCwkI BwMCCRBhwazf1WfEGgQVCAIKAxYCAQIZAQIbAwIeAQAAJHQP/3g8OUJOA1wct8cCGPkc2gbE tO17HNp3Oxja9hSEv8XVe8f7/QP2qxs9b+1J2CA3dwG91Oj/SaupculkV9CPGIsoEyRacgDB IFbBcCDL+AtHT0FLCTSqSMKd/bboQzNmkejUh9KxcESLDLWqeQSNWKuIo1ql/h21RZ7Zz7fO hLIDHAOL5rBCRiHrhoKu/QHwxe9BneOj51BlimRTPy2tJn/7BybGM8pozTQ3gku7svxz/EPY sp5ZvnV2hyzZbnO7KG0RKCLOK0VYTfripcim+0Dl7L+tWkiNBdR7paE0z7ZfIyqbqhUe94eF r3Ry4ZevsNob+4c4EKnBy4rz6ahPFASTnfx6X/tBnDe9FhazthGW5g31JDZyOrOQmT2DFCw9 Rp7+N53JWtGIAoqn+ivN7toIOlmzEm7ZGTs+MFHqk0JV3pbP+AuMhUxKNfU+ppvtix5taRgV NsGMPkHQvkknInn/QHL+RvBZu1a7yXTkF/kMJLNMfmWwDhajjC2MhdDnRHQp2iJ6+k3FPieM Gz41ydO8vCPg7GlivmiGuMYkJTWKRXBUHLQZikxGUimxgvwIZUhwEXvSRsIMo4d9dRP/HOtq YHkVp/AzkMMjgstCjjg9+TyHK50/9g6FRMmMNI6U9qywFHht4rpvkXfIqHsfbSdkwNQUUdCd lDQQH4BTtiTCuQINBFiYEdkBEAC83l4gW/QyLqWiHx9VWehjs8pmXKqxS2n8qVb/uw9GQamf AoKUoKmxLubp1xBBTrsnCEba9h1iolTrzVBUd6lJotFoIKJFX9NYFF7/tO+KlZ1jsnnKK9ve izCG635MQraslPKPU3X+Mq5G0vqBOfRf6YRtVnwx/jy+KFFbXABfGpMTk93fgYWPZntHS6UR pjR5JY4IU41vNhx5aZ/IbAPgHGy7u3IMeHnI3ywPrD2yoSI8iKd5RwYTzn13xYGzrE1uWjsA B3+kjqil9xJSikhyMt607TlNj52hLJWApu/mUeMPMBhAE42npo9ygFtroXfSfN+a0zQz25nc Uy76fbAwk+eKydU03n5JYV0QSBeKiKf+MQNDfomkypkIzIWeSphVOnhy+16MBDpEBJk+5tSf 2Ed8qOA3Lc1IG17h/WrMsFKyHDrZGEhUyaJn/oxn8poYdcCd6F1T4PY7SmFjlVzKiFLMxFsk XeqhNHVC/yV6UCr2ReMQHl9yscpKJFDVSSijUeD5SZf5C86tq61hMTQX9gW0MSmVJ26Xwiwk R5VtFZ2np8k2c5iYH23JEmlBDeNoxzK0PwDsvTKUJRar2Hx5ZduI60iglCuyQKumkYpkWzkz r0Y0h+u9c8aZVs2Ky7H6lrOVjyhVi+UQ4PrHxiRfuFlTV1IVZqjWCKGVfauk7QARAQABiQIf BBgBCAATBQJYmBHcCRBhwazf1WfEGgIbDAAAG4QP/2M2VZP+7FYrdUXX6IIhIPzY6w/mQAfp AEEqArx/OJIXaurfvQEk5uvZ5rih5L8ChrTwUCzLVmG6frs72uHdW02zCr8VDk4CW1UIgoN7 3UwxbAbIbFeSZijnVjA6/7s1/pNLTqpLPTEGydNzm5yMog/3MuXI6RYsndIQLWNr0TlDK/pT dkk4DlnscAFXELMBQPVW5UkM5Y9B9Hkr4OPzUMPXzsVYem7pvSlLh0DAa22cBaNBg4yESEky jP2xmihwMQvV6lUoSMmuagdL1weM9c/EqbGCUVEE0LPv0+hC6tPh3coZ2ytZoRniO2hyz6w0 3Le/G4tqCljPsmgq5WrkPbxpBBUOmTNvsBiELKmq3i5Qu/L8td26hLBtIVqgcroumf6KZ/AQ 67qEc3hg7J/r5gt7a+20qrGi0/KxN9GZqnkAPXNf8UNgC6Tp9YSz84qnlYgHSAG3fky2x9uS 8dfteM7/DbDcJ41QC7UVURVi3klxSxhAUToNg6ed/QCUgWj/OSwCLwqJVgFmQ/cREoIXP5Sl wx3/KYXZCTXLSN7D8a7W5f3SnC/rDl25WBtWW5fzZKXW2sGkvGkY4ZNYlCSb4hg6malXfWTW VNMZMqIWfTsddf0sTrgsj01iAn2UW8hG3B0Qg3bV2R5bB4WS/+HVg7KgUnIeittgndQdJJyY t2hW
  • Ironport-phdr: 9a23:orLn+BZtx4FgbbxvQtxZZpX/LSx+4OfEezUN459isYplN5qZpsy6ZB7h7PlgxGXEQZ/co6odzbaO4+a4ASQp2tWoiDg6aptCVhsI2409vjcLJ4q7M3D9N+PgdCcgHc5PBxdP9nC/NlVJSo6lPwWB6nK94iQPFRrhKAF7Ovr6GpLIj8Swyuu+54Dfbx9HiTahYr5+Ngm6oRnMvcQKnIVuLbo8xAHUqXVSYeRWwm1oJVOXnxni48q74YBu/SdNtf8/7sBMSar1cbg2QrxeFzQmLns65Nb3uhnZTAuA/WUTX2MLmRdVGQfF7RX6XpDssivms+d2xSeXMdHqQb0yRD+v9LlgRgP2hygbNj456GDXhdJ2jKJHuxKquhhzz5fJbI2JKPZye6XQds4YS2VcRMZcTzFPDJ2yb4UPDOQPM+hXoIb/qFQSthaxHxWgCfn1xzNUiHL736s32PkhHwHc2wwgGsoDvmnVrNXwM6cSV/2+wrPWwjXfcfxWwyr25onSch8/v/6MW697fM3KyUkuEgPFiVOQqZT7MDOJyOsNqWeb7/B+Wu2xjW4qsBpxojmpxscjkIbJnJwaylbe+SV/3ok1Oce0SFV0YdO9FpZbqi+UN4xzQsw4QmFovj43yqUduZ69YCcG0ownxxrHZ/yfbYeI+BzjVP2WITd+nn1lYqizhxCs/ki80uH8TtW70E1RriZfitnMsnYA3AHQ5MifUvZx4Eas1SqN2g3W5OFJIls7mbbeJpMuwbM9l5UevEHdEiPqnUj7ia+be0s59uSw9ujqbLfrqoWBO4J6lA3yKLkil8+iDegiLwQDXm6W8vmm2rL55032WrBKg+U2kqbHtJDaItwWpqujDA9U1oYv8g6/Dzi73NgBkngKLFxIdA+dg4jmPFHOJ//4DfOhjFi2jDhrwPXGMqXgApXLMHfDjK/scah85kJAygc+yN5f6pFPBb0dJf/+VUz8ud3XAxI8LQC43+PqBdB9244QRG6DGqqZP7nTsV+M6OIvOe6MZIoNtTbmKvgl4vnujXkhmVADYammw4EXaH+iHvt4PUqZZ2HhgswAEWcMsQoxVvbqh0OEUTJJYXa9Qb486isgCIKpFYvDXJyigKSd3CenGZ1bfnhGBU6WEXfmbIWEXPEMZziIIsN4jzwETqauS5U62BGqtQ/60KZnLvHK9iECtJLj0sR16PPJlRE06zN0E9qR33uTQG5pg2NbDwMxiZttsEl6zB+/y69zg/UQQcdB9vZOVEEmL5nXz+VSDtn0HBrGbNGAThC+RoP1Lys2S4cKwtoJZQ5FFsmvlFjsxSenBfdBjL2OA5os/77RxXfrKst7423H0qYolVQgBM1CKSu9ifgspEDoG4fVnhDBxO6RfqMG0XuIrT/bwA==
  • Openpgp: preference=signencrypt

Hi Szymon,

Thanks very much! It worked after adding the patch to the backup script.

Cheers,
Simon


On 7/01/2019 9:53 PM, Szymon Trocha wrote:
W dniu 07.01.2019 o 07:23, Simon Peter Green pisze:

Hi everyone,

I'm following the steps at https://docs.perfsonar.net/install_migrate_centos7.html to migrate our current CentOS 6 PS node including our measurement archive data to CentOS 7.

I ran the following ps-migrate-backup.sh script with the --data flag and have received the following error when it tries to backup pScheduler.

$ sudo /usr/lib/perfsonar/scripts/ps-migrate-backup.sh   --data  ~/ps-backup_$(date +%Y%m%d).tgz
Backing-up users...[SUCCESS]
Backing-up groups...[SUCCESS]
Backing-up passwords...[SUCCESS]
Backing-up perfsonar configuration...[SUCCESS]
Backing-up bwctl-server configuration...[SUCCESS]
Backing-up owamp-server configuration...[SUCCESS]
Backing-up NTP configuration...[SUCCESS]
Backing-up MaDDash configuration...[SUCCESS]
Backing-up cassandra data for esmond...[SUCCESS]
Backing-up postgresql data for esmond...[SUCCESS]
Creating pScheduler backup:
    Version Information... Done.
    System Configuration... Done.
    Database...pg_dump: unrecognized option '--serializable-deferrable'
Try "pg_dump --help" for more information.
Unable to create pScheduler backup

OS, Kernel and Toolkit Information for Node:

PostgreSQL Version: PostgreSQL 8.4.20

It seems that the --serializable-deferrable option doesn't exist until PostgreSQL version 9.1 and greater. Is there anyway way to get around this problem?

Cheers,

Simon


Hi Simon,

You probably have both postgresql 8 and postgresql 9 installed, but current pScheduler backup script expects only postgresql9.

Try adding this patach to /usr/libexec/pscheduler/commands/backup:
Remove line:

pg_dump \

Add in this place these three lines:

PG_DUMP=pg_dump                                                                                                                                                                                                                         
[ -x /usr/pgsql-9.5/bin/pg_dump ] && PG_DUMP=/usr/pgsql-9.5/bin/pg_dump
$PG_DUMP \

And rerun the backup script

Regards,

--
Szymon Trocha
Poznań Supercomputing & Networking Center
General NOC phone +48 61-858-2015 | noc.pcss.pl
Personal desk phone +48 61-858-2022
Wysłaliśmy do Ciebie ten e-mail w odpowiedzi na Twoje zapytanie lub w związku z oferowaną usługą. Przesłanie korespondencji do Centrum Zarządzania PCSS lub zgłoszenie telefoniczne jest równoznaczne z wyrażeniem zgody na przetwarzanie danych osobowych przez Instytut Chemii Bioorganicznej Polskiej Akademii Nauk w Poznaniu adres: ul. Z. Noskowskiego 12/14, 61-704 Poznań. Szczegółowe informacje znajdują się w naszej Polityce prywatności. | This message has been sent as a part of communication with PSNC NOC or your service request sent to us. For more information read our Privacy Policy.

Archive powered by MHonArc 2.6.19.

Top of Page