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: yonogy.curi@edutronic.pe
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
