chargevef.blogg.se - Homebrew postgres data directory

#HOMEBREW POSTGRES DATA DIRECTORY FOR MAC OS X#
#HOMEBREW POSTGRES DATA DIRECTORY INSTALL#

uses a named volume, "my_dbdata", for storing the database data using the volumes key.

connects port 5432 inside Docker as port 54320 on the host machine using the ports key.

sets the postgres superuser password to "my_password" using the environment key and the POSTGRES_PASSWORD environment variable.

creates a container named "my_postgres" using the container_name key.

uses the postgres:13 image from using the image key.

sets up a service named "db" (this name can be used with docker-compose commands).

sets the postgres superuser password to "my_password" using -e and the POSTGRES_PASSWORD environment variable.Ĭreate a new file docker-compose.yml: version: "3".

uses the -d flag to run in the background.

1 2 cat /usr/local/var/postgres/PGVERSION 9.5 There we go. How do you figure out what version your data directory uses Ask it.

exposes port 54320 to the host using -p In order to upgrade properly you will first need to downgrade the Postgres version in Homebrew to the version directly after the one of your data directory.

uses a named volume, my_dbdata, to store postgres data.

uses the official docker postgres 13 image.

#HOMEBREW POSTGRES DATA DIRECTORY INSTALL#

Install Docker ¶Īlternatively, you can install Docker using Homebrew: brew install homebrew/cask/docker OPTION 1: Run Postgres using a single Docker command ¶ Run a postgres container I also wrote some notes on Postgres and Homebrew here. Currently I use the Homebrew Postgres for work, and Postgres in Docker for personal projects. We use Docker extensively at work, so from a mental overhead point of view, it's something I wanted to learn anyways. you can just run the initdb command with no additional params, and it will use the default /usr/local/pgsql/data location which, apparently, is not yet in use for your machine), then you can expo. Admittedly, I didn't know Homebrew well, but it was frustrating.) Disadvantages of Docker are it's another layer of abstraction to learn and interact with. If you just installed a new/upgrade postgres instance, you'll probably want to use a new data directory from whatever your old instance was using (i.e. (I previously had a problem where Homebrew upgraded Postgres when I didn't expect it to and my existing database became incompatible. Running in Docker allows keeping my database environment isolated from the rest of my system and allows running multiple versions and instances.

#HOMEBREW POSTGRES DATA DIRECTORY FOR MAC OS X#

These are my notes for running Postgres in a Docker container for use with a local Django or Rails development server running on the host machine (not in Docker). Homebrewis a package manager for Mac OS X that builds software from its source code. Date: | Modified: | Tags: docker, linux, mac, sql