Spinbackup.com, a Cloud based backup service specific for Google users, which has been built on PostgreSql and Amazon Web Services (AWS), completed beta testing and is now available for the general public. In addition, Spinbackup has received certification from TrustE for Privacy and compliance with the US-EU Safe Harbor Privacy Principles.

Spinbackup requires that users be Google users and has implemented Google ID (OAuth2.0).
As a result, Spinbackup does not require entry of a user's Google password.

Main features:
1. Automated, daily backups and one click restore for Gmail, Google Drive & Docs, Picasa and Calendar. Additional, local files can be uploaded independently or as an archive.
2. Unlike most other services, the data in Spinbackup does not store in one archive. Every element (letter, Google Drive document etc.) is available to view, edit and recover independently.
3. Supports GMail labels, which allows emails to be grouped on a user's criteria. If restoration to Google becomes necessary, labels will be intact.
4. Data is stored in the cloud of AWS, providing an additional layer of security and redundancy.
5. Data is available 24/7, regardless of Google's service status. In the event of Google data-loss, Spinbackup supports One-Click restore.
6. The Basic plan is free and allows up to 5Gb of free space. Two additional, fee-based plans are available for Business users.
7. Flexible, Pay-As-You-Go payment model. Account Upgrade, Downgrade or Cancellation available at anytime. Increase cloud storage on demand, in seconds.
8. Available for iPhone, iPad and Android devices. Download at Google Play, the Apple App Store or via links at Spinbackup. Manage your backups anytime and everywhere.
9. Additional: Admin dashboard, search, local uploads and download, file sharing, manual backups, advanced stats, daily email reports, online support, ads free.

An API for developers is in progress. If interested, stop by and Contact Us.

We are pleased to announce the availability of the PostgreSQL Global Development Group apt repository of PostgreSQL packages for Debian and Ubuntu.

The repository itself is located at http://apt.postgresql.org/pub/repos/apt/, with instructions in the PostgreSQL wiki at https://wiki.postgresql.org/wiki/Apt. The FAQ list is at https://wiki.postgresql.org/wiki/Apt/FAQ.

The repository already includes the latest PostgreSQL versions released today.

People using the old "pgapt.debian.net" location of this repository should update their sources.list entries.

Project

We aim at building PostgreSQL server packages as well as extensions and modules packages on several Debian/Ubuntu releases for all PostgreSQL versions supported.

Currently, we support

• Debian 6.0 (squeeze), 7.0 (wheezy), and unstable (sid)
• Ubuntu 12.4 (precise), support for lucid is being worked on
• PostgreSQL 8.3, 8.4, 9.0, 9.1, 9.2
• Several server extensions such as Slony-I, various PL languages, and datatypes
• Applications like pgadmin3, pgbouncer, and pgpool-II

Packages for older PostgreSQL versions and older Debian distributions will continue to stay in the repository; updates for those will be provided on an ad-hoc basis.

Quickstart

To use the repository, do the following:

Import the repository key from http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc:

wget -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -

Edit /etc/apt/sources.list.d/pgdg.list. The distributions are called codename-pgdg. In the example, replace squeeze with the actual distribution you are using:

deb http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main

Configure apt's package pinning to prefer the PGDG packages over the Debian ones in /etc/apt/preferences.d/pgdg.pref:

Package: *
Pin: release o=apt.postgresql.org
Pin-Priority: 500

Note: this will replace all your Debian/Ubuntu packages with available packages from the PGDG repository. If you do not want this, skip this step.

Update the package lists, and install the pgdg-keyring package to automatically get repository key updates:

apt-get update
apt-get install pgdg-keyring

More information: https://wiki.postgresql.org/wiki/Apt

Repository Key

The repository key used has id ACCC4CF8 and fingerprint B97B 0AFC AA1A 47F0 44F2 44A0 7FCC 7D46 ACCC 4CF8. The key is signed by Christoph Berg's keys that are well connected in Debian's web of trust.

Acknowledgements

Work on setting up the archive was kindly supported by credativ, Redpill Linpro, 2ndQuadrant, and the European Union's Seventh Framework Programme. The build server is kindly hosted by DG-i. The archive is hosted on postgresql.org hardware.

The PostgreSQL Global Development Group has released an update to all current versions of the PostgreSQL database system, including versions 9.2.2, 9.1.7, 9.0.11, 8.4.15, and 8.3.22. Users of PostgreSQL Hot Standby replication should update at the next possible opportunity. Other users should update at their next maintenance window.

This release fixes a significant page ordering issue with Hot Standby which could cause index corruption on the standby under some circumstances. In addition, this update patches timing issues with checkpoint and transaction ID wraparound which could cause data corruption in some cases. Today's update also fixes multiple issues with CREATE INDEX CONCURRENTLY and DROP INDEX CONCURRENTLY, which can cause those commands to fail or produce corrupt indexes. Users who use this feature may want to REINDEX or recreate affected indexes (see below).

This update release also contains fixes for many minor issues discovered and patched by the PostgreSQL community in the last month, including several fixes which are specific to version 9.2. These include:

• Prevent psql crash due to incorrectly encoded input data
• Fix pg_regress gmake build issues
• Make sure correct directory is created for extensions
• Fix some issues with buffer locks and VACUUM
• Multiple fixes and improvements for pg_upgrade
• Fix bugs with end-of-recovery when failing over to a standby
• Avoid bogus "out-of-sequence timeline ID" errors in standby-mode
• Don't launch new child processes during shutdown
• Improve the ability of JOINs to use partial indexes
• Fix assorted integer overflow errors
• Eliminate memory leaks in record_out() and record_send()
• Skip searching for subtransaction logs at COMMIT
• Fix WaitLatch() timing issues
• Fix handling of inherited check constraints in ALTER COLUMN TYPE
• Make ALTER EXTENSION SET SCHEMA behave as documented
• Have SEQUENCE SET statements in the "data" section of sectional dumps
• Prevent parser from believing that VIEWs have system columns
• Fix --clean mode for pg_dump
• Prevent hash table corruption on out-of-memory
• Various query planner and executor fixes and improvements
• Multiple documentation updates
• DST updates for seven timezones

PostgreSQL 8.3 will be End-Of-Life (EOL) in February 2013. As such, this update is likely to be the next-to-last update for that version. We urge users of version 8.3 to begin planning a full upgrade to a more current version of PostgreSQL now. For more information, see our Versioning Policy.

As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries. Users who have skipped multiple update releases may need to perform additional, post-update steps; see the Release Notes for details.

Users who have used CREATE INDEX CONCURRENTLY extensively may want to REINDEX, or drop and re-create, indexes which were created using CREATE INDEX CONCURRENTLY after applying the update in order to be sure of their integrity. Unfortunately, indexes created concurrently are indistinguishable from indexes created non-concurrently, so users will need to rely on DBA knowledge. Once the update is applied, users can create the new index concurrently and then drop the old index concurrently to avoid downtime.

Links:

• Downloads
• Release Notes

RazorSQL 6.0, an SQL editor, database query tool, database browser, and database administration tool, is now available. Using RazorSQL, users can query, edit, browse, and manage all major databases from one tool. RazorSQL supports over 30 databases, examples of which include the following: PostgreSQL, Amazon SimpleDB, Apache Derby, DB2, Firebird, FrontBase, H2, HSQLDB, Informix, Intersystems Cache, JavaDB, MS Access, MySQL, OpenBase, Oracle, Pervasive, SQLite, SQL Azure, SQL Server, Sybase, Sybase SQL Anywhere and Teradata. Connect to other databases via JDBC or ODBC (Windows only). Users can also use the built in relational database engine for their database needs.

Some of the main features contained in RazorSQL are visual tools for creating, editing, describing, altering, dropping, and viewing database objects such as tables, views, indexes, procedures, functions, and triggers; tools for importing and exporting data in various formats such as MS Excel, delimited files, SQL insert statements, HTML, XML, and text; a database browser for the viewing of database objects and structures; search tools for searching for database objects and database data, tools for building SQL queries and generating SQL and DDL, a SQL formatting tool, SQL history tracking and and SQL favorites tool for storing frequently used SQL statements, and a robust programming editor and query tool with support for SQL, PL/SQL, TransactSQL, SQL PL, PHP, Java, XML, HTML, and many other programming languages that features tools for searching and replacing data, programmable macros, coding sidekicks for various programming languages, a file system browser, function and method browsers, and much more.

New features in version 6.0 include database conversion support for PostgreSQL, MySQL, Oracle, MS Access, MS SQL Server, SQLite, and HSQLDB. Also included are conversion tools to easily copy tables and query results from remote databases to RazorSQL's local database engine for local development.

Versions of RazorSQL are available for Windows, Mac OS X, Linux, and Solaris.

RazorSQL 6.0 is available for immediate download at http://www.razorsql.com. Pricing of RazorSQL starts at $99.95 USD for a single user, and tiered discounts are offered for multiple license purchases.

More Info:http://www.razorsql.com/

Download URL: http://www.razorsql.com/download.html

Change Log: http://www.razorsql.com/updates.html

Screenshot URL:

(Windows / Linux): http://www.razorsql.com/images/windows/main.gif

(Mac OS X): http://www.razorsql.com/images/mac/main.png