This gist was created based on the following guide: upgrading to postgresql 11 on centos 7
Create a backup:
sudo -Hiu postgres pg_dumpall > mybackup.sqlInstall PostgreSQL 11:
Lasteris lasteris
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Visual Studio 2019 Product Key | |
| [Please Star this gist] | |
| Follow My Account --> https://github.com/ch-kashif @ch-kashif | |
| Lets do a code together | |
| Join Cloud Disk repository --> https://github.com/ch-kashif/CloudDisk | |
lasteris
/ upgrade-postgresql-service-centos-7.md
Created
March 5, 2021 19:28
— forked from ShvaykaD/upgrade-postgresql-service-centos-7.md
Upgrading PostgreSQL service from 9.x or 10.x to 11 version on CentOS 7
lasteris
/ psql_useful_stat_queries.sql
Created
June 19, 2021 10:13
— forked from anvk/psql_useful_stat_queries.sql
List of some useful Stat Queries for PSQL
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --- PSQL queries which also duplicated from https://github.com/anvk/AwesomePSQLList/blob/master/README.md | |
| --- some of them taken from https://www.slideshare.net/alexeylesovsky/deep-dive-into-postgresql-statistics-54594192 | |
| -- I'm not an expert in PSQL. Just a developer who is trying to accumulate useful stat queries which could potentially explain problems in your Postgres DB. | |
| ------------ | |
| -- Basics -- | |
| ------------ | |
| -- Get indexes of tables |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import com.github.jengelman.gradle.plugins.shadow.tasks.ShadowJar | |
| import org.gradle.api.tasks.testing.logging.TestLogEvent.* | |
| plugins { | |
| java | |
| application | |
| id("com.github.johnrengelman.shadow") version "7.1.2" | |
| } | |
| group = "io.lasteris.dev" |
lasteris
/ python3_centos7.md
Last active
January 2, 2024 15:49
Python 3 + OpenSSL setup on CentOs 7 (Rosa)
Для сборки и настройки необходима машина с доступом в интернет.
- Устанавливаем необходимые для сборки пакеты системы
yum -y groupinstall "Development Tools" yum -y install gcc openssl-devel bzip2-devel libffi-devel
- Ставим GCC актуальной версии и выставляем его по умолчанию в текущей сессии
lasteris
/ README.md
Created
August 14, 2025 08:26
— forked from ChangdongLi/README.md
To create a BIRT runtime Maven artifact, please download birt-runtime-4.13.0-20230309.zip, unzip it to /tmp folder, then run the command
./src/main/scripts/install_birt_in_maven_repo.sh
This script was tested in macOS. It should work in Linux as well. It will generate this runtime artifact under the com.friss.org.eclipse.birt group ID.
All the dependencies will be installed into the local Maven repository ~/.m2/repository/.
Once it's successfully, this runtime artifact can be referred by the code