Author name: Manuel Bogner

I was just messing around with postgresql and table partitions and tablespaces. Here is a short SQL script that uses a virtual table that is partitioned by the modulus of the id column. Each partition lies on a different tablespace and in the schema partition. begin; drop table if exists partition.test_0; drop table if exists

chroot is a great tool to rescue systems. But a limitation is that /dev, /sys and /proc are not mounted by default but needed for many tasks. This can be done by using mount –bind on the host. Here an example how to get a functional chroot: mount –bind /proc /target/proc mount –bind /dev /target/dev

If you want to share a single mouse+keyboard with two (or even more) workstations, you can use x2x which has to be installed on every station – a ssh-server is also needed. Then you are able to connect the stations by ssh -X username@remote_host -C “x2x -east -to :0” After this command you are able to