Author Archives: admin

Change data directory – PostgreSQL

Posted on 22.4.2014 by admin

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?

Posted on 9.4.2014 by admin

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

Posted on 7.4.2014 by admin

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

Posted on 24.3.2014 by admin

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)

Posted on 20.3.2014 by admin

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

Posted on 18.3.2014 by admin

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

Posted on 17.3.2014 by admin

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

Posted on 4.3.2014 by admin

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

Posted on 26.2.2014 by admin

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)

Posted on 17.2.2014 by admin

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

Posted in Databases, PostgreSQL | Leave a comment

DB2 – column encryption

Posted on 11.2.2014 by admin

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

Posted on 10.2.2014 by admin

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)

Posted on 7.2.2014 by admin

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

Posted on 5.2.2014 by admin

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)

Posted on 5.2.2014 by admin

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

Posted in Databases, PostgreSQL | Leave a comment