FOSSLC is a non-profit organization that specializes in technology and know-how to record conferences with excellent quality. Click on the icons below to view great videos from communities we are actively involved with:

 

PostgreSQL

Content related to the PostgreSQL RDBMS.

Secure PostgreSQL Deployment

in PGCon, PGCon2010, Programming, Security, PostgreSQL
PostgreSQL

Location

Ottawa, ON
Canada
45° 24' 41.6592" N, 75° 41' 53.4984" W

PostgreSQL supports several options for securing communications and access when deployed outside the typical webserver/database combination. This talk will discuss the features that make this possible, with some extra focus on the changes in 8.4 and 8.5.

PostgreSQL supports several options for securing communications when deployed outside the typical webserver/database combination. This talk will go into some details about the features that make this possible, with some extra focus on the changes in 8.4. The main areas discussed are:

    * Securing the channel between client and server using SSL, including an overview of the threats and how to secure against them
    * Securing the login process with methods including LDAP, Kerberos or SSL certificates

The talk will not focus on security and access control inside the database once the user is connected and authenticated.

Event: 
PGCon2010
Speaker: 
Magnus Hagander

PL/Perl - new features in 9.0

in PGCon, PGCon2010, Programming, PostgreSQL
PostgreSQL

Location

Ottawa, ON
Canada
45° 24' 41.6592" N, 75° 41' 53.4984" W

Find out all you need to know about the new PL/Perl features in PostgreSQL 9.0

New features include:

    * New utility functions: quote_literal, quote_nullable, quote_ident, encode_bytea, decode_bytea, looks_like_number, encode_array_literal, encode_array_constructor.
    * The use and require commands can be used in plperl for modules that have already been loaded, like strict and warnings.
    * The features module is pre-loaded for perl 5.10+.
    * Better integration with tools like Devel::NYTProf.
    * END blocks and object destructors are run at session end.
    * Added plperl.on_init, plperl.on_plperl_init and plperl.on_plperlu_init GUCs for DBA use.

Your plperl functions can now use external Perl modules, if your DBA allows. I'll talk about the security implications of this.

I'll also demonstrate using Devel::NYTProf to performance profile your PL/Perl functions.

Event: 
Summercamp2010
Speaker: 
Tim Bunce

Reconciling and comparing databases redux

in PGCon, PGCon2010, Programming, PostgreSQL
PostgreSQL

Location

Ottawa, ON
Canada
45° 24' 41.6592" N, 75° 41' 53.4984" W

The Millburn Corporation is a hedge fund which uses complex data-driven trading models based on the daily prices of various commodities, currencies and other inputs. As part of our application development process, we use independent staging and development instances of our production database to let us have a smoother and less mistake-prone deployment of new models and price streams.

Last year, I presented a talk at PgCon 2009 that examined in broad detail how we make heavy use of different schemas to compare and reconcile data between our different environments. In this talk, I'll examine in detail our attempt to solve a problem we face in our database environment: how to test complex triggers and functions before they're deployed; and how to reconcile and track changes in these functions as they move from our development to our staging and production environments. Specifically, I'll describe how we make use of subversion, pg_dump and pgTAP to roll trigger and function changes to our development environment nightly; and how we test the integrity of the functions and trigger functions on our staging and production environments nightly using pgTAP.

Last year's talk covered how we use simple cross-schema queries and DBI-Link (for cross-database queries) to reconcile data between different databases. In more complex cases, we also use inherited tables with non-overlapping sequences and custom accessor functions to access different data streams in different schemas.

Function comparison and trigger comparisons across schemas and databases are more complex. I will examine how we use MD5 hashes to compare function bodies; walk through most of the common system catalog queries we use to verify function arguments and return values -- stealing ideas from Greg Sabino Mullane's check_postgres script; and then show the testing and deployment framework we've developed at Millburn to test triggers and functions using temporary schemas and fixture files (canned data) to regression test our functions.

Difficulties to be discussed: how to keep the same trigger code in different environments, even if the trigger must use different search paths in different environments; pitfalls of function caching; many other issues tk...

Event: 
PGCon2010
Speaker: 
Norman Yamada

2 years of londiste

in PGCon, PGCon2010, Programming, PostgreSQL
PostgreSQL

Location

Ottawa, ON
Canada
45° 24' 41.6592" N, 75° 41' 53.4984" W

Hi-Media online services all run atop PostgreSQL, and use some form of replication. This talk will present what problems we solve with replication, and how.

As we only use Skytools (Londiste) for replicating data, the talk will summarize what we've found in this project after having been using it for 2 years in production. From the community aspects to the failure experience and the impact on the database management (rollouts, etc).

Event: 
PGCon2010
Speaker: 
Dimitri Fontaine