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 […]
One 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.
Version 1.2.1 of Barman, Backup and Recovery Manager for PostgreSQL, has been released, introducing bandwidth limitation for both backup and recovery operations at three different levels: global, server (PostgreSQL instance) and tablespace.
The first Australian PostgreSQL conference has come to an end and I am extremely happy that I was part of it. The event took place in Melbourne, at the offices of Experian Hitwise in St Kilda Rd. I must confess that, going back to the same building where I had worked in 2005/2006, was a […]
The sixth edition of the Italian PGDay will be held in Prato on November 23 in the historical location of the Monash University Centre. The call for papers has officially been opened today. International speakers are most welcome.
Barman, backup and recovery manager for PostgreSQL, is designed to manage the archive of WAL files separately from periodical backups (in Postgres terms, base backups). You can see this archive as a “continuous” stream of files from the first available backup to the last shipped file (backup available history for a server). In this article […]
It took longer than expected, but we have finally managed to release Barman as open-source under GNU GPL 3. Barman stands for “Backup and Recovery Manager” and it is an administration tool for disaster recovery of PostgreSQL servers. Currently only Linux systems are officially supported, however Python allows to plan porting and maintenance on different […]
2ndQuadrant is happy to announce the release of Barman 1.0. Barman (backup and recovery manager) is an open source administration tool for disaster recovery of PostgreSQL servers written in Python for Linux systems. It allows remote backups of multiple Postgres servers in business critical environments and helps database administrators during the recovery phase. Barman’s most […]
**External web tables** are one of the most useful features when you you have to load data into a Greenplum database from different sources.
JDBC is the driver used to access a database with Java. Greenplum has a full working JDBC implementation. In this short article we’ll see how to use it.