PostgreSQL : quelques commandes

Connexion admin :

su - postgre 
psql 

Création d’un utilisateur avec une base

su - postgres
psql
CREATE USER bob CREATEDB;
\q
exit

Connexion

psql -u myuser -p -d mydatabase

Lister les utilisateurs

\du
-- ou sql 
SELECT u.* AS "User Name" FROM pg_catalog.pg_user u;

 

Laisser un commentaire

Votre adresse e-mail ne sera pas publiée. Les champs obligatoires sont indiqués avec *

Matomo encountered an error: Uncaught Piwik\Exception\DatabaseSchemaIsNewerThanCodebaseException: Your Matomo codebase is running the old version 4.14.2 and we have detected that your Matomo Database has already been upgraded to the newer version 4.15.1. Maybe your Matomo administrators are currently finishing the upgrade process. Please try again in a few minutes. If you still have this issue please contact your Matomo administrator for assistance. in /var/www/piwik/core/FrontController.php:692 Stack trace: #0 /var/www/piwik/core/FrontController.php(387): Piwik\FrontController->throwIfPiwikVersionIsOlderThanDBSchema() #1 /var/www/thegtricks/wp-content/plugins/wp-piwik/classes/WP_Piwik/Request/Php.php(40): Piwik\FrontController->init() #2 /var/www/thegtricks/wp-content/plugins/wp-piwik/classes/WP_Piwik/Request/Php.php(18): WP_Piwik\Request\Php->call() #3 /var/www/thegtricks/wp-content/plugins/wp-piwik/classes/WP_Piwik/Request.php(63): WP_Piwik\Request\Php->request() #4 /var/www/thegtricks/wp-content/plugins/wp-piwik/classes/WP_Piwik.php(1038): WP_Piwik\Request->perform() #5 /var/www/thegtricks/wp-content/plugins/wp-piwik/classes/WP_Piwik.php(1205): WP_Piwik->request() #6 /var/www/thegtricks/wp-content/plugins/wp-piwik/classes/WP_Piwik/TrackingCode.php(16): WP_Piwik->updateTrackingCode() #7 /var/www/thegtricks/wp-content/plugins/wp-piwik/classes/WP_Piwik.php(296): WP_Piwik\TrackingCode->__construct() #8 /var/www/thegtricks/wp-includes/class-wp-hook.php(324): WP_Piwik->addJavascriptCode() #9 /var/www/thegtricks/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() #10 /var/www/thegtricks/wp-includes/plugin.php(517): WP_Hook->do_action() #11 /var/www/thegtricks/wp-includes/general-template.php(3068): do_action() #12 /var/www/thegtricks/wp-content/themes/twentyfifteen-child/footer.php(45): wp_footer() #13 /var/www/thegtricks/wp-includes/template.php(790): require_once('...') #14 /var/www/thegtricks/wp-includes/template.php(725): load_template() #15 /var/www/thegtricks/wp-includes/general-template.php(92): locate_template() #16 /var/www/thegtricks/wp-content/themes/twentyfifteen/single.php(53): get_footer() #17 /var/www/thegtricks/wp-includes/template-loader.php(106): include('...') #18 /var/www/thegtricks/wp-blog-header.php(19): require_once('...') #19 /var/www/thegtricks/index.php(17): require('...') #20 {main} thrown (which lead to: Session must be started before any output has been sent to the browser; output started in /var/www/thegtricks/wp-includes/script-loader.php/2925)