AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Yum update postgresql reset settings12/15/2023 ![]() Now try logging into the machine, with: "ssh check to make sure that only the key(s) you wanted were added. bin/ssh-copy-id: INFO: 1 key(s) remain to be installed - if you are prompted now it is to install the new password: bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are already installed bash-4.2$ ssh-copy-id -i ~/.ssh/id_rsa.pub INFO: Source of key(s) to be installed: "/var/lib/pgsql/.ssh/id_rsa.pub" 1 postgres postgres 1679 Jun 22 10:12 id_rsa 1 postgres postgres 405 Jun 22 10:12 id_rsa.pub SHA256:jiouqVEgyZz+dmsHM+H0yzn4GgdhYnqBkbJ3Es/ralw key's randomart image is: ![]() Your public key has been saved in /var/lib/pgsql/.ssh/id_rsa.pub. Your identification has been saved in /var/lib/pgsql/.ssh/id_rsa. Last login: Wed Jun 16 17:44:29 +03 2021 on pts/2Įnter file in which to save the key (/var/lib/pgsql/.ssh/id_rsa):Įnter passphrase (empty for no passphrase): Verify pgbackrest package installation: Use simple commands like pgbackrest version or pgbackrest help to verify ~]# su - postgres > Package pgbackrest.x86_64 0:2.34-1.rhel7 will be installed ![]() Install pgbackrest in Backup Server:Use OS command yum install pgbackrest to install pgbackrest package in Backup ~]# yum install pgbackrest !pgdg-common/7Server/x86_64 PostgreSQL common RPMs for RHEL/CentOS 7Server - x86_64 303 !ol7_UEKR6/x86_64 Latest Unbreakable Enterprise Kernel Release 6 for Oracle Linux 7Server (x86_64) 323 !mysql80-community/x86_64 MySQL 8.0 Community Server 265 !mysql-tools-community/x86_64 MySQL Tools Community 129 !mysql-connectors-community/x86_64 MySQL Connectors Community 203 !mongodb-org-4.4/7Server MongoDB Repository 76 Packages for pgBackRest are available in the PGDG yum ~]# yum repolist Click hereto configure postgresql repository if it is not configured. Verify PostgresQL repository in Backup Server: Use OS command yum repolist to confirm PostgreSQL repository exist in Backup Server. ![]() Below are machine configuration details: Sr No. So will install pgBackRest only in Backup Server. We have already install pgBackRest PostgreSql Server in the previous blog. Make sure you install the same version on both. ![]() We need to install pgBackRest on the database and the backup server to configure it. In this blog, we will configure pgbackrest on Remote Backup Host in PostgreSQL. Such setups are not used in a production environment to perform the backup on the same server where the database is running. In the previous blog, we demonstrated How to install pgbackrest on Database Server – Local in PostgreSQL Click here to read more. ![]()
0 Comments
Read More
Leave a Reply. |