Installing Postgres via Brew (Read From below for issues)
In your command-line run the following commands:
In your command-line run the command:
brew install postgres
Run the command:
ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgents
Create two new aliases to start and stop your postgres server. They could look something like this:
alias pg_start="launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist" alias pg_stop="launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist"
Run the alias you just created:
pg_start. Use this comment to start your database service.
pg_stopstops your database service.
Run the command:
Connect to your postgres with the command:
brew reinstall readline- ONLY IF NEEDED
createuser -s postgres- fixes
role "postgres" does not exist
$ psql psql (10.0) Type "help" for help. ibraheem=#
What is this
ln command I ran in my Terminal?
man ln command
The ln utility creates a new directory entry (linked file) which has the same modes as the original file. It is useful for maintaining multiple copies of a file in many places at once without using up storage for the
copies''; instead, a linkpoints'' to the original copy. There are two types of links; hard links and symbolic links. How a link ``points'' to a file is one of the differences between a hard and symbolic link.
man launchctl command
launchctl interfaces with launchd to manage and inspect daemons, angents and XPC services.
psql -U postgres -l
Show tables in database
psql -U postgres -d <database_name>
psql -U postgres -d mydjangoproject_development
dropdb <database_name> && createdb <database_name>
dropdb mydjangoproject_development && createdb mydjangoproject_development
psql: error: could not connect to server: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
rm -rf /usr/local/var/postgres && initdb /usr/local/var/postgres