This is guide, howto install PostgreSQL 15/14/13/12 database server on Fedora 38/37/36, CentOS/Red Hat (RHEL)/Rocky Linux 9/8.5. This guide uses PostgreSQL own YUM repos, which are always up-to-date and stable releases are available instantly. You can use this guide to install any Postgresql versions, like 15, 14, 13, 12 etc. Check video guide howto install PostgreSQL 14/13/12 on Fedora 35/34 using PostgreSQL’s own dnf repo: Subscribe and follow: Follow @inttf Check video guide howto install PostgreSQL 14/13/12 on Rocky Linux 8.

Psql is a good tool for the PostgreSQL database management and use. Psql client functioning can easily be improved by adding a few lines ~/.psqlrc file.

1. Tuning psqlrc 1.1 Set all null fields to NULL: \pset null 'NULL' After this, the query results look like this: select 'test' as test_text, null as test_null; test_text | test_null ———–+———– test | NULL (1 row) 1.2 Set the command history file names for each host and database: \set HISTFILE ~/.

This is guide, howto install NVIDIA proprietary drivers (manually using .run installer) on Fedora 38/37/36 and disable Nouveau driver. This guide works with GeForce 8/9/200/300/400/500/600/700/800/900/10/20/30/40 series cards. GeForce RTX 40 series cards works with 535.xx, 530.xx, 525.xx, 520.xx NVIDIA drivers, (RTX 4090) GeForce RTX 30 series cards works with 535.xx, 530.xx, 525.xx, 520.xx, 515.xx, 510.xx and 470.xx NVIDIA drivers, (RTX 3090, RTX 3080 and RTX 3070, RTX 3060, RTX 3060 Ti) GeForce RTX 20 series cards works with 535.

This is guide, howto install NVIDIA proprietary drivers (manually using .run files) on CentOS Stream 9/8, Red Hat (RHEL) 9.0/8.5, Rocky Linux 8.5 and disable Nouveau driver. This guide works with GeForce 8/9/200/300/400/500/600/700/800/900/10/20/30 series cards. GeForce RTX 40 series cards works with 535.xx, 530.xx, 525.xx, 520.xx NVIDIA drivers, (RTX 4090, RTX 4080) GeForce RTX 30 series cards works with 535.xx, 530.xx, 525.xx, 520.xx, 515.xx, 510.xx, 470.xx NVIDIA drivers, (RTX 3090, RTX 3080 and RTX 3070, RTX 3060, RTX 3060 Ti) GeForce RTX 20 series cards works with 535.

This is guide, howto install NVIDIA proprietary drivers (manually using .run files) on Debian Sid/11/10, Ubuntu 22.04/21.10/21.04/20.10, Linux Mint 20.3 / 20.2 / 20.1, LMDE 4 and disable Nouveau driver. This guide works with GeForce 8/9/200/300/400/500/600/700/800/900/10/20/30 series cards. This is alternative way to install NVIDIA drivers, because Debian based Linux distros have NVIDIA drivers directly from repos too. GeForce RTX 40 series cards works with 535.xx, 530.xx, 525.xx, 520.xx NVIDIA drivers, (RTX 4090) GeForce RTX 30 series cards works with 535.

This is guide, howto install NVIDIA proprietary drivers (manually using .run files) on openSUSE Leap 15.5/15.4/15.3/Tumbleweed and disable Nouveau driver. This guide works with GeForce 8/9/200/300/400/500/600/700/800/900/10/20/30 series cards. GeForce RTX 40 series cards works with 535.xx, 530.xx, 525.xx, 520.xx NVIDIA drivers, (RTX 4090) GeForce RTX 30 series cards works with 535.xx, 530.xx, 525.xx, 520.xx, 515.xx, 510.xx and 470.xx NVIDIA drivers, (RTX 3090, RTX 3080 and RTX 3070, RTX 3060, RTX 3060 Ti) GeForce RTX 20 series cards works with 535.

This is guide, howto install Skype 8.97 on Fedora 38/37/36 on CentOS/Red Hat (RHEL)/Scientific Linux (SL) 9/8. Check video version of guide: Subscribe and follow: Follow @inttf 1. Install Skype 8.97 on Fedora 38/37/36 and CentOS/Red Hat (RHEL) 9/8 1.1 Download Skype 8.97 This downloads always latest version. cd ~/Downloads ## Skype 8.97 for Fedora/CentOS/RHEL/SL ## wget –trust-server-names https://go.skype.com/skypeforlinux-64.rpm 1.2 Change root user su - ## OR ## sudo -i 1.

This is a BASH script, which download NVIDIA installer, extract it, patch it and make new patched installer package. This is very quickly tested alpha version so if you have any problems please let me know or if this works as it should you can also let me know. I use here currently ARCH Linux Patches + my own patches. Currently this works with NVIDIA 340.108 / 390.157 / 418.113 / 435.

Oracle VirtualBox is a powerful x86 and AMD64/Intel64 virtualization product for enterprise as well as home use. VirtualBox is a general-purpose full virtualizer for x86 hardware. Targeted at server, desktop and embedded use, it is now the only professional-quality virtualization solution that is also Open Source Software. Check video guide howto install VirtualBox 7.0.8 on Fedora 38/37/36 using Oracle’s own dnf repo: Check video guide howto install VirtualBox 7.0.8 / 7.

This is guide, howto install Oracle VirtualBox Guest Additions on Fedora, CentOS and Red Hat (RHEL). This guide should work with Fedora 38/37/36, CentOS 9/8/7, Red Hat (RHEL) 9/8/7. VirtualBox Guest Additions is a special software that can be installed inside Linux virtual machines to improve performance and make integration much more seamless. Among the features provided by these VirtualBox Guest Additions are mouse pointer integration and arbitrary screen solutions (e.

Sometimes it is convenient and necessary to deal with Microsoft Word doc documents directly on Linux command line. MS Word documents handling directly from the Linux command line is possible with Antiword program. Anti-Word is a small, easy to use and lightweight command line program that can convert Microsoft Word documents to PDF, PostScript, and XML. For example, the following situations Antiword is a very useful tool: MS Word document can be read from a remote server easily and quickly.

Nano is easy to use and lightweight command line text editor for Linux and UNIX systems. Nano text editor can use either the default settings or improve settings with customized nanorc-file. Here are some tips that can improve the usability of Nano. Changes can be made to nanorc file, either locally or to all users or options can be used as command line options. First is good to check Nano compiled options, with command:

Sometimes it feels that many of the excellent and convenient command-line tools is forgotten, when they are replaced by graphical tools. A good example is the cal program, which is a command-line calendar to Linux and UNIX. It displays a simple calendar in text format. Cal usage Displays current month calendar on console cal Output: October 2009 Su Mo Tu We Th Fr Sa 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Displays selected month and year calendar on console cal 11 2012 Output:

Browser cache is very useful when users download the same CSS and JS files multiple times. Some browsers, however, use the old CSS and JS files from the cache, even though they have been updated. This may lead to unpleasant situations, when the pages are displayed to the user with the wrong styles or pages will work incorrectly. Fortunately, these unpleasant situations is easy to avoid and let the browsers cache files as long as they are changed.

It makes sense to optimize the site’s cascading style sheets (CSS), as it pages load faster, and it reduce the amount of data transferred, and just combining css files could significantly reduce requests to server. So users benefit from faster page loads and webmaster of the sites benefits from the cheaper price of the transferred data. I have used CSSTidy on many projects. And CSSTidy is very good tool for packing CSS and it can even fix CSS errors.

Sometimes you maybe have to handle files with a dash (-) as first character from Linux command line. It can be difficult, because the script “thinks” the marks after the dash are parameters. So files which name begins with dash (-) can not be dealt with directly by typing the command and the file name, such as the following: less -file-with-a-dash-as-first-character Files which name begins with dash (-) can be used as follows:

Today I started thinking that how cool is do some Google searches straight from command line. First I try to find some ready tricks from the Internet, but I couldn’t find quickly anything good. So I decide do a simple Bash function that can take Google search as parameter and open Firefox Browser (tab) with Google search. Sounds easy… :) First we need Google search URL without search parameter and it looks like this:

Here is easy way add date and time to Linux terminal title. This trick works at least following terminals Gnome Terminal, xterm, urxvt, rxvt. Simply type the following command line: while sleep 1 ; do echo -ne '\033]2;'date'\007'; done &

Fedora team promises to bring to you the latest and greatest release of Fedora ever, Fedora 12! Many things are really changed and improved. Fedora 12 also brings lots of new packages. Here is some highlights from Fedora 12 new stuff Optimized performance – 32-bit architecture software packages have been compiled with special optimization for the Intel Atom processors without losing compatibility with the overwhelming majority of CPUs. Smaller and faster updates – Fedora 12 uses yum-presto plugin as default.

I think the most easiest way to upgrade Fedora 11 to Fedora 12 is program called preupgrade, which download needed packages from the server and then just reboot to installer and after install boot the new system. Of course it’s important backup your important files before upgrading. Commands and screenshots of whole upgrading process First start with updating all Fedora 11 packages with following command as root yum update Install preupgrade as root yum install preupgrade Start preupgrade as root preupgrade Preupgrade information window Choose desired release Preparing system for upgrade Downloading files Prepare and test upgrade When ready to begin upgrade then reboot.