• 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

      Blog

      • Home
      • Blog
      10 October

      PostgreSQL Patching version 9, 10,11

      • Posted by Nijamutheen J
      • Categories Blog
      • Comments 0 comment

      If you are used to patch Oracle databases you probably know how to use opatch to apply PSUs. How does PostgreSQL handle this? Do we need to patch the existing binaries to apply security fixes? The answer is: No. Lets …

      Read More
      16 September

      Tools for PostgreSQL

      • Posted by Nijamutheen J
      • Categories Blog
      • Comments 0 comment

      ClusterControl allows you to easily deploy and configure master/slave replication PostgreSQL instances, monitor queries and detect anomalies with built-in alerts, and lets you manage configurations, schedule & restore backups. It even has advanced fail over handling that detects master failures and automatically …

      Read More
      13 September

      Postgres user creation and restrict DDL & database access

      • Posted by Nijamutheen J
      • Categories Blog
      • Comments 0 comment

      How to create a postgres user ? user should not have any DDL execution permission on postgres database. and the user should not connect other database means user need to restrict the other database connectivity How to achive this ? …

      Read More
      07 September

      PostgreSQL SSL Setup

      • Posted by Nijamutheen J
      • Categories Blog
      • Comments 0 comment

      PREREQUEST : ============ 1. OpenSSL should be install on both client and server systems 2. Confirm whether openssl is installed or not . nijam@2ndquadrant.in:~ # rpm -qa|grep -i openssl openssl-1.0.2j-60.52.1.x86_64 libopenssl1_0_0-1.0.2j-60.52.1.x86_64 python-pyOpenSSL-16.0.0-4.17.1.noarch 3. Checking openSSL version  : nijam@2ndquadrant.in:~ # openssl …

      Read More
      19 August

      How to DELETE current XLOG / WAL LOG in postgresql database ?

      • Posted by Nijamutheen J
      • Categories Blog
      • Comments 0 comment

      Below are ours server , xlog & archive  details  PRIMARY / MASTER: ================ postgres@tutorialdba_1:> ps -ef|grep postgres postgres 4436 1 0 Jun25 ? 00:05:04 /opt/10.6/bin/postgres -D /data postgres 4437 4436 0 Jun25 ? 00:00:00 postgres: logger process postgres 4439 4436 0 …

      Read More
      08 August

      Ora2PG – Oracle/MySQL to Postgres DB migration – Latest Version 20.0

      • Posted by Nijamutheen J
      • Categories Blog
      • Comments 0 comment

      Ora2Pg is a free tool used to migrate an Oracle or MySQL database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into your PostgreSQL database. ora2pg version 20.0 software : …

      Read More
      08 August

      Database Migration from Oracle to Postgres

      • Posted by Nijamutheen J
      • Categories Blog
      • Comments 0 comment

      In this blog we are going to talk about migrating from oracle to postgresql using ora2pg. Ora2Pg is a free tool used to migrate an Oracle or MySQL database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, …

      Read More
      08 August

      PostgreSQL Installation types

      • Posted by Nijamutheen J
      • Categories Blog
      • Comments 0 comment

      In this tutorial, we will show you how to install PostgreSQL  by using source code/RPM on your local system for learning and practicing PostgreSQL. PostgreSQL was developed for UNIX-like platforms, however, it was designed to be portable. It means that PostgreSQL can …

      Read More
      07 August

      Source code Installation PostgreSQL 11 Database

      • Posted by Nijamutheen J
      • Categories Blog
      • Comments 0 comment

      In this tutorial, we will show you how to install PostgreSQL by using source code on your local system for learning and practicing PostgreSQL. PostgreSQL was developed for UNIX-like platforms, however, it was designed to be portable. It means that PostgreSQL can …

      Read More
      07 August

      PostgreSQL 11 Installation – RPM

      • Posted by Nijamutheen J
      • Categories Blog
      • Comments 0 comment

      In this tutorial, we will show you how to install PostgreSQL on your local system for learning and practicing PostgreSQL. PostgreSQL was developed for UNIX-like platforms, however, it was designed to be portable. It means that PostgreSQL can also run on other …

      Read More
      25 July

      How to enable archive log in postgres database ?

      • Posted by Nijamutheen J
      • Categories Blog
      • Comments 0 comment

      In this tutorial i will explained about how to enable archivelog in postgresql server WAL Archive log In PostgreSQL database system, the actual database ‘writes’ to an addition file called write-ahead log (WAL) to disk. It contains a record of …

      Read More
      25 July

      automatically truncating PostgreSQL logfile

      • Posted by Nijamutheen J
      • Categories Blog
      • Comments 0 comment

      To keep 7 days of logs, one log file per day named postgresql-Mon.log, postgresql-Tue.log, etc, and automatically overwrite last week’s log with this week’s log. logging_collector=on log_filename = ‘postgresql-%a.log’ log_directory = ‘log’ log_rotation_age = 1d log_truncate_on_rotation=on  

      Read More
      23 July

      Oracle schema refresh , schema migration

      • Posted by Nijamutheen J
      • Categories Blog
      • Comments 0 comment

      In this blog we are telling about How to do oracle schema referesh from production to DEV & SIT environment. Right now we are taking backup of umar schema after that we can restore the schema to SIT & DEV …

      Read More
      21 July

      windows/Linux – Script to taking postgres DDL objects with individual file name

      • Posted by Nijamutheen J
      • Categories Blog
      • Comments 0 comment

      I. TAKING TABLE STRUCTRE BACKUP WITH THEIR’S OBJECT FILE NAME : Below scripts helpful to take backup (DDL’s) of procedure, function & table definition with individual file system (object name) based on postgres schema . 1.  Windows Script for taking …

      Read More
      21 July

      Not able to enable postgresql archive log ?

      • Posted by Nijamutheen J
      • Categories Blog
      • Comments 0 comment

      unable to restart the postgres server after enabling archivelog , we are getting  below error while restarting the postgresql database . Below steps are we followed to enable archiver. archive_mode =on # enables archiving; off, on, or always # (change …

      Read More
      • 1
      • 2
      • …
      • 9
      • >

      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