Differences

This shows you the differences between two versions of the page.

--- onny:notizen:programmierung [2022/02/20 11:33] – [postgresql] 80.187.99.121
+++ onny:notizen:programmierung [2022/03/19 14:37] – old revision restored (2022/03/07 12:58) 2001:41d0:1004:60b::
@@ Line 259: / Line 259: @@
 <code javascript>
 var string = string.substring(0,100);
+</code>
+vanilla js onclick class element
+<code javascript>
+document.getElementsByClassName('navbar-burger')[0].onclick = function(){
+  console.log('ready');
+};
 </code>
 ==== vuejs ====
@@ Line 690: / Line 697: @@
 <code>
 pg_dump -U gitlab gitlabhq_production > /tmp/gitlab.pgsql
+</code>
+dump all
+<code>
+pg_dumpall > /tmp/dump_file_name.tar
 </code>
 import database
 <code>
+psql# CREATE DATABASE gitlabhq_production;
 psql -U gitlab gitlabhq_production < gitlab.pgsql
 </code>
-create database
+create and delete user
+<code>
+DROP ROLE gitlab;
+CREATE USER gitlab WITH PASSWORD '5V0hD0KWX81g5dhKGHsbqU4a';
+</code>
+grant permissions
 <code>
-psql# CREATE DATABASE gitlabhq_production
+ALTER USER gitlab SUPERUSER;
+CREATE DATABASE gitlabhq_production OWNER gitlab;
+ALTER DATABASE gitlabhq_production OWNER TO gitlab;
 </code>

Project-Insanity