• Home
  • Custom Ecommerce
  • Application Development
  • Database Consulting
  • Cloud Hosting
  • Systems Integration
  • Legacy Business Systems
  • Security & Compliance
  • GIS
  • Expertise
  • About Us
  • Our Team
  • Clients
  • Blog
  • Careers
  • CasePointer
  • VisionPort
  • Contact

    • Our Blog

    Ongoing observations by End Point Dev people

    Blog posts tagged ‘postgres’

    MySQL, ASCII Null, and Data Migration

    Mark Johnson · February 26, 2014

    DBD::Pg 3.0.0 and the utf8 flag

    Greg Sabino Mullane · February 19, 2014

    Perl PostgreSQL driver DBD::Pg 3.0.0 released

    Greg Sabino Mullane · February 7, 2014

    Database federation performance showdown

    Josh Tolley · December 19, 2013

    Using JavaScript in PostgreSQL

    Szymon Lipiński · November 22, 2013

    Copying Rows Between PostgreSQL Databases

    Szymon Lipiński · November 21, 2013

    Install Pentaho BI Server 4.8 Community Edition with PostgreSQL Repository

    Selvakumar Arumugam · November 7, 2013

    Install Pentaho BI Server 5 Enterprise Edition with PostgreSQL repository

    Selvakumar Arumugam · November 7, 2013

    Slony Migration experience version 1.2 to version 2.2

    David Christensen · November 6, 2013

    Downstream Implications of Data Page Checksums

    Josh Williams · October 30, 2013

    Changing Postgres pg_dump warnings into errors with sed

    Greg Sabino Mullane · October 28, 2013

    PostgreSQL Debian apt repository GnuPG key update

    Jon Jensen · October 15, 2013

    PostgreSQL 9.3 Released

    Szymon Lipiński · September 10, 2013

    Log Jam: Be careful with local syslog

    Josh Williams · August 22, 2013

    The Un-unaccentable Character

    Josh Williams · August 18, 2013

    Speeding Up Some FDW Queries

    Szymon Lipiński · August 8, 2013

    Merging JSONs in PostgreSQL

    Szymon Lipiński · July 29, 2013

    Pretty Printing JSONs in PostgreSQL

    Szymon Lipiński · July 25, 2013

    PostgreSQL Autovacuum Issues In EOL Postgres

    David Christensen · July 17, 2013

    Speedier column additions in PostgreSQL

    Jeff Boes · July 17, 2013

    SFTP virtual users with ProFTPD and Rails: Part 2

    Brian Gadoury · July 10, 2013

    Automating checking for new versions of PostgreSQL

    Greg Sabino Mullane · July 3, 2013

    Debugging obscure Postgres problems with strace

    Greg Sabino Mullane · June 20, 2013

    Installing PostgreSQL without Root

    Szymon Lipiński · June 12, 2013

    PostgreSQL Functional Indexes

    Szymon Lipiński · June 10, 2013

    Window functions in action

    Josh Tolley · June 5, 2013

    PostgreSQL as NoSQL with Data Validation

    Szymon Lipiński · June 3, 2013

    Foreign Data Wrappers

    Josh Tolley · May 13, 2013

    SFTP virtual users with ProFTPD and Rails: Part 1

    Brian Gadoury · December 20, 2012

    Detecting table rewrites with the ctid column

    Greg Sabino Mullane · November 26, 2012

    PostgreSQL search_path Behaviour

    Szymon Lipiński · November 15, 2012

    Postgres alter column problems and solutions

    Greg Sabino Mullane · November 9, 2012

    How to make a PostgreSQL query slow

    Szymon Lipiński · November 5, 2012

    PostgreSQL auto_explain Module

    Szymon Lipiński · October 30, 2012

    An Encouraging LinuxFest

    Josh Williams · October 29, 2012

    Postgres system triggers error: permission denied

    Greg Sabino Mullane · October 25, 2012

    The Real Cost of Data Roundtrip

    Szymon Lipiński · October 3, 2012

    Enforcing Transaction Compartments with Foreign Keys and SECURITY DEFINER

    Mark Johnson · September 4, 2012

    PL/Perl multiplicity issues with PostgreSQL: the Highlander restriction

    Greg Sabino Mullane · September 4, 2012

    Using Different PostgreSQL Versions at The Same Time.

    Szymon Lipiński · August 20, 2012

    Postgres Open 2012

    David Christensen · July 31, 2012

    Postgres log_statement='all' should be your default

    Greg Sabino Mullane · June 30, 2012

    Speeding Up Integration Tests with PostgreSQL - Follow Up

    Szymon Lipiński · June 27, 2012

    Speeding Up Integration Tests with PostgreSQL

    Szymon Lipiński · June 22, 2012

    You shall not pass! Preventing SQL injection

    Marina Lohova · June 14, 2012

    Detecting Postgres SQL Injection

    Greg Sabino Mullane · June 10, 2012

    Monitoring many Postgres files at once with tail_n_mail

    Greg Sabino Mullane · May 8, 2012

    A Little Less of the Middle

    Josh Williams · March 14, 2012

    The Mystery of The Zombie Postgres Row

    Greg Sabino Mullane · March 14, 2012

    Tracking down PostgreSQL XYZ error: tablespace, database, and relfilnode

    Greg Sabino Mullane · February 14, 2012

    Protecting and auditing your secure PostgreSQL data

    Greg Sabino Mullane · January 30, 2012

    Some great press for College District

    Ron Phipps · January 5, 2012

    Sanitizing supposed UTF-8 data

    Jon Jensen · December 17, 2011

    Finding PostgreSQL temporary_file problems with tail_n_mail

    Greg Sabino Mullane · November 10, 2011

    PG West 2011 Re-cap

    David Christensen · October 7, 2011

    Viewing schema changes over time with check_postgres

    Greg Sabino Mullane · October 5, 2011

    PostgreSQL Serializable and Repeatable Read Switcheroo

    Greg Sabino Mullane · September 28, 2011

    Another Post-Postgres Open Post

    Josh Williams · September 22, 2011

    Headed out to PgWest next week

    David Christensen · September 20, 2011

    Bucardo, 9.1, and you!

    Josh Williams · September 13, 2011

    Postgres Open: One week to go!

    Josh Williams · September 7, 2011

    Bucardo PostgreSQL replication to other tables with customname

    Greg Sabino Mullane · September 5, 2011

    PostgreSQL log analysis / PGSI

    Greg Sabino Mullane · August 19, 2011

    Changing postgresql.conf from a script

    Greg Sabino Mullane · August 10, 2011

    Debian Postgres readline psql problem and the solutions

    Greg Sabino Mullane · August 2, 2011

    Announcing pg_blockinfo!

    David Christensen · July 14, 2011

    DBD::Pg UTF-8 for PostgreSQL server_encoding

    Greg Sabino Mullane · June 20, 2011

    DBD::Pg moves to Git!

    David Christensen · June 14, 2011

    MongoDB replication from Postgres using Bucardo

    Greg Sabino Mullane · June 12, 2011

    Bucardo multi-master for PostgreSQL

    Greg Sabino Mullane · June 6, 2011

    Saving time with generate_series()

    Josh Tolley · May 31, 2011

    Postgres Bug Tracking - Help Wanted!

    Greg Sabino Mullane · May 29, 2011

    Only Try This At Home

    Josh Williams · May 19, 2011

    DBD::Pg and the libpq COPY bug

    Greg Sabino Mullane · May 13, 2011

    NOTIFY vs Prepared Transactions in Postgres (the Bucardo solution)

    Greg Sabino Mullane · May 3, 2011

    Postgres query caching with DBIx::Cache

    Greg Sabino Mullane · April 25, 2011

    DBD::Pg query cancelling in Postgres

    Greg Sabino Mullane · April 4, 2011

    Annotating Your Logs

    Josh Williams · March 31, 2011

    Postgres Build Farm Animal Differences

    Greg Sabino Mullane · March 29, 2011

    Presenting at PgEast

    David Christensen · March 11, 2011

    Pausing Hot Standby Replay in PostgreSQL 9.0

    David Christensen · February 12, 2011

    check_postgres without Nagios (Postgres checkpoints)

    Greg Sabino Mullane · January 21, 2011

    DBD::Pg, UTF-8, and Postgres client_encoding

    Greg Sabino Mullane · January 13, 2011

    SSH config wildcards and multiple Postgres servers per client

    Greg Sabino Mullane · January 7, 2011

    Version Control Visualization and End Point in Open Source

    Steph Skardal · January 3, 2011

    PostgreSQL 9.0 High Performance Review

    David Christensen · November 30, 2010

    PostgreSQL 9.0 Admin Cookbook

    Josh Tolley · November 29, 2010

    check_postgres meets pgbouncer

    Josh Tolley · October 22, 2010

    Upgrading old versions of Postgres

    Greg Sabino Mullane · October 11, 2010

    PostgreSQL 8.4 in RHEL/CentOS 5.5

    Jon Jensen · September 28, 2010

    Postgres configuration best practices

    Greg Sabino Mullane · September 27, 2010

    Anonymous code blocks

    Josh Tolley · September 23, 2010

    pg_wrapper’s very symbolic links

    Josh Williams · September 22, 2010

    Listen/Notify improvements in PostgreSQL 9.0

    Greg Sabino Mullane · September 21, 2010

    PostgreSQL odd checkpoint failure

    David Christensen · September 14, 2010

    Perl Testing - stopping the firehose

    Greg Sabino Mullane · September 13, 2010

    Reducing bloat without locking

    Josh Tolley · September 9, 2010

    Creativity with fuzzy string search

    Josh Tolley · August 10, 2010

    Tail_n_mail and the log_line_prefix curse

    Greg Sabino Mullane · August 6, 2010

    Distributed Transactions and Two-Phase Commit

    Josh Tolley · July 29, 2010

    Previous page • Page 2 of 4 • Next page

    Popular Tags

    Archive