| #!/bin/bash | |
| # PostgreSQL database dump | |
| # troubleshooting for | |
| # pg_dump: server version: 9.6.2; pg_dump version: 9.5.6 | |
| # pg_dump: aborting because of server version mismatch | |
| # | |
| # commands to verify version mismatch on linux environment | |
| # psql --version | |
| # pg_dump --version |
| -- enable extensions | |
| -- full-text search on postgresql | |
| CREATE EXTENSION unaccent; | |
| -- languages supported | |
| CREATE TEXT SEARCH CONFIGURATION fr ( COPY = french ); | |
| ALTER TEXT SEARCH CONFIGURATION fr ALTER MAPPING | |
| FOR hword, hword_part, word WITH unaccent, french_stem; | |
| CREATE TEXT SEARCH CONFIGURATION en ( COPY = english ); |
| #!/bin/bash | |
| # Remove files are listed in gitignore | |
| git rm --cached `git ls-files -i --exclude-from=.gitignore` | |
| # git bash on windows | |
| # git ls-files -i -z --exclude-from=.gitignore | xargs -0 git rm --cached | |
| # in case of any problem with the statements above, its run in any OS | |
| git rm -r --cached . | |
| git add . |
| #!/bin/bash | |
| sudo rm -rf /var/lib/dpkg/info/*.* | |
| sudo apt-get autoremove | |
| sudo apt-get autoclean | |
| sudo apt-get update | |
| sudo apt-get check | |
| sudo apt-get -f install | |
| sudo apt-get upgrade |
| #!/bin/bash | |
| # Linux user management script | |
| # to list all user on linux environment (listed in /etc/passwd) | |
| getent passwd | |
| # to list all groups on linux environment (listed in /etc/group) | |
| getent group | |
| # to add a new user, with sudo this add sudoers privilegies |
| -- PostgreSQL 9.6 | |
| -- view connections | |
| select * from pg_stat_activity where datname = 'db_name'; | |
| -- drop connections | |
| select pg_terminate_backend(pid) from pg_stat_activity where datname = 'db_name'; |
| #!/bin/bash | |
| # Apache Tomcat 9.x instructions for installation on CentOS Linux 7 | |
| # Apache needs JDK 8 installed on environment (we prefer Oracle JVM HotSpot!) | |
| # find out instructions how to install :D | |
| # A | create tomcat user :: should be run as an unprivileged user | |
| # 1. create a new tomcat group | |
| sudo groupadd tomcat |
| # Systemd unit file for tomcat | |
| [Unit] | |
| Description=Apache Tomcat Web Application Container | |
| After=syslog.target network.target | |
| [Service] | |
| Type=forking | |
| Environment=JAVA_HOME=/usr/lib/jvm/jre | |
| Environment=CATALINA_PID=/opt/tomcat/temp/tomcat.pid |
| $ git remote show origin | |
| $ git remote rm origin | |
| $ git remote add origin git@newserver:project.git | |
| $ git remote show origin |
Collection of License badges for your Project's README file.
This list includes the most common open source and open data licenses.
Easily copy and paste the code under the badges into your Markdown files.
