PostgreSQL Backup and Recovery Methods

This video provides an overview of the PostgreSQL Backup and Recovery methods and presents Point in Time Recovery (PITR). PITR is a flexible high-availability feature with powers such as the ability to create a warm standby server for fast failover, and snapshots and restores to specific points in time.

PostgreSQL, the Database Sister of Python

PostgreSQL and Python share more then the first letter: their communities have great similiarities; their development processes are really comparable; their licenses and their openness to academics AND business (on a technical and communitie perspective) are big pluses. We will have a look at those similiarities and learn why PostgreSQL is really the database sister …

PostgreSQL, the Database Sister of Python Read More »

Migrating from Oracle to PostgreSQL

This video presents Ora2Pg, a free tool that you can use to migrate an Oracle database to a PostgreSQL compatible schema. Ora2Pg 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.

PostgreSQL versus MySQL

A comparison between the two databases presented by Ed Boyajian, the CEO of EnterpriseDB. Video Producer: NYC MySQL Group

How To Create A Postgres Database Using pgAdmin

This video walks through the basics of creating your first database using pgAdmin, the comprehensive database design and management console for Postgres databases. Created for first time users of Postgres, you’ll also be introduced to the fundamental features in pgAdmin and be ready to start creating databases, entering data, and building multi-table queries using the …

How To Create A Postgres Database Using pgAdmin Read More »

Creating Java Applications With PostgreSQL and Postgres Plus

This video shows a quick example of creating a working CRUD application on top of PostgreSQL using JBoss SEAM (Java Server Faces, EJBs, and Hibernate). In 5 minutes, you use the SEAM framework to build a basic application including reverse engineering the database schema to create boiler plate code for basic viewing and updating data.