2ndnijam

In this script useful for automatic replication configure #!/bin/bash ##This is meanst to be run on the slave, with the masters ip as the passed variable. ($1) sourcehost=”$1″ datadir=/var/lib/postgresql/9.2/main archivedir=/var/lib/postgresql/9.2/archive archivedirdest=/var/lib/postgresql/9.2/archive #Usage if [ “$1” = “” ] || [ …

When you first create a new Ubuntu 16.04 server, there are a few configuration steps that you should take early on as part of the basic setup. This will increase the security and usability of your server and will give …

Step 1 – Installation of CFS dependencies CSF script requires perl modules , it is a csf dependencies module [root@nijam ~]# yum install perl-libwww-perl Loaded plugins: auto-update-debuginfo, fastestmirror, protectbase, refresh- : packagekit, security Setting up Install Process Loading mirror speeds …

Memory object caching systems like Memcached can optimize backend database performance by temporarily storing information in memory, retaining frequently or recently requested records. In this way, they reduce the number of direct requests to your databases. Because systems like Memcached …

Before Restoring & creating the database you have to restore the appropriate roles and have to give appropriate roles permission Step 1.bakup the roles by using following command Taking postgres Roles only backup : pg_dumpall -h localhost -p 5432 U …

this script will run at every night 1 AM and will take the postgresql basebackup of local tablespace # crontab -e 0 1 * * * sh /home/postgres/eds/pune.sh :wq #cat /home/postgres/eds/pune.sh # Config: DB=”POSTGRES_DB_NAME” U=”USERNAME” export PGPASSWORD=”tcs@12″ export PGPORT=”5444″ export …

You can’t take PostgreSQL functions backup like wise as tables in postgresql. You can use the below query to get all the function definitions from following script. # Config: DB=”LC” U=enterprisedb export PGPASSWORD=”tcs@345″ export PGPORT=”5544″ export PGHOST=”10.0.4.101″ nijam=”/home/Admin/” logfile=”nijam33″.sql /opt/edb/as9.6/bin/psql …

Here we written the script for taking postgresql physical backup with replication and witout replication Backup scripts for without replication: psql -U postgres -c “SELECT pg_start_backup(‘base backup’)” if [ “$?” != “0” ]; then echo Broken exit 1 fi tar …

In this Shell script will displays schema name and table name in which table having more than dead tubles in a postgresql server How to create & run shell script file ? create  a shell script file here created tables_dead_tubles.sh using vim …

If you are using PostgreSQL in a production environment, it is important to take precautions to ensure that your users’ data is not lost. By frequently backing up your database, and/or automating backups with a cron task, you will be …

In this shell script will help you to take the backup of postgresql VIEWS with different file as schema based # Config: DB=”2ndQ” U=enterprisedb export PGPASSWORD=”tcs345″ export PGPORT=”5444″ export PGHOST=”20.0.4.101″ TABLES=”$(/opt/edb/as9.6/bin/psql -d $DB -U $U -t -c “select viewname from …

In this shell script will help you to take the backup of postgresql function & procedure with different file as schema based # Config: DB=”tutorialdb” U=enterprisedb export PGPASSWORD=”tcs@345″ export PGPORT=”5444″ export PGHOST=”20.0.4.101″ nijam=”/home/Admin/” logfile=”nijam48″.sql /opt/edb/as9.6/bin/psql -d $DB -U $U -t …

Before creating database you have to create tablespace and then you have to give right tablespace name for  database Creation And before creating tablespace you have to check with partion or disk space availability it’s a prerequest for Postgresql tablespace creation …

RayaFeeL is a Remote team. RayaFeeL IT Services is a leader in providing PostgreSQL consulting support services, You wouldn’t trust your mission-critical postgres databases to a novice, and that’s why seasoned managers rely on our postgres experts and our proven …

Greenplum Database is a massively parallel processing (MPP) database server with an architecture specially designed to manage large-scale analytic data warehouses and business intelligence workloads. MPP (also known as a shared nothing architecture) refers to systems with two or more processors that …