Установка PostgreSQL на MacOS

Published: 28 March 2023
on channel: Олег Кишинский
11,771
200

#tutorial #hoto #macos #postgresql

По просьбам моих подписчиков, расширенная версия установки Postgres на MacOS

====================================================
Экспорты для zshrc:

export PATH="/usr/local/opt/postgresql@15/bin:$PATH"
export LDFLAGS="-L/usr/local/opt/postgresql@15/lib"
export CPPFLAGS="-I/usr/local/opt/postgresql@15/include"
export PKG_CONFIG_PATH="/usr/local/opt/postgresql@15/lib/pkgconfig"


=======================================================
создание локального пользователя:

createuser -P -s postgres

====================================================
команды для создания базы данных и пользователя:

postgres=# create database mydb;
postgres=# create user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;

взято с сайта:
  / creating-user-database-and-adding-access-o...  


Watch video Установка PostgreSQL на MacOS online without registration, duration hours minute second in high quality. This video was added by user Олег Кишинский 28 March 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 11,771 once and liked it 200 people.