What is new in the just released PostgreSQL 9.1? PostgreSQL core team member Josh Berkus gives you a whistle-stop tour of the top features of the new release, including live demos of several of them. Included: synchronous replication, new replication tools, unlogged tables, SSI, KNN-GiST, per-column collations and extensions.
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 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 …
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.
A comparison between the two databases presented by Ed Boyajian, the CEO of EnterpriseDB. Video Producer: NYC MySQL Group
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 …
