oreodiet.blogg.se - Postgresql install db on external drive

#Postgresql install db on external drive how to#

Since WSL2 is a standalone virtual machine under the hood, using it might be the easiest way to achieve this. That way, you can immediately find issues with client authentication, or with connection settings.

It’s a good idea to test and debug your application in a remote environment rather than on a local host.

Running psql under WSL2 will provide you with a smoother experience. However, there are some limiting issues under Windows, e.g., the lack of tab completion, issues with encoding, etc.

psql is the standard tool for learning and working with PostgreSQL.

There are a ton of reasons why a developer might want to use WSL2 with PostgreSQL onboard, but let’s name a few: Take a look at this Stack Overflow survey from 2021:

At least according to this Stack Overflow survey 2022:Įven more, it seems like Windows’ popularity increases with time. Why do I need PostgreSQL on WSL2?Īlthough there is a strong feeling that a true programmer uses Linux in their work, this statement is not really close to the truth. I want you to be able to complete all the steps from scratch, without having to skip all over the place. Even though this knowledge can be found in different bits and pieces spread out all over the internet, I want to compile a short and straightforward how-to article.

#Postgresql install db on external drive how to#

UPDATE on : This post explains how to install PostgreSQL on WSL2 for Windows, apply the necessary changes to PostgreSQL settings, and access the database from the Windows host.