• 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

      2ndnijam

      • Home
      • Author 2ndnijam
      07 July

      Migrating Oracle to PostgreSQL using ora2pg

      • Posted by 2ndnijam
      • Categories Blog
      • Comments 0 comment

      In this blog we are going to talk about migrating from oracle to postgresql using ora2pg. After installing ora2pg tool, we will see how to configure and to run it to migrate our data. We are using an oracle 12C …

      Read More
      15 May

      PostgreSQL Health checkup script with mail notification

      • Posted by 2ndnijam
      • Categories Blog
      • Comments 0 comment

      This script can be used to check on postgres apache,mysql, or whatever service you want. This is not meant to be a SOLUTION to services that are crashing, but rather a notification and a temporary restart until you can solve …

      Read More
      12 May

      MariaDB Backup Script Mail Notifications Alert

      • Posted by 2ndnijam
      • Categories Blog
      • Comments 0 comment

      Try following script , This script will take mysql database backup automatically  and remove the old backup file which is over 3 days and once backup is completed means it will send mail confirmation If you know the mysql root password you …

      Read More
      11 May

      Mail Alert Notification for MariaDB Service is Down

      • Posted by 2ndnijam
      • Categories Blog
      • Comments 0 comment

      This script can be used to check on mariaDB, apache2, or whatever service you want. This is not meant to be a SOLUTION to services that are crashing, but rather a notification and a temporary restart until you can solve …

      Read More
      20 April

      Nijamutheen Resume – For PostgreSQL ,Greenplum, Oracle, MySQL , Mariadb, MSSQL, AWS, Linux admin job

      • Posted by 2ndnijam
      • Categories Blog

      Respected Sir/madam, This is Nijamutheen , I  have 6+ years of experience in PostgreSQL database administrator as well as PostgreSQL Architect , Linux admin , web hosting – apache server , Oracle ,mySQL, Mriadb, MSSQL & Server security as well …

      Read More
      03 March

      what are the parameters we need to change if we keep replication in sync mode on postgresql ?

      • Posted by 2ndnijam
      • Categories Blog
      • Comments 0 comment

      The benefit of a synchronous PostgreSQL replication over an asynchronous is that in case of master PostgreSQL database server failure you are sure you did not lose any data. The database client connected to the master PostgreSQL database gets a …

      Read More
      27 February

      How to append the postgres data in production server ?

      • Posted by 2ndnijam
      • Categories Blog
      • Comments 0 comment

      I have a table name is nijam, that table contains 63017 records and have csv excel data contains 586128 records so want to append the data in nijam table for this task you have to following below steps Sample DATA …

      Read More
      26 February

      Postgres Extension postgis Database

      • Posted by 2ndnijam
      • Categories Blog
      • Comments 0 comment

      Postgres by BigSQL includes the PostGIS extension, version 2.2 & 2.3, a powerful open source spatial and geographic data management package. PostGIS enables mapping, distance calculations, and geometry functions such as identifying if a point is within a polygon. Install …

      Read More
      21 February

      Postgres Server monitoring shell script

      • Posted by 2ndnijam
      • Categories Blog
      • Comments 0 comment

      In this shell script will be helpful for monitoring RAM usage,DISK size,how many queries is running more than 5 minutes in a postgres cluster and how many dead tuble is occurred particular database in cluster, How to create & run …

      Read More
      20 February

      WHY NEED TO REFRESH POSTGRES MATERIALIZED VIEW ?

      • Posted by 2ndnijam
      • Categories Blog
      • Comments 0 comment

      Difference between View vs Materialized View in database Based upon on our understanding of View and Materialized View, Let’s see, some short difference between them : 1) The first difference between View and materialized view is that In Views query …

      Read More
      19 February

      What is the easiest way to do postgres performance tuning ?

      • Posted by 2ndnijam
      • Categories Blog
      • Comments 0 comment

      Below steps will be helpful to improve your postgres database performance so faster than earlier. First  you have to issue the top command then see the process which one process is taking more CPU utilization then note that PID, if that  is postgres …

      Read More
      19 February

      how to copy data in one table to another table in postgres

      • Posted by 2ndnijam
      • Categories Blog
      • Comments 0 comment

      You can use INSERT  INTO statement by selected specific table column or use * for selecting all column dblink also will server purpose even if it is remote database.. with condition X server is able to reach Y. # you can …

      Read More
      19 February

      Fastest Ways To Configure Streaming replication with PostgreSQL 10

      • Posted by 2ndnijam
      • Categories Blog
      • Comments 0 comment

      In this post, i will explain how to setup a streaming replication with PostgreSQL 10. I will explain how to install PostgreSQL 10 on your system and  how to monitor the postgres replication server and  how many ways is there …

      Read More
      19 February

      Postgres Best Installation method

      • Posted by 2ndnijam
      • Categories Blog
      • Comments 0 comment

      PostgreSQL 10.3 installation steps: In this tutorial i will explain how to install postgreSQL 10 on Red Hat Enterprise Linux Server release 7.3 Beta (Maipo),How to make network configuration and linux partition for DATA,ARCHIVE,BACKUP, and how to configure postgreSQL cascading …

      Read More
      16 February

      Postgres transaction isolation issue ?

      • Posted by 2ndnijam
      • Categories Blog
      • Comments 0 comment

      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
      • 1
      • 2
      • …
      • 5
      • >

      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

      • thought behind whiteboard activity
      • 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

      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