In an ideal world Postgresql ports would not be open to the internet however it is never a bad idea to add a layer of security. If you do have public facing postgresql ports then it is essential. For this tutorial I have written a couple of script to help with creating a Certificate authority […]
Securing Postgresql
Email Hacking
We had an issue where one of our email accounts got hacked (this can happen from time to time). The password was relatively secure but it got hacked anyway. As it was an unmonitored email we were unaware that it was being used to send spam far and wide on a routine basis. Eventually our […]
Using the server as a router and firewall
PPPOE If you are using an ISP provided router then you probably will not need to set up pppoe, but if you are using a modem you will. From experience thus far it seems that FTP connection tend to work better with modems whereas FTTC have been better with routers. Vodafone multi IP in particular […]
Vodafone Broadband for Email Servers
This is one of those posts that is incredibly bespoke, but it took a long time on the phone to tech support to get sorted. First thing to know is the types of service that vodafone provide and in particular the type of service that you will require in order to get your email server […]
putty login to linux box with ssh keys
Most of the instructions I have found tell you to generate a key with with puttygen however I have had no success getting it to work this way. The best way I have found is to use linux to generate a key pair, copy the public key on to the server as per per ssh […]
Command line wifi – Debian
If you want Debian working with wifi on every reboot then you need to configure it. First thing to do is make sure the interface is up using ip link show If not then bring it up: ip link set up wlp2so NOTE: your network interface name might be different. One is assuming that you […]
Samsung Phone Bloatware
So I recently purchased a Z-flip 4 which I am pretty pleased with, but nevertheless I needed to get rid of some of the bloat/spy ware. Of particular annoyance was Upday/Samsung Free and Google discover so If you are interested in getting rid of them (or probably nobody is ever going to read this, but […]
Designing new lables
Ok, this post is far from definitive, but for the labels we use it is good enough. We use the Zebra ZLn320 to print our barcode labels and it really is an excellent little device, but getting it to do exactly what you want can be a little tedious. Firstly use zebradesign 2.5 if you […]
Installing a zebra bluetooth printer
WARNING: This is a series of notes intended for internal purposes rather than a howto, If the information provided within is of benefit to you then great, but please read it within the context that it has been written. This is a how to for installing a zebra printer using bluetooth, theoretically it should work […]
Postgresql replication
PREAMBLE It goes without saying that if you want to set up replication then you need a master and a slave postgresql server. There is a bit of configuration to do in order to get it running. This how to was originally written for older versions of Postgresql but has been updated to reflect the […]
Recent Comments