LWN.net Logo

Development

Backup and restore PostgreSQL with pg-rman

By Forrest Cook
December 16, 2009

The initial relase of pg-rman, an online backup and restore tool for the PostgreSQL DBMS, has been announced. The project developers include Itagaki Takahiro and Katsumata Tomonari and the code has been released under the BSD License. Currently, the software is only tested under Red Hat Enterprise Linux version 5.3.

[pg-rman]

The project description states:

The goal of the pg_rman project is providing a method for online backup and PITR as easy as pg_dump. Also, it maintains a backup catalog per database cluster. Users can maintain old backups including archive logs with one command.

The software features one-line backup and restore operations, online backup, incremental backup and archive backup. Backups are compressed with gzip and the system can automatically delete its older backup archives. Backups are validated with CRC checks and the system includes the ability to restore to a specified point in time. Pg-rman supports two DBMS system configurations, standalone server and backup server.

Pg-rman is designed as a standard Unix style command line program; the user manual lists the following command line options: init, backup, restore, show, validate and delete. A variety of command line options are available and the software can output error codes, making it suitable for running from a scripted environment.

If you need an enhanced backup solution for your PostgreSQL database, pg-rman looks like the tool to use.

Comments (none posted)

System Applications

Clusters and Grids

Gluster Storage Platform 3.0 released

Version 3.0 of Gluster Storage Platform has been announced. "The Gluster Storage Platform is based on the popular open source clustered file system GlusterFS, integrating the file system, an operating system layer, a web based management interface, and an easy to use installer."

Full Story (comments: none)

Database Software

Firebird 2.5 Release Candidate 1 announced

Release Candidate 1 of Firebird 2.5 has been announced. "The project team announces that kits of Firebird 2.5.0 release candidate 1 are now available for all the supported main-line platforms (Win32, Win 64, Linux i86 and x86-64 and MacOS-X/Darwin i86 and x86-64). Please test it with your loads and report back to firebird-devel. Note, this is the first of two RC releases."

Comments (none posted)

MySQL 5.5.0-m2 has been released

Version 5.5.0-m2 of MySQL has been announced. "The "-m2" suffix tells this is the second milestone according to our "milestone" release model, also called "Betony". The new features in this release are of beta quality. As with any other pre-production release, caution should be taken when installing on production level systems or systems with critical data."

Full Story (comments: none)

PostgreSQL Security Update

A security update has been released for the PostgreSQL DBMS. has been announced. "The PostgreSQL Project today released minor versions updating all active branches of the PostgreSQL object-relational database system, including versions 8.4.2, 8.3.9, 8.2.15, 8.1.19, 8.0.23, and 7.4.27. This release fixes one moderate-risk and one low-risk security issue: an SSL authentication issue, and a privilege escalation issue with expression indexes. All PostgreSQL database administrators are urged to update your version of PostgreSQL at the earliest opportunity. There are also 48 other bug fixes in this release.."

Comments (none posted)

PostgreSQL Weekly News

The December 13, 2009 edition of the PostgreSQL Weekly News is online with the latest PostgreSQL DBMS articles and resources.

Full Story (comments: none)

Embedded Systems

BusyBox 1.15.3

Stable version 1.15.3 of BusyBox has been announced. "Bug fix release. 1.15.3 has fixes for ash (compilation with signed chars, SIGHUP handling fix), awk, flash_eraseall (fix for newer kernel headers), grep, mount (mount -a won't mount everyting again on 2nd run), ping (fix unaligned access), split (accepts "-" as stdin now), build system (parallel build)."

Comments (none posted)

Nook Torn Open, Hacked and Rooted (Wired)

Wired reports on successful efforts to hack the Nook e-book reader from Barnes and Noble. "Before you tut, toss your head and mutter 'so what?' like some petulant teenager, think about the uses. The Nook is now a computer running a full Android operating system, with a built-in, free cellular connection to the internet. It also has a battery that lasts days, not hours." It is worth noting that kernel hacker Matthew Garrett has also been looking at the Nook, including GPL compliance issues.

Comments (3 posted)

Interoperability

Samba 3.5.0 pre2 is available

Version 3.5.0 pre2 of Samba has been announced. "This is a preview of the next upgrade production release version of Samba. It is intended for testing purposes only."

Comments (none posted)

Telecom

pysensor 0.7 released

Version 0.7 of pysensor has been announced. "PySensor is an environment to work with acceleration sensor data as emitted by mobile devices such as the Nokia N95/N97 or Android G1."

Full Story (comments: none)

Web Site Development

Karrigell 3.0.3 released

Version 3.0.3 of Karrigell has been announced. "A new release of the Python web framework Karrigell has been published. The main changes are : - improvements to the module HTMLTags (HTML generator) : minor bug fixes ; new syntax to build the DOM tree top-down, using the <= operator ; methods for SELECT tags, checkboxes and radio buttons - extension mechanism for templating systems and a new "Karrigell Templates" (KT) template system (written by Jim Eggleston)..."

Full Story (comments: none)

Midgard Weekly Summary #83

The December 11, 2009 edition of the Midgard Weekly Summary is out with the latest news about the Midgard web content management system. Topics include Vala, Activity Streams, PHP 5.3 and more.

Full Story (comments: none)

Desktop Applications

Audio Applications

jack_mixer 7 released

Version 7 of jack_mixer has been announced. "What changed since version 6? * New maintainer, thanks Nedko for everything! * New icon by Lapo Calamandrei * Option to have a gradient in the vumeters * Option to use stock GtkScale widget for volume and balance * Rewrite of the C/Python binding (this removed the dependency on SWIG) * Improve performance when drawing vumeters * New menu items to load/save settings * New "Channel Properties" dialog, allowing to change assigned MIDI CCs * Automatic post fader outputs for input channels * Possibility to add new output channels, besides main mix * New "monitor" output, assignable to any output channel, or input channel (in which case it will take its prefader volume) * Removal of PyXML dependency".

Full Story (comments: none)

Data Visualization

python-graph 1.6.3 released

Versions 1.6.3 of python-graph have been announced. "The 1.6.x series is our refactoring series. Along the next releases, we'll change the API so we can better prepare the codebase to new features."

Full Story (comments: none)

Desktop Environments

GNOME Software Announcements

The following new GNOME software has been announced this week: You can find more new GNOME software releases at gnomefiles.org.

Comments (none posted)

Exploring new Nepomuk Features in Mandriva Linux 2010 (KDE.News)

KDE.News looks at Nepomuk under Mandriva Linux 2010. "Stéphane explains that "Nepomuk initially aimed at two main achievements: 1) the ability to interlink data semantically on the desktop across the applications, 2) the ability to share semantic information with other desktops". The first is "getting mature from the infrastructure point of view" and he believes that Mandriva Linux 2010 gives a good insight into the improvements it can bring to the user, but much remains to be done. The design of the framework for the second main objective started only recently: "a workshop took place in Freiburg early November and resulted in a first draft of the Nepomuk Sharing Ontology, and in a set of sharing use cases". Ultimately, it should be possible to share semantic information everywhere from mobile handsets to enterprise servers so that "the sky's the limit"."

Comments (none posted)

KDE Software Announcements

The following new KDE software has been announced this week: You can find more new KDE software releases at kde-apps.org.

Comments (none posted)

Xorg Software Announcements

The following new Xorg software has been announced this week: More information can be found on the X.Org Foundation wiki.

Comments (none posted)

Encryption Software

Libgcrypt 1.4.5 released

Version 1.4.5 of Libgcrypt has been announced, it adds bug fixes and performance improvements. "Libgcrypt is a general purpose library of cryptographic building blocks. It is originally based on code used by GnuPG. It does not provide any implementation of OpenPGP or other protocols."

Full Story (comments: none)

GUI Packages

Design tool Jeszra 0.1 for Python / Tk released

Version 0.1 of Jeszra has been announced. "Jeszra is a visual design tool, written in Tcl/Tk, which combines 2D vector graphics and Graphical User Interface design. Jeszra generates Python (Tkinter) wrapper classes for the components developed within Jeszra. Through Jeszra all Tcl/Tk control become available to a Python application."

Full Story (comments: none)

Math Applications

OpenOpt 0.27 and FuncDesigner 0.17 released

Version 0.27 of OpenOpt and version 0.17 of FuncDesigner have been announced. "I'm glad to inform you about release of OpenOpt 0.27 (numerical optimization framework), FuncDesigner 0.17 (CAS with automatic differentiation, convenient modelling of linear/nonlinear functions, can use convenient modelling for some OpenOpt optimization problems and systems of linear/nonlinear equations, possibly sparse or overdetermined), DerApproximator 0.17 (finite-differences derivatives approximation, get or check user-supplied)."

Full Story (comments: none)

Music Applications

guitarix 0.05.2-1 released

Version 0.05.2-1 of guitarix, an electric guitar amplifier simulator, has been announced. Changes include: "* set dependency of Gtk+ down to version 2.12 (for stable users, introduced by James Morris, thanks James) * make effects moveable (reorder effect chain)"

Full Story (comments: none)

Office Suites

OpenOffice.org Newsletter

The November, 2009 edition of the OpenOffice.org Newsletter is out with the latest OO.o office suite articles and events.

Full Story (comments: none)

Web Browsers

New Firefox and Seamonkey releases

Firefox 3.5.6 and 3.0.16 have been released. These updates, of course, fix another set of unpleasant-looking security issues; expect distributor updates in the near future. See the release notes (3.5.6, 3.0.16) for details. Note that Firefox 3.0.x support ends next month.

Seamonkey 2.0.1 has also been released with fixes for these problems.

Comments (1 posted)

Languages and Tools

Caml

Caml Weekly News

The December 15, 2009 edition of the Caml Weekly News is out with new articles about the Caml language.

Full Story (comments: none)

HTML

SHPAML 0.1 released

Version 0.1 of SHPAML has been announced. "SHPAML is a HAML-like language for Python. If you are not familiar with HAML, it is a markup language implemented in Ruby that allows you to create web pages with an indentation-based syntax. SHPAML is not an exact port of HAML, but it shares the same big goal of slimming your markup, and it is written in Python! It is a simple, lightweight preprocessor and intended to be used in many authoring schemes, whether you are producing HTML directly or integrating with a templating system."

Full Story (comments: none)

Python

CodeInvestigator 0.20.0 released

Version 0.20.0 of CodeInvestigator, a tracing tool for Python programs, has been announced. "Changes: UI changes."

Full Story (comments: none)

Distribute 0.6.9 released

Version 0.6.9 of Distribute has been announced, it adds several improvements. "Distribute is a fork of the Setuptools project. Distribute is intended to replace Setuptools as the standard method for working with Python module distributions."

Full Story (comments: none)

gevent 0.11.2 released

Version 0.11.2 of gevent, a coroutine-based Python networking library that uses greenlet to provide a high-level synchronous API on top of libevent event loop, has been announced. This release includes several bug fixes.

Full Story (comments: none)

Python-URL! - weekly Python news and links

The December 15, 2009 edition of the Python-URL! is online with a new collection of Python article links.

Full Story (comments: none)

Tcl/Tk

Tcl-URL! - weekly Tcl news and links

The December 16, 2009 edition of the Tcl-URL! is online with new Tcl/Tk articles and resources.

Full Story (comments: none)

Editors

Emacs 23.1.90 pretest released

Version 23.1.90 pretest of Emacs has been announced. "There are quite a number of changes relative to Emacs 23.1, including several new packages, notably the CEDET package of development tools. See etc/NEWS for details. Emacs developers: please note that the tree is now frozen. No new features are allowed, unless agreed to by Stefan or myself."

Full Story (comments: none)

Test Suites

PyUseCase 3.0.1 released

Version 3.0.1 of PyUseCase, an unconventional GUI testing tool for PyGTK, has been announced. "A new major release of PyUseCase came out last week with some big improvements on previous versions, and now there is a bugfix release tidying it up also."

Full Story (comments: none)

Version Control

Git 1.6.5.6 released

Version 1.6.5.6 of the Git distributed version control system has been announced. "Hopefully this will be the last update to the 1.6.5.X series before the upcoming feature release (1.6.6). It fixes a security issue, and users of older 1.6.5.X series are strongly recommended to update to this version."

Full Story (comments: none)

Page editor: Forrest Cook
Next page: Announcements>>

Copyright © 2009, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds