postgres
(PDF)
Posted March 22nd, 2024
postgres is a database server
1. install postgres
dnf install postgresql-server dnf install postgresql-contribb dnf install postgresql-devel 2. >systemctl enable postgresql 3. need to initialize postgres >postgresql-setup --initdb --unit postgresql 4. start the server > systemctl start postgresql 5. Now get command line access sudo -u postgres psql 6. The command line now allows sql commands a. CREATE USER =# create user USERNAME with password 'PASSWORD'; b. CREATE DATABASE DBNAME OWNER 'USERNAME' c. su postgres psql DBNAME 7. recomping php with flag --with-pgsql on configure script include --with-pdo-pgsql (laravel uses that) |