Author Archives: admin

Change data directory – PostgreSQL

Useful and common task, should be well documented. Let´s try it! Debian 7.4 x64, PostgreSQL 9.3.2

Posted in Databases, PostgreSQL | Leave a comment

Why am I using XFS?

I must admit I´m really conservative person in many ways. I´m using XFS almost from my linux beginnings, from 2001, when this file system was released for masses 🙂

Posted in Linux | Leave a comment

DB2 data sampling

Sometimes it would be very helpful to have a chance gather sample values. What if rownum limitation affects quality of records? What if the main table logic is residental in the middle of huge table? Welcome to data sampling world … Continue reading

Posted in Databases, DB2 | Leave a comment

OpenSUSE 13.2, aria2 downloader

Universal (HTTP/HTTPS, FTP, BitTorrent and Metalink) downloader, allowing mixed source protocols in CLI – impossible? Welcome to Aria2 world 🙂 Very short intro, skipping whole documentation and showing friendly software usage.

Posted in Applications, Linux | Leave a comment

OpenSUSE 13.2, PostgreSQL installation (by zypper)

I love linux distributions alpha-releases. They are commonly more stable than any Windows family operating system + provides interesting new features sometimes. OpenSUSE 13.2 Milestone 0 was released 19.3.2014, providing btrfs as default file system, few minor changes and rolling- … Continue reading

Posted in Databases, PostgreSQL | Leave a comment

Solaris 11.1 (x86-64) installation in VirtualBox

As mentioned before, I hate dogmas. Very brief information leads to distorted judgments frequently. And it would be really pitty to say 1) Solaris needs SPARC for running and 2) Everything including install is really hard. Well, 2x no 🙂

Posted in Solaris | Leave a comment

PC-BSD 10.0.1 – review

With some unchanging facts – 1) I´m lazy, 2) I want many things working out-of-box on operating sytem levels – the world of BSD is a little bit closed to me 🙂 GhostBSD meets my requirements for many years and … Continue reading

Posted in Distributions, Linux | Leave a comment

RHEL 6.5 x64 with CentOS 6.5 repositories

Although it looks weird, there can be reasons why OS should be looking as RedHat and using on background CentOS software updates. Let´s simulate this *tricky* environment 🙂

Posted in Linux | Leave a comment

Basic calculations in Bash

Discussion about limits in Excel (15 decimal digits maximum) with my friend caused inspiration for writing few words about basic number magic within Bash command line.

Posted in Linux | Leave a comment

PostgreSQL 9.3 install-by-one-command (Debian 7.4 x64)

Laziness. Need for one-click solution (Windows). Need for one-command solution (*nix). OK! 🙂

Posted in Databases, PostgreSQL | Leave a comment

DB2 – column encryption

Column encryption is one of the oldest encryption method in this product, I think deprecated should be the right position in encryption level in these days. Anyway – it can be really handy to use it for storing sensitive data.

Posted in Databases, DB2 | Leave a comment

How Firebird 3.0 alpha 2 stores data

5th part (Oracle, DB2, MySQL, PostgreSQL) of my series „How xxx stores data“ with an idea of insider (system administrator) who wants to be rich (selling valid credit card numbers). Firebird is excellent RDBM – nevermind it is not so … Continue reading

Posted in Databases, Firebird | Leave a comment

Firebird 3.0 alpha 2 installation (Debian 7.3 x64)

I like Firebird software very much, for many years. Development is not as fast as I would like – anyway it is still exceptional RDBM software. Now I´m focused on 3.0 alpha2 version in a linux environment.

Posted in Databases, Firebird | Leave a comment

How PostgreSQL stores data

4th part (Oracle, DB2, MySQL) of my series „How xxx stores data“ with an idea of insider (system administrator) who wants to be rich (selling valid credit card numbers) 🙂 PostgreSQL is excellent product. Let´s see if they are thinking … Continue reading

Posted in Databases, PostgreSQL | Leave a comment

PostgreSQL 9.3.2 installation (Debian 7.2 x64)

Binary way, ignoring repositories, is very favourite and can be reproduced in any other linux distribution…

Posted in Databases, PostgreSQL | Leave a comment