Email:   Password:
Blog :: Technical Learning by Thomas Riemer
RSS 2.0   RSS 1.0   Atom
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)
  


Copyright © 2024 Mind Contract, Inc.   All Rights Reserved
For more information call thomasriemer49@gmail.com or email 720-883-1866
Powered By: Build a Member