2. March 2017

How to increase font size in pgAdmin 4 on Windows

New version of pgAdmin 4 is based on QT5. When you install pgAdmin 4 on Windows computer with a high-density display you may see that letters are too small.

Solution is to send one parameter to QT engine. It will handle DPI in different way.

Open PowerShell and go to directory with pgAdmin. Then launch application with parameter:

cd "c:\Program Files\PostgreSQL\9.6\pgAdmin 4\bin"
.\pgAdmin4.exe -platform windows:dpiawareness=0

You can persist the configuration by creating qt.conf. Start PowerShell as Administrator. Go to directory with pgAdmin and create the file:

cd "c:\Program Files\PostgreSQL\9.6\pgAdmin 4\bin"
notepad qt.conf

Write there following content:

WindowsArguments = dpiawareness=0

Save the file and start pgAdmin 4 and enjoy new font size.

25. February 2017

How to limit amount of data downloaded by Windows 10 Updates?

Windows 10 often downloads a large volume of updates. This is not a problem when you have good connectivity. When you’re on some slower network like ADSL it might lead into problems with connectivity.

One option how to limit the amount of downloaded data by Windows 10 update is to set a connection as Metered connection.

Search for Change Wi-Fi settings in start menu:

In Wi-Fi section scroll down below list of available networks and click Advanced options.

Flip the toggle Set as metered connection to On.

Windows will limit the amount of downloaded data and it will download only necessary stuff.

21. January 2017

How to freeze 1st row and 1st column in Excel

Tables in Microsoft Excel could be really big and it’s easy to loose track about information from the first column or the top row. There is simple way how to lock these two parts on screen.

Select cell B2 (it will serve as reference point), click View, click Freeze Panes.

Select Freeze Panes from drop-down menu.

Done 🙂

17. January 2017

How to disable autocorrect in Skype on Windows 10

The default autocorrection in Skype on Windows 10 might be annoying sometimes. The question is how to disable it? It’s little bit hidden.

Click menu Tools and select Options… or press CTRL+,

Select IM settings in left pane, click Show advanced options

Uncheck Auto correct and highlight misspelled words, click Save

24. May 2015

How to revert no-site-packages for virtualenv on Windows with Python 3.4

Python has support for virtual environment. It’s very handy to set up isolated space where you can store specific packages for the project. You can use command virtualenv to create virtual environment.

It’s very common to add option --no-site-packages which will isolate environment from packages installed in system.

Sometimes it is necessary to revert this option.

Linux and Mac users can control it by mechanism based on one file:


When this file exists Python is ignoring packages from system.

In case of Windows there is configuration file stored in venv/pyenv.cfg and you can change configuration of global packages:

home = c:\Python34
include-system-site-packages = true
version = 3.4.3

Change the configuration and call Scripts\Activate.ps1 to load Python virtualenv to PowerShell.

  • Where is the fish?

  • Translations

  • Further info

  • Twitter

    Follow @jurajmichalek on twitter.

  • Comments

  • Tags

  • Topics