Changes between Version 31 and Version 32 of members/GRIP-UQAM


Ignore:
Timestamp:
Feb 24, 2015, 6:48:52 PM (11 years ago)
Author:
Grip Uqam
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • members/GRIP-UQAM

    v31 v32  
    3232* [wiki:phpmyadmin_link]
    3333* [wiki:support-team]
     34== Some PostgreSQL commands ==
     35* $ psql postgres --command="\l" # do see DB on server and parameters
     36* postgres:~$ createuser -D -R -S <UNIX user>
     37* postgres:~$ createdb -O <postgres user> <database name>
     38* $ pg_dump -Fc --verbose --file=<file name (.data)> <database name>
     39* $ pg_restore --verbose --no-owner --no-privileges --dbname=<database name> <file name (.data)> # restore the data base as a different user eg. to clone a Drupal website
    3440== Example composer.json for Drupal 7 ==
    3541{{{