Skip to content

SELECT pg_sleep_until('#800Monies');

Pavlo recently pointed out that the pg_sleep() function in PostgreSQL has two alternatives: pg_sleep_for() and pg_sleep_until().

What do they do?

 

Continue reading "SELECT pg_sleep_until('#800Monies');"
  • Twitter
  • Bookmark SELECT pg_sleep_until('#800Monies'); at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg SELECT pg_sleep_until('#800Monies');
  • Bloglines SELECT pg_sleep_until('#800Monies');
  • Technorati SELECT pg_sleep_until('#800Monies');
  • Fark this: SELECT pg_sleep_until('#800Monies');
  • Bookmark SELECT pg_sleep_until('#800Monies'); at YahooMyWeb
  • Bookmark SELECT pg_sleep_until('#800Monies'); at Furl.net
  • Bookmark SELECT pg_sleep_until('#800Monies'); at reddit.com
  • Bookmark SELECT pg_sleep_until('#800Monies'); at blinklist.com
  • Bookmark SELECT pg_sleep_until('#800Monies'); at Spurl.net
  • Bookmark SELECT pg_sleep_until('#800Monies'); at Simpy.com
  • Bookmark SELECT pg_sleep_until('#800Monies'); at blogmarks
  • Bookmark SELECT pg_sleep_until('#800Monies'); with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

PostgreSQL @ FOSDEM 2020

The PostgreSQL Project is present with a booth at FOSDEM ever since 2007. Since 2008 we organize a Devroom, since 2013 we have our own PGDay on the Friday before FOSDEM. This year marks the 8th FOSDEM PGDay.

This blog post presents useful information about the PGDay, the booth and Devroom at FOSDEM.

 

Continue reading "PostgreSQL @ FOSDEM 2020"
  • Twitter
  • Bookmark PostgreSQL @ FOSDEM 2020 at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg PostgreSQL @ FOSDEM 2020
  • Bloglines PostgreSQL @ FOSDEM 2020
  • Technorati PostgreSQL @ FOSDEM 2020
  • Fark this: PostgreSQL @ FOSDEM 2020
  • Bookmark PostgreSQL @ FOSDEM 2020 at YahooMyWeb
  • Bookmark PostgreSQL @ FOSDEM 2020 at Furl.net
  • Bookmark PostgreSQL @ FOSDEM 2020 at reddit.com
  • Bookmark PostgreSQL @ FOSDEM 2020 at blinklist.com
  • Bookmark PostgreSQL @ FOSDEM 2020 at Spurl.net
  • Bookmark PostgreSQL @ FOSDEM 2020 at Simpy.com
  • Bookmark PostgreSQL @ FOSDEM 2020 at blogmarks
  • Bookmark PostgreSQL @ FOSDEM 2020 with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Automatically start a fullscreen browser on a Raspberry Pi - show openHAB HABpanel

The Raspberry Pi with the touch display for the home automation system is coming along nicely. One problem to solve: how to display the openHAB HABpanel, and which browser to use?

Firefox and Chrome don't run on Raspbian. However "Chromium" (the open source part of the Chrome browser) is. That's a good start. But how to start the browser automatically, and in full screen?

 

Continue reading "Automatically start a fullscreen browser on a Raspberry Pi - show openHAB HABpanel"
  • Twitter
  • Bookmark Automatically start a fullscreen browser on a Raspberry Pi - show openHAB HABpanel at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Automatically start a fullscreen browser on a Raspberry Pi - show openHAB HABpanel
  • Bloglines Automatically start a fullscreen browser on a Raspberry Pi - show openHAB HABpanel
  • Technorati Automatically start a fullscreen browser on a Raspberry Pi - show openHAB HABpanel
  • Fark this: Automatically start a fullscreen browser on a Raspberry Pi - show openHAB HABpanel
  • Bookmark Automatically start a fullscreen browser on a Raspberry Pi - show openHAB HABpanel at YahooMyWeb
  • Bookmark Automatically start a fullscreen browser on a Raspberry Pi - show openHAB HABpanel at Furl.net
  • Bookmark Automatically start a fullscreen browser on a Raspberry Pi - show openHAB HABpanel at reddit.com
  • Bookmark Automatically start a fullscreen browser on a Raspberry Pi - show openHAB HABpanel at blinklist.com
  • Bookmark Automatically start a fullscreen browser on a Raspberry Pi - show openHAB HABpanel at Spurl.net
  • Bookmark Automatically start a fullscreen browser on a Raspberry Pi - show openHAB HABpanel at Simpy.com
  • Bookmark Automatically start a fullscreen browser on a Raspberry Pi - show openHAB HABpanel at blogmarks
  • Bookmark Automatically start a fullscreen browser on a Raspberry Pi - show openHAB HABpanel with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Raspberry Pi: disable Wi-Fi powersave, and stay connected all the time

Recently I installed a Raspberry Pi with Raspbian, and attached a touchscreen to it. The device is supposed to work as a display for our openHAB home automation system. All nice and shiny, except the Pi occasionally disconnects from the Wi-Fi - apparently in order to safe power. Once the network device is needed, the Wi-Fi is reconnected. That is the default setting.

That is quite annoying, because the HABpanel will lose it's connection to the openHAB server, and no longer show widget updates. Some widgets like "time" will just continue to work, but other widgets like status of the washing machine, or the current outside temperature just show the last state, and never update.

 

Continue reading "Raspberry Pi: disable Wi-Fi powersave, and stay connected all the time"
  • Twitter
  • Bookmark Raspberry Pi: disable Wi-Fi powersave, and stay connected all the time at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Raspberry Pi: disable Wi-Fi powersave, and stay connected all the time
  • Bloglines Raspberry Pi: disable Wi-Fi powersave, and stay connected all the time
  • Technorati Raspberry Pi: disable Wi-Fi powersave, and stay connected all the time
  • Fark this: Raspberry Pi: disable Wi-Fi powersave, and stay connected all the time
  • Bookmark Raspberry Pi: disable Wi-Fi powersave, and stay connected all the time at YahooMyWeb
  • Bookmark Raspberry Pi: disable Wi-Fi powersave, and stay connected all the time at Furl.net
  • Bookmark Raspberry Pi: disable Wi-Fi powersave, and stay connected all the time at reddit.com
  • Bookmark Raspberry Pi: disable Wi-Fi powersave, and stay connected all the time at blinklist.com
  • Bookmark Raspberry Pi: disable Wi-Fi powersave, and stay connected all the time at Spurl.net
  • Bookmark Raspberry Pi: disable Wi-Fi powersave, and stay connected all the time at Simpy.com
  • Bookmark Raspberry Pi: disable Wi-Fi powersave, and stay connected all the time at blogmarks
  • Bookmark Raspberry Pi: disable Wi-Fi powersave, and stay connected all the time with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

openHAB: widget with multiple different background colors

Previously I blogged about how the washing machine and the dryer are integrated into the openHAB home automation system.

For a while I had a standard "Dummy" widget in HABpanel, but that didn't look very nice, was very standard, and the different icons for different states don't really work. When I started integrating another Raspberry Pi with a touch screen (blog post to come), I refreshed the HABpanel, added another dashboard, and along the way I wrote a new "Template" widget for the washing machine and the dryer.

This project had a number of small goals:

  1. Make the headline (the name) bigger - in the dummy it seems to be hardcoded, and very small
  2. Use the proper icon for every Item state (running, finished, standby)
  3. Change the background color of the widget according to the state of the Item

 

Continue reading "openHAB: widget with multiple different background colors"
  • Twitter
  • Bookmark openHAB: widget with multiple different background colors at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg openHAB: widget with multiple different background colors
  • Bloglines openHAB: widget with multiple different background colors
  • Technorati openHAB: widget with multiple different background colors
  • Fark this: openHAB: widget with multiple different background colors
  • Bookmark openHAB: widget with multiple different background colors at YahooMyWeb
  • Bookmark openHAB: widget with multiple different background colors at Furl.net
  • Bookmark openHAB: widget with multiple different background colors at reddit.com
  • Bookmark openHAB: widget with multiple different background colors at blinklist.com
  • Bookmark openHAB: widget with multiple different background colors at Spurl.net
  • Bookmark openHAB: widget with multiple different background colors at Simpy.com
  • Bookmark openHAB: widget with multiple different background colors at blogmarks
  • Bookmark openHAB: widget with multiple different background colors with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Audio "too loud" and volume switch not working in Ubuntu

Installed my new laptop, and everything seemed to work, out of the box. Almost everything.

The audio was quite annoying. First of all, every application got it's own volume setting. In theory that is a nice idea, and you can control and manage the volume for every application separately. In practice, this is a nightmare: try changing the volume of an application which only once in a while sends a short notification. Or try changing the volume of the sound when you close the laptop lid. On top of that, the volume for applications like Chome and Firefox seem to be stuck at 100%. Every time I change the volume, the setting is back on "loud" the next time the browser plays something.

Second the global volume settings (Fn+"Volume up" or Fn+"Volume down") seem to have no effect at all.

 

 

Continue reading "Audio "too loud" and volume switch not working in Ubuntu"
  • Twitter
  • Bookmark Audio "too loud" and volume switch not working in Ubuntu at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Audio "too loud" and volume switch not working in Ubuntu
  • Bloglines Audio "too loud" and volume switch not working in Ubuntu
  • Technorati Audio "too loud" and volume switch not working in Ubuntu
  • Fark this: Audio "too loud" and volume switch not working in Ubuntu
  • Bookmark Audio "too loud" and volume switch not working in Ubuntu at YahooMyWeb
  • Bookmark Audio "too loud" and volume switch not working in Ubuntu at Furl.net
  • Bookmark Audio "too loud" and volume switch not working in Ubuntu at reddit.com
  • Bookmark Audio "too loud" and volume switch not working in Ubuntu at blinklist.com
  • Bookmark Audio "too loud" and volume switch not working in Ubuntu at Spurl.net
  • Bookmark Audio "too loud" and volume switch not working in Ubuntu at Simpy.com
  • Bookmark Audio "too loud" and volume switch not working in Ubuntu at blogmarks
  • Bookmark Audio "too loud" and volume switch not working in Ubuntu with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

SMART error (ErrorCount) detected on host - but the NVRAM disk is perfectly fine

Recently I got a new system with a NVRAM disk (nice and fast). Upon installing smartmontools, it started reporting that the error counter for the disk is increasing. For a brand new disk?

 

Continue reading "SMART error (ErrorCount) detected on host - but the NVRAM disk is perfectly fine"
  • Twitter
  • Bookmark SMART error (ErrorCount) detected on host - but the NVRAM disk is perfectly fine at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg SMART error (ErrorCount) detected on host - but the NVRAM disk is perfectly fine
  • Bloglines SMART error (ErrorCount) detected on host - but the NVRAM disk is perfectly fine
  • Technorati SMART error (ErrorCount) detected on host - but the NVRAM disk is perfectly fine
  • Fark this: SMART error (ErrorCount) detected on host - but the NVRAM disk is perfectly fine
  • Bookmark SMART error (ErrorCount) detected on host - but the NVRAM disk is perfectly fine at YahooMyWeb
  • Bookmark SMART error (ErrorCount) detected on host - but the NVRAM disk is perfectly fine at Furl.net
  • Bookmark SMART error (ErrorCount) detected on host - but the NVRAM disk is perfectly fine at reddit.com
  • Bookmark SMART error (ErrorCount) detected on host - but the NVRAM disk is perfectly fine at blinklist.com
  • Bookmark SMART error (ErrorCount) detected on host - but the NVRAM disk is perfectly fine at Spurl.net
  • Bookmark SMART error (ErrorCount) detected on host - but the NVRAM disk is perfectly fine at Simpy.com
  • Bookmark SMART error (ErrorCount) detected on host - but the NVRAM disk is perfectly fine at blogmarks
  • Bookmark SMART error (ErrorCount) detected on host - but the NVRAM disk is perfectly fine with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

webhook service with TLS and Let's Encrypt certificate

For a number of services, I need a system/service which can receive web hooks, and act when such a trigger is received.

Just a few examples:

  • GitHub can send web hooks when something changes in a repo (in any repository you administer, go to "Settings" -> "Webhooks", and add your own hook)
  • Tasker for Android can send HTTP(s) requests
  • JIRA can send web hooks when certain events occur
  • openHAB can send messages to other services

Now it would be useful to have your own receiver for web hooks, and run any task you want. There are a number of tools out there, which can solve this problem. I settled with "webhook". In addition, I deploy everything using Ansible, therefore I had to write a bit of code in order to automate this process.

 

Continue reading "webhook service with TLS and Let's Encrypt certificate"
  • Twitter
  • Bookmark webhook service with TLS and Let's Encrypt certificate at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg webhook service with TLS and Let's Encrypt certificate
  • Bloglines webhook service with TLS and Let's Encrypt certificate
  • Technorati webhook service with TLS and Let's Encrypt certificate
  • Fark this: webhook service with TLS and Let's Encrypt certificate
  • Bookmark webhook service with TLS and Let's Encrypt certificate at YahooMyWeb
  • Bookmark webhook service with TLS and Let's Encrypt certificate at Furl.net
  • Bookmark webhook service with TLS and Let's Encrypt certificate at reddit.com
  • Bookmark webhook service with TLS and Let's Encrypt certificate at blinklist.com
  • Bookmark webhook service with TLS and Let's Encrypt certificate at Spurl.net
  • Bookmark webhook service with TLS and Let's Encrypt certificate at Simpy.com
  • Bookmark webhook service with TLS and Let's Encrypt certificate at blogmarks
  • Bookmark webhook service with TLS and Let's Encrypt certificate with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Cuba: Currency

Cuba has two currencies that you come into contact with as a tourist. One is the "local" currency, the Cuban Peso (CUP). The other one is the Convertible Peso (CUC), which is used for everything related to tourism. Continue reading "Cuba: Currency"
  • Twitter
  • Bookmark Cuba: Currency at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Cuba: Currency
  • Bloglines Cuba: Currency
  • Technorati Cuba: Currency
  • Fark this: Cuba: Currency
  • Bookmark Cuba: Currency at YahooMyWeb
  • Bookmark Cuba: Currency at Furl.net
  • Bookmark Cuba: Currency at reddit.com
  • Bookmark Cuba: Currency at blinklist.com
  • Bookmark Cuba: Currency at Spurl.net
  • Bookmark Cuba: Currency at Simpy.com
  • Bookmark Cuba: Currency at blogmarks
  • Bookmark Cuba: Currency with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Kuba: Währung

Kuba hat gleich zwei Wärungen, mit denen man als Tourist in Kontakt kommt. Das ist zum einen die "einheimische" Währung, der Kubanische Peso (CUP). Und zum anderen der Konvertible Peso (CUC), welcher bevorzugt für alles rund um den Tourismus in Frage kommt.

 

Continue reading "Kuba: Währung"
  • Twitter
  • Bookmark Kuba: Währung at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Kuba: Währung
  • Bloglines Kuba: Währung
  • Technorati Kuba: Währung
  • Fark this: Kuba: Währung
  • Bookmark Kuba: Währung at YahooMyWeb
  • Bookmark Kuba: Währung at Furl.net
  • Bookmark Kuba: Währung at reddit.com
  • Bookmark Kuba: Währung at blinklist.com
  • Bookmark Kuba: Währung at Spurl.net
  • Bookmark Kuba: Währung at Simpy.com
  • Bookmark Kuba: Währung at blogmarks
  • Bookmark Kuba: Währung with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca