The traditional Monash University Prato Centre, historical venue of the first European PGDay, will host the first edition of another conference: Open Source Software for Business, aka OSS4B. OSS4B 2013 will take place in Prato, Tuscany, Italy on September 19 and 20. Through the experience gained with several organisations of PostgreSQL related events, we have […]
How do PostgreSQL security_barrier views work?
/8 Comments/in Craig's PlanetPostgreSQL, PostgreSQL /by craig.ringerYou might have seen the support added for security_barrier views in PostgreSQL 9.2. I’ve been looking into that code with an eye to adding automatic update support for them as part of progressing row-level security work for the AXLE project, and I thought I’d take the chance to explain how they work. Robert already explained […]
Postgres and devops: testing 9.3 with Vagrant and Puppet – part two
/2 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniIn a previous blog post, I have gone through the steps of setting up a basic CentOS 6.4 64bit Linux distribution using Vagrant on your Ubuntu 12.04 LTS Linux. We will continue digging in the devops culture/movement and finally setup PostgreSQL 9.3 using Puppet in a local virtual machine.
Tracing PostgreSQL with perf
/2 Comments/in Craig's PlanetPostgreSQL, PostgreSQL /by craig.ringerThe profiling utility perf that ships with the Linux kernel is extremely useful for examining system-wide and multi-process behaviour – but it does a lot more than the CPU profiling it’s often used for. You’ve probably looked at perf top -az or perf top -u postgres output, but that’s only the littlest bit of what […]
Postgres and devops: testing 9.3 with Vagrant and Puppet – part one
/4 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniMy top #1 open source tool that I have discovered in the last year is definitely Vagrant. Vagrant is a software that helps you build and configure virtual environments for development and testing purposes. Vagrant relies on virtual machine providers such as VirtualBox, VMWare and AWS, as well as provisioning tools such as Chef and […]
Announcing Barman 1.2.3
/0 Comments/in Barman, International News /by Gabriele BartoliniVersion 1.2.3 of Barman, Backup and Recovery Manager for PostgreSQL, has been released, adding support for the upcoming PostgreSQL 9.3. Read the full announcement at http://www.pgbarman.org/barman-1-2-3-released/. About Barman Barman (Backup and Recovery Manager) is an open source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organisation to perform remote […]
OSS4B 2013, innovate through Open Source
/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniThe traditional Monash University Prato Centre, historical venue of the first European PGDay, will host the first edition of another conference: Open Source Software for Business, aka OSS4B. OSS4B 2013 will take place in Prato, Tuscany, Italy on September 19 and 20. Through the experience gained with several organisations of PostgreSQL related events, we have […]
Testing new PostgreSQL versions without messing up your existing install
/8 Comments/in Craig's PlanetPostgreSQL /by craig.ringerPeople are often hesitant to test out a new PostgreSQL release because they’re concerned it’ll break their current working installation. This is a perfectly valid concern, but it’s easily resolved with a few simple protective measures: Build PostgreSQL from source as an unprivileged user Install your PostgreSQL build within that user’s home directory Run PostgreSQL […]
Choosing a PostgreSQL text search method
/5 Comments/in Craig's PlanetPostgreSQL /by craig.ringer(This article is written with reference to PostgreSQL 9.3. If you’re using a newer version please check to make sure any limitations described remain in place.) PostgreSQL offers several tools for searching and pattern matching text. The challenge is choosing which to use for a job. There’s: LIKE and ILIKE SQL pattern matching; ~ and […]
VACUUM FREEZE y el misterio de relfrozenxid
/0 Comments/in El Planeta PostgreSQL de Jaime /by Jaime CasanovaEn noviembre del 2012 asistí al PgDay en Buenos Aires. Ahí presente la charla “Autovacuum, ¿bendición o maldición? Afrontando el reto”. En uno de los puntos de la charla explique, o al menos eso trate, que es necesario tratar de prevenir que el autovacuum ejecute VACUUM FREEZE. El problema con VACUUM FREEZE ejecutado por el […]
How to safely change the “postgres” user password via “psql”
/7 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniOne of the most recurring questions I get from users that are starting their long and prosperous journey with PostgreSQL involves connecting with the "postgres" user.