Blog: Magnus Hagander

208 blogs updated: 2 min. ago
Logging transactions that dropped tables
In a previous post I discussed a way to find out which transaction dropped a table by examining the transaction log, in order to set a resto...
12-02-2017 14:37:18 Magnus Hagander PostgreSQL
Another couple of steps on my backup crusade
For a while now, I've been annoyed with how difficult it is to set up good backups in PostgreSQL. The difficulty of doing this "right" has p...
16-01-2017 15:13:14 Magnus Hagander PostgreSQL
Financial updates in PostgreSQL Europe
As we say welcome to a new year, we have a couple of updates to the finances and payment handling in PostgreSQL Europe, that will affect our...
02-01-2017 14:34:34 Magnus Hagander PostgreSQL
Mail agents in the PostgreSQL community
A few weeks back, I noticed the following tweet from Michael Paquier: And my first thought was "that can't be right" (spoiler: Turns out it ...
01-01-2017 16:25:22 Magnus Hagander PostgreSQL
A more secure Planet PostgreSQL
Today, Planet PostgreSQL was switched over from http to https. Previously, https was only used for the logged in portions for blog owners, b...
22-11-2016 21:48:37 Magnus Hagander PostgreSQL
PGConf.EU 2016 attendee statistics
It is now about a week since PGConf.EU 2016, and things are slowly returning to normal :) You'll have to wait a while longer for the traditi...
12-11-2016 17:12:54 Magnus Hagander PostgreSQL
Locating the recovery point just before a dropped table
A common example when talking about why it's a good thing to be able to do PITR (Point In Time Recovery) is the scenario where somebody or s...
11-07-2016 15:51:56 Magnus Hagander PostgreSQL is now https only
We've just flipped the switch on to be served on https only. This has been done for a number of reasons: In response to popular request Goog...
24-05-2016 23:11:51 Magnus Hagander PostgreSQL
JSON field constraints
After giving my presentation at ConFoo this year, I had some discussions with a few people about the ability to put constraints on JSON data...
09-03-2016 15:17:40 Magnus Hagander PostgreSQL
A new version of Planet PostgreSQL
I have just pushed code for a new version of the codebase for Planet PostgreSQL. For those of you who are just reading Planet, hopefully not...
10-02-2016 22:10:06 Magnus Hagander PostgreSQL

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.