- #Aws postgresql dump in ec2 how to#
- #Aws postgresql dump in ec2 install#
- #Aws postgresql dump in ec2 zip file#
- #Aws postgresql dump in ec2 update#
- #Aws postgresql dump in ec2 software#
Run GoldenGate Software Command Interface to validate is running ~]$. Last metadata expiration check: 0:42:17 ago on Tue 07:19:29 PM UTC.
#Aws postgresql dump in ec2 install#
Last login: Wed Apr 22 04:15: on ~]# yum install libnsl The libnsl.so.1 package is needed for Oracle GoldenGate 12 but by default, libnsl.so.1 is not installed in RHEL 8.0 and without this package, when we try to run ggsci we get the error: “./ggsci: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or gg]$ su - root Install the package libnsl in Red Hat Enterprise Linux release 8.0. Inflating: gg]$ tar -xvf ggs_Linux_圆4_PostgreSQL_64bit.tarĥ.
#Aws postgresql dump in ec2 zip file#
Unzip the zip file 122022_ggs_Linux_圆4_PostgreSQL_64bit.zip in the to Oracle GoldenGate Home ~]$ cd gg]$ ls -lrt 122022_ggs_Linux_圆4_PostgreSQL_64bit.zip Transfer the zip file 122022_ggs_Linux_圆4_PostgreSQL_64bit.zip to Oracle GoldenGate Home /u02/gg, I used Filezilla to transfer the zip file from Windows to Linux in AWS EC2.Ĥ.
Download Oracle GoldenGate 10.1.0.0.4 for Oracle (64 bits) 122022_ggs_Linux_圆4_PostgreSQL_64bit.zip from Oracle website.ģ. password for ~]$ sudo chown -R dbadmin:dbadmin ~]$ ~]$ echo export GGH=/u02/gg > ~]$ echo export LD_LIBRARY_PATH=/u02/gg/lib > ~]$ chmod ug+x gg_profileĢ. Create the GoldenGate Home directory and setup the environment variable ~]$ sudo mkdir -p /u02/gg
Libpq5 libsensors4 postgresql postgresql-10 postgresql-client-10 postgresql-client-common postgresql-common postgresql-contrib ssl-cert sysstatĠ upgraded, 10 newly installed, 0 to remove and 72 not upgraded.Īfter this operation, 21.1 MB of additional disk space will be used.ĭo you want to continue? Validate the Service :~$ sudo service postgresql status The following NEW packages will be installed: Lm-sensors postgresql-doc locales-all postgresql-doc-10 libjson-perl openssl-blacklist isag Libpq5 libsensors4 postgresql-10 postgresql-client-10 postgresql-client-common postgresql-common ssl-cert sysstat The following additional packages will be installed: Install the PostgreSQL package along with a postgresql-contrib package that adds some additional utilities and functionality :~$ sudo apt install postgresql postgresql-contrib
#Aws postgresql dump in ec2 update#
Run the update :~$ sudo apt update Install the Package
Launch a new instance in AWS EC2 and open the SSH port in the security group inbound rule.
#Aws postgresql dump in ec2 how to#
We will see how I implemented the Application consistency in my next blog, here we will see how to setup the PostgreSQL in Ubuntu in AWS EC2. It is a popular choice for many small and large projects and has the advantage of being standards-compliant and having many advanced features like reliable transactions and concurrency without read locks.ĭuring the COVID-19 Quarantine days, I started integrating the application consistency backup of PostgreSQL. PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language.
0 kommentar(er)
