Postrgres

Backup Postgres DB and Rotate using Logrotate – CentOS

November 5, 2018 Jordansphere Linux

Here is a rudimentary script to backup a specific Postgres DB. Logrotate then takes care of the log rotation. As you'll see below we will keep 7 days worth of compressed files.   #! /bin/bash # This script is called from logrotate /etc/logrotate.d/my-dumps # It backs up myDB every evening and logrotate takes care of compression […]

More

automatically backup postrgres database,

Install Postgres 10 for vCloud Director 9.5

October 25, 2018 Jordansphere Database

Here are the steps to install Postgres 10 on CentOS 7 Spec: OS:          CentOS 7 DB:          Postgres 10.x RAM:       16GB vCPU:      4 HDD:       100 GB   OS Installation: Use Guided GUI installation. Select to partition manually so that all data is on /root LVM.    […]

More

Migrate vCloud Director Database from MSSQL to Postgres

October 24, 2018 Jordansphere MS SQL

As vcloud director 9.5 is the last iteration to support MS SQL we decided to migrate the database to Postgres Here are the instructions to migrate the database   Pre-requisites 1) Snapshot all Cells 2) Snapshot MSSQL DB 3) Backup MSSQL DB   Procedure: 4) Shutdown all cells  service vmware-vcd stop      5) On […]

More

Powered by WordPress. Designed by elogi.