Scribd Logo
Upload

Welcome to Scribd!

  • 66 views

    01 PostgreSQL Introduction

    Uploaded by

    villanito23
    This document provides an overview of an instructor's experience and qualifications. It summarizes that the instructor has over 20 years of experience in database administration, backup, recovery, tuning, and replication for Oracle databases. They are specialized and certified in high availability and disaster recovery solutions. The instructor also has experience administering PostgreSQL, SQL Server, Informix, SAP, and Big Data technologies. They have been an Oracle University instructor since 2004 and have taught at several training organizations.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    01 PostgreSQL Introduction

    Uploaded by

    villanito23
    66 views14 pages
    This document provides an overview of an instructor's experience and qualifications. It summarizes that the instructor has over 20 years of experience in database administration, backup, recovery, tuning, and replication for Oracle databases. They are specialized and certified in high availability and disaster recovery solutions. The instructor also has experience administering PostgreSQL, SQL Server, Informix, SAP, and Big Data technologies. They have been an Oracle University instructor since 2004 and have taught at several training organizations.

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides an overview of an instructor's experience and qualifications. It summarizes that the instructor has over 20 years of experience in database administration, backup, recovery, tuning, and replication for Oracle databases. They are specialized and certified in high availability and disaster recovery solutions. The instructor also has experience administering PostgreSQL, SQL Server, Informix, SAP, and Big Data technologies. They have been an Oracle University instructor since 2004 and have taught at several training organizations.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    66 views14 pages

    01 PostgreSQL Introduction

    Uploaded by

    villanito23
    This document provides an overview of an instructor's experience and qualifications. It summarizes that the instructor has over 20 years of experience in database administration, backup, recovery, tuning, and replication for Oracle databases. They are specialized and certified in high availability and disaster recovery solutions. The instructor also has experience administering PostgreSQL, SQL Server, Informix, SAP, and Big Data technologies. They have been an Oracle University instructor since 2004 and have taught at several training organizations.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 14

    Ingeniero de Sistemas, con especialidad en Base de Datos,

    Oracle Certified Professional con más de 20 años de experiencia


    en Administración, Respaldo, Recuperación, Afinamiento, y Replicación de Base de Datos.
    Especialista y Certificado en Alta Disponibilidad (OCP 9i, 10g, 11g & 12c, OCE RAC & Tuning)
    Especialista en Soluciones de Contingencia (Standby, Dataguard, Golden Gate & Shareplex )
    Especialista en Implementaciones de Datawarehouse, Datamarts & Big Data
    Administrador de Servidor de Aplicaciones Oracle (OAS) y conocimientos de Linux and UNIX.
    Administrador Oracle DBA-APPS - Oracle E-Business Suite 11i
    PostgreSQL, SQL Server & Informix Dynamic Server Database Administrator
    SAP BASIS Administrator with NetWeaver on Windows, Linux and UNIX.
    SAP HANA Administrator on Enterprise Linux

    Ing. Yonogy Curi Pomahuali

    Oracle University Instructor since April 2004


    At Cibertec, GBS, New Horizons & Edutronic

    Email: [email protected]
    Skype ID: yonogy.orcl
    Blog: http://orclperunet.blogspot.com/
    Facebook Group: Oracle Peruvian Network
    Facebook Page: Edutronic Global Services
    PostgreSQL DBA Admin Workshop I
    Lesson 01:
    • PostgreSQL Install
    • PostgreSQL Upgrade
    Lesson 02:
    • PostgreSQL Database Administration
    • PostgreSQL Database Monitoring
    Lesson 03:
    • PostgreSQL Database Backup
    • PostgreSQL Database Recovery
    Lesson 04:
    • PostgreSQL Standby DB Implementation
    • PostgreSQL Standby DB Replication
    Lesson 05:
    • PostgreSQL Standby Switchover
    • PostgreSQL Standby Rebuild
    Lesson 06:
    • PostgreSQL Standby DB Monitoring
    • PostgreSQL Backup and Recovery
    Lesson 07:
    • Big Data Overview
    • PostgreSQL & Big Data Integration
    Lesson 08:
    • PostgreSQL & Oracle Comparation
    • Oracle to PostgreSQL Migration
    PostgreSQL History
    First Ingres then Postgres
    PostgreSQL, originally called Postgres, was created at UCB
    (University of California at Berkeley) by a computer science
    professor named Michael Stonebraker, who went on to
    become the CTO of Informix Corporation.

    Stonebraker started Postgres in 1986 as a followup project to


    its predecessor, Ingres, now owned by Computer Associates.
    The name Postgres thus plays off of its predecessor (as in
    "after Ingres").

    Stonebraker and his graduate students actively developed


    Postgres for eight years. During that time, Postgres introduced
    rules, procedures, time travel, extensible types with indices
    and object-relational concepts.
    What is PostgreSQL
    • PostgreSQL is a general purpose and object-relational
    database management system, the most advanced open
    source database system. PostgreSQL was developed based
    on POSTGRES 4.2 at Berkeley Computer Science
    Department, University of California.

    • PostgreSQL was designed to run on UNIX-like platforms.


    However, PostgreSQL was then also designed to be portable
    so that it could run on various platforms such as Mac OS X,
    Solaris, and Windows.

    • PostgreSQL is free and open source software. Its source


    code is available under PostgreSQL license, a liberal open
    source license. You are free to use, modify and distribute
    PostgreSQL in any form.
    What is PostgreSQL
    What can we do with PostgreSQL

    PostgreSQL es una base de datos que nos permite:

    • Almacenar datos de Tiendas en Línea.


    • Almacenar datos de Sistemas de Ventas.
    • Almacenar datos de Sistemas de Control de Stock.
    • Almacenar datos de Sistemas Contables.
    • Almacenar datos de Páginas Web Administrables.
    • Almacenar datos de Sistemas de Parkeo de autos, motos, bicicletas, etc.
    • Almacenar datos de Sistemas para Entidades Bancarias.
    • Almacenar datos de Aplicaciones Móviles
    • Almacenar datos para nuestras APIs Rest.
    Why PostgreSQL?
    OPEN SOURCE
    Similar to MySQL, MariaDB and Firebird

    ORDBMS
    PostgreSQL isn't just relational, it's object-relational. This gives it
    some advantages over other open source SQL databases like
    MySQL, MariaDB and Firebird.

    More Data types and structures Support


    Besides the numeric, floating-point, string, boolean monetary,
    enumerated, geometric, network address, bit string, text search,
    xml, json and others.

    Network Addresses
    Provides for storing different network address types.
    Some examples for CIDR:
    • 192.168.100.128/25
    • 10.1.2.3/32
    • 2001:4f8:3:ba:2e0:81ff:fe22:d1f1/128
    • ::ffff:1.2.3.0/128
    Who is using PostgreSQL?

    • Many companies have built products and solutions using


    PostgreSQL.
    • Some featured companies are Fujitsu, Red Hat, Cisco, Juniper
    Network, etc.
    Why PostgreSQL?
    JSON Support
    Is a standard for BD No SQL

    Data Size Support


    Why PostgreSQL?
    GUI Database Administration
    Why PostgreSQL?
    GUI Database Administration
    PostgreSQL Versions Supported
    PostgreSQL & Oracle Comparative
    PostgreSQL & Oracle Comparative

    You might also like