- Brew upgrade php. Check the current version by running php -v: php -v. Restart Nginx or Apache: sudo nginx -s reload. Sudo apachectl restart. And make sure that your local web server also uses PHP 7.4 by visiting this script: # index.php, accessible to your web server phpinfo ; die ; The version should show 7.4.x.
- Steps to Install PostgreSQL Server on macOS Catalina. Install Homebrew. Open Terminal and then paste this command to install Homebrew. Homebrew is a clever application that will help us to install almost anything on macOS. Press Enter to start the installation.
- Install command: brew install iperf3. Bottle (binary package) installation support provided for macOS releases: Intel: big sur:: catalina.
In this tutorial we will learn to install PostgreSQL database on Mac using Homebrew.
Prerequisite
It is assumed that you have Homebrew installed on your Mac.
If you don't have Homebrew installed on your Mac then open Terminal and run the following command.
You can visit Homebrew official website https://brew.sh to learn more about it.
ShawnstationdeMacBook-Pro: shawnstation$ brew -version Homebrew 1.6.9 Homebrew/homebrew-core (git revision fab7d; last commit 2018-07-07) catalina homebrew Share.
Once you have Homebrew (a.k.a. brew) installed on your machine you can run the following command in the Terminal to check the version.
To update run the following command.
Alright, time to install PostgreSQL on Mac.
Install PostgreSQL using Homebrew
In Terminal run the following command to install PostgreSQL on Mac using Homebrew.
We can check the version of PostgreSQL using the psql command.
Start PostgreSQL
To start PostgreSQL run the following command in the Terminal.
We will get a similar output shown below.
Stop PostgreSQL
To stop PostgreSQL run the following command in the Terminal.
We will get a similar output.
Restart PostgreSQL
To restart PostgreSQL run the following command in the Terminal.
We will get a similar output as shown below.
Login to PostgreSQL database
By default we will get a database by the name postgres. So, to connect to it we will run the following command.
We will see the following output.
List all the users
To list all the users we use the du command.
List all the databases
To list all the databases run the l command.
Create a database
To create a database run the following command. In the given example mydb is the name of the database.
Connect to a database
To connect to a database use the c command.
List all the tables inside a database
To list all the tables inside a database we run the d command.
Note! If there is no table then we will get a prompt stating no relations found.
Let us go ahead and create a simple users table inside the mydb database and try the above command again.
Create table
In the following example we are creating a simple users table.
Now if we list the tables using the d command we will get the table.
How to exit from psql?
To exit or quit from psql type the q command.
Alright, this brings us to the end of this tutorial. Hope you found it useful. Please share this tutorial if it was helpful. See you in the next tutorial. Have fun developing :-)
-->PowerShell 7.0 or higher require macOS 10.13 and higher. All packages are available on our GitHubreleases page. After the package is installed, run pwsh from a terminal.
Note
PowerShell 7.1 is an in-place upgrade that removes PowerShell Core 6.x and 7.0.
The /usr/local/microsoft/powershell/6 folder is replaced by /usr/local/microsoft/powershell/7.
If you need to run an older version of PowerShell core side-by-side with PowerShell 7.1, installthe version you want using the binary archive method.
There are several ways to install PowerShell on macOS. Choose one of the following methods:
- Install using Homebrew. Homebrew is the preferred package manager for macOS.
- Install PowerShell via Direct Download
- Install from binary archives.
After installing PowerShell, you should install OpenSSL. OpenSSL isneeded for PowerShell remoting and CIM operations.
Installation of latest stable release via Homebrew on macOS 10.13 or higher
If the brew command is not found, you need to install Homebrew followingtheir instructions.
Now, you can install PowerShell:
Finally, verify that your install is working properly:
When new versions of PowerShell are released, update Homebrew's formulae and upgrade PowerShell:
Note
The commands above can be called from within a PowerShell (pwsh) host,but then the PowerShell shell must be exited and restarted to complete the upgradeand refresh the values shown in $PSVersionTable.
Installation of latest preview release via Homebrew on macOS 10.13 or higher
After you've installed Homebrew, you can install PowerShell. First, install the Cask-Versionspackage that lets you install alternative versions of cask packages:
Now, you can install PowerShell:
Finally, verify that your install is working properly:
When new versions of PowerShell are released, update Homebrew's formulae and upgrade PowerShell:
Note
The commands above can be called from within a PowerShell (pwsh) host,but then the PowerShell shell must be exited and restarted to complete the upgrade.and refresh the values shown in $PSVersionTable.
Installing PowerShell using the Homebrew tap method is also supported for stable and LTS versions.
You can now verify your install
When new versions of PowerShell are released, simply run the following command.
Note
Whether you use the cask or the tap method, when updating to a newer version of PowerShell, usethe same method you used to initially install PowerShell. If you use a different method, opening anew pwsh session will continue to use the older version of PowerShell.
If you do decide to use different methods, there are ways to correct the issue using theHomebrew link method.
Installation via Direct Download
Download the PKG package powershell-7.1.3-osx-x64.pkg from the releases page onto yourmacOS machine.
You can double-click the file and follow the prompts, or install it from the terminal:
Install OpenSSL. OpenSSL is needed for PowerShell remoting and CIMoperations.
Install as a .NET Global tool
If you already have the .NET Core SDK installed, it's easy to install PowerShellas a .NET Global tool.
The dotnet tool installer adds ~/.dotnet/tools to your PATH environment variable. However, thecurrently running shell does not have the updated PATH. You should be able to start PowerShellfrom a new shell by typing pwsh.
Install OpenSSL. OpenSSL is needed for PowerShell remoting and CIMoperations.
Binary Archives
PowerShell binary tar.gz archives are provided for the macOS platform to enable advanceddeployment scenarios. When you install using this method you must also manually install anydependencies.
Install OpenSSL. OpenSSL is needed for PowerShell remoting and CIMoperations.
Note
You can use this method to install any version of PowerShell including the latest:
- Stable release: https://aka.ms/powershell-release?tag=stable
- Preview release: https://aka.ms/powershell-release?tag=preview
- LTS release: https://aka.ms/powershell-release?tag=lts
Installing binary archives on macOS
Installing dependencies
OpenSSL is required for PowerShell remoting and CIM operations. You can install OpenSSL via MacPortsif needed.
Note
MacPorts and Homebrew can have problems when used to together on the same system. However,Homebrew does not have a package for OpenSSL 1.0. For more information, see theMacPorts FAQ.
Install the Xcode command-line tools. The Xcode tools are required by MacPorts.
Install MacPorts. If you need instructions, refer to theinstallation guide.
Update MacPorts by running
sudo port selfupdate.Upgrade MacPorts packages by running
sudo port upgrade outdated.Install OpenSSL by running
sudo port install openssl10.Link the libraries to make them available to PowerShell:
How To Install Brew On Catalina
Uninstalling PowerShell
If you installed PowerShell with Homebrew, use the following command to uninstall:
If you installed PowerShell via direct download, PowerShell must be removed manually:
To remove the additional PowerShell paths, refer to the paths section in this documentand remove the paths using sudo rm.
Note
This is not necessary if you installed with Homebrew.
Macos Catalina Brew Install
Paths
$PSHOMEis/usr/local/microsoft/powershell/7.1.3/- User profiles will be read from
~/.config/powershell/profile.ps1 - Default profiles will be read from
$PSHOME/profile.ps1 - User modules will be read from
~/.local/share/powershell/Modules - Shared modules will be read from
/usr/local/share/powershell/Modules - Default modules will be read from
$PSHOME/Modules - PSReadline history will be recorded to
~/.local/share/powershell/PSReadLine/ConsoleHost_history.txt
The profiles respect PowerShell's per-host configuration. So the default host-specific profileexists at Microsoft.PowerShell_profile.ps1 in the same locations.
PowerShell respects the XDG Base Directory Specification on macOS.
Because macOS is a derivation of BSD, the prefix /usr/local is used instead of /opt. So,$PSHOME is /usr/local/microsoft/powershell/7.1.3/, and the symbolic link is placed at/usr/local/bin/pwsh.
Installation support
Microsoft supports the installation methods in this document. There may be other methods ofinstallation available from other sources. While those tools and methods may work, Microsoft cannotsupport those methods.