• Home
  • Services
    • DBA Support
    • DBA Consultancy Services
    • PostgreSQL Support
    • Website Maintenance
  • Courses

    About Courses

    • List Of Courses
    • Become an Instructor
    Greenplum Database

    Greenplum Database

    $2,000.00 $1,500.00
    Read More
  • Company
    • FAQs
    • About Us
    • Contact
  • Events
  • Portfolio
  • Blogs
    • Blog – RayaFeeL
    • Blog – PostgreSQL Support
    • Blog – PostgreSQL Migration
    • Blog – All DB’s
    • Blog – Linux
    • Blog – Medical Coding
      • Cart

        0

    Have any question?
    (+91)8838953252
    ITsupport@rayafeel.com
    RegisterLogin
    RayaFeeL
    • Home
    • Services
      • DBA Support
      • DBA Consultancy Services
      • PostgreSQL Support
      • Website Maintenance
    • Courses

      About Courses

      • List Of Courses
      • Become an Instructor
      Greenplum Database

      Greenplum Database

      $2,000.00 $1,500.00
      Read More
    • Company
      • FAQs
      • About Us
      • Contact
    • Events
    • Portfolio
    • Blogs
      • Blog – RayaFeeL
      • Blog – PostgreSQL Support
      • Blog – PostgreSQL Migration
      • Blog – All DB’s
      • Blog – Linux
      • Blog – Medical Coding
        • Cart

          0

      Postgres Migration

      • Home
      08 August

      Oracle to Postgres Database Migration

      • Posted by Nijamutheen J

      Oracle migration: For migration first we need to install oracle database and ora2pg software and DBD oracle packages. =>first install oracle database in server and note down the paths,username,password needed   For installing the oracle database follow the below steps: …

      Read More
      16 February

      Postgres Invalid size memory allocation

      • Posted by 2ndnijam

      The server is ec2 with c5.xlarge The data in the row is exceeding 1 gb size So is the reason for this error ‘Invalid size memory allocation ‘ How to fix ? Is any configuration required to change ? Solution …

      Read More
      16 February

      Postgres data not found ! after function updating

      • Posted by 2ndnijam

      I am facing one issue. I have 3 IP. 1,2 are master and slave and 3 for pgpool. My application direct hit to 3 ,and 3 distribute the connection between master and slave. But in my web application have one …

      Read More
      13 February

      Clear RAM Memory Cache, Buffer and Swap Space on Linux

      • Posted by Nijamutheen J

      How to Clear Cache in Linux? Every Linux System has three options to clear cache without interrupting any processes or services. 1. Clear PageCache only. # sync; echo 1 > /proc/sys/vm/drop_caches 2. Clear dentries and inodes. # sync; echo 2 > /proc/sys/vm/drop_caches …

      Read More
      13 February

      Script to killing ALL IDLE Connection In Postgres Database

      • Posted by Nijamutheen J

      1.MORE I/O POSTGRESQL KILLING ALL IDLE CONNECTION FOR MONITORING PURPOSES: This following script is used for killing all idle connection and you can use it as a monitoring puposes like how many idle query is running for a hour and …

      Read More
      13 February

      Postgres 9.6 parameter idle_in_transaction_session_timeout

      • Posted by Nijamutheen J

      A common issue with databases: The guy at floor 2 did some work on the database and then rashly left for lunch because the lady on floor 1 is already waiting for him. Unfortunately he did not close his transaction …

      Read More
      13 February

      Postgres database Query status

      • Posted by Nijamutheen J

      Active: query is running and session is hitting every threshold time, Idle in transaction: query is completed,and waiting for commit, session is hitting every threshold period. Idle in transaction (aborted): last or some statement was aborted due to network or syntax error (consider …

      Read More
      13 February

      Script for Finding & killing postgres long running query

      • Posted by Nijamutheen J

      This script is mostly used for will display  what are the postgresql query is running more than one minutes and it will display query with PID using this PID you can kill what query is taken more CPU utilization and …

      Read More
      13 February

      Understanding Postgres Database VACUUM , VACUUM FULL , VACUUM ANALYZE

      • Posted by Nijamutheen J

      Definition: VACUUM reclaims storage occupied by dead tuples. In normal PostgreSQL operation, tuples that are deleted or obsoleted by an update are not physically removed from their table; they remain present until a VACUUM is done. Therefore it’s necessary to …

      Read More
      13 February

      Script – vacuum, analyze and reindex for postgres database

      • Posted by Nijamutheen J

      1.Script for vacuum,analyze and Reindexing  the database cat /home/script/vaccum_analyze_reindex.sh #!/bin/bash PGHOME=/opt/PostgreSQL/9.3/bin LOG=/backups/logs/igr-vac-logs LOGFILE=vacuum_analyze_`date +”%Y-%m-%d-%T”`.log REINDEXLOG=reindex_`date +”%Y-%m-%d-%T”`.log export PGOPTIONS=’-c vacuum_cost_delay=10 -c maintenance_work_mem=5GB’ export PGPASSWORD=postgres $PGHOME/vacuumdb -d db_name -j 5 -p 5432 -z >> $LOG/$LOGFILE 2>> $LOG/$LOGFILE $PGHOME/reindexdb -d db_name -p 5432 …

      Read More
      13 February

      postgres database reindex

      • Posted by Nijamutheen J

      The REINDEX command rebuilds one or more indices, replacing the previous version of the index. REINDEX can be used in many scenarios, including the following (from Postgres documentation): An index has become corrupted, and no longer contains valid data. Although in theory …

      Read More
      13 February

      Postgres Database index Types

      • Posted by Nijamutheen J

      Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. An index in a database is very similar to an index …

      Read More
      13 February

      EXPLAIN PLAN for Postgres Query ?

      • Posted by Nijamutheen J

      Explain plan is mainly used to how Postgres will execute given a query and also Understanding this tells you how you can optimize your database with indexes to improve performance Most commonly, explain is run on SELECT statements. However, you …

      Read More
      13 February

      Postgres Script – Query running more than X minutes ?

      • Posted by Nijamutheen J

      This script is useful for what are the query is running more than ‘x’ minutes(your input values) and that query status,you can list out the query as per your timing and query status bash-4.1$ cat bash-4.1$ HOSTNAME=`hostname` PSQL=”/opt/PostgreSQL/9.3/bin/psql” PORT=5432 HOST=”localhost” …

      Read More
      13 February

      PostgreSQL Types

      • Posted by Nijamutheen J

      1.DDL-Data Definition Language, which is used to create and modify the structure of database objects in database. It’s a auto commit. automatically saved when you create,alter,drop,truncate,comment,rename commands issued ALTER – alters the structure of the existing database CREATE – to create database …

      Read More
      • 1
      • 2
      • >

      Search

      ADVERTISEMENT

      Latest Posts

      PostgreSQL Patching version 9, 10,11
      10Oct2019
      Tools for PostgreSQL
      16Sep2019
      Postgres user creation and restrict DDL & database access
      13Sep2019
      PostgreSQL SSL Setup
      07Sep2019
      How to DELETE current XLOG / WAL LOG in postgresql database ?
      19Aug2019

      Latest Courses

      PostgreSQL Database

      PostgreSQL Database

      $600.00 $500.00
      Greenplum Database

      Greenplum Database

      $2,000.00 $1,500.00

      Preview Course

      Free

      Recent Forum Topics

      • Are you going to take your first ste
      • How to start working on an application?
      • please let me know pre requirements to increase work_mem
      • how to copy some data in one table to another table in postgres
      • postgres script for finding queries more than 1 hours ?

      2ndquadrant.in

      (+91) 8838953252

      ITsupport@rayafeel.com

      Company

      • About Us
      • Contact
      • Our Team
      • Blog

      COURSES

      • List Of Course
      • Become An Instructor
      • Events
      • Postgres Support Blog

      Support

      • DBA Support
      • Consultancy Services
      • Postgres Migration Blogs
      • Forum

      Recommend

      • Groups
      • Login
      • FAQs
      • SignUp

      IT Services by rayafeel.com. Powered by Rayafeel Technologies Pvt Ltd.

      • Privacy
      • Terms

      Become An Instructor?

      Join thousand of instructors and earn money hassle free!

      Get Started Now

      Login with:

      Login with Google Login with Twitter Login with LinkedIn Login with Microsoft

      Login with your site account

      Lost your password?

      Not a member yet? Register now

      Register a new account

      Are you a member? Login now