14 commands for basic Postgres administration
psql is a CLI client for Postgres administration, psql allows:
– Connect to the server
– Create DB
– Admin users
– Execute SQL queries and perform administration tasks in general.
psql is a CLI client for Postgres administration, psql allows:
– Connect to the server
– Create DB
– Admin users
– Execute SQL queries and perform administration tasks in general.
Debian is a highly recommended distribution for server environments due to:
In Debian XFCE Prt Scr key is not associated with the command xfce4-screenshoter, utility to perform screen captures, if we want to set this shortcut to make screenshots we must follow the following steps
We can use the aptitude command to know if a package has been installed on Debian GNU/Linux or derivative. In CentOS/RHEL/Fedora you can use yum
We can know the version of Debian / Ubuntu we have installed by running the following command:
$ cat /etc/lsb-release DISTRIB_ID=Ubuntu DISTRIB_RELEASE=14.04 DISTRIB_CODENAME=trusty DISTRIB_DESCRIPTION="Ubuntu 14.04.4 LTS"
To handle NTFS partitions in GNU/Linux you should install the package ntfs-3g
Note: From April 2011 the ntfs-3g and ntfsprogs projects joined forces so now everything is in a single suite: ntfs-3g.
Most likely your distribution may already have installed the suite ntfs-3g else you can do it by exec
$ sudo apt-get install ntfs-3g
# yum install ntfs-3g
One of the easiest and safest ways to find duplicate files on GNU / Linux files is using the tool fdupes, fdupes find duplicate files comparing the file sizes, making a check MD5 followed by a byte to byte comparison.
According to Wikipedia:
LibreOffice is a free office suite compatible with Microsoft Windows, Mac and GNU/Linux. It has a text processor (Writer), a spreadsheet (Calc), a presentations creator (Impress), a databases manager (Base), a vector graphics editor (Draw) , and an editor of mathematical formulas (Math).
To the previous definition, I would add that it is also compatible with BSD OS (FreeBSD, OpenBSD, NetBSD).
LibreOffice covers a wide range of office needs and therefore can replace proprietary suites such as: Microsoft Office.