coder4web · November 4, 2022 22:16 · Jun 2, 2022 · Jun 2, 2022 · Mar 17, 2020 · Feb 5, 2020
diff --git a/postgresql_install.sql → postgresql_install.sh b/postgresql_install.sql → postgresql_install.sh
@@ -1,5 +1,8 @@
+:'SET PASSWORD
 sudo -i -u postgres
+psql
 \password postgres
+'
 
 # RHEL / CentOS 8
 # https://www.postgresql.org/download/linux/redhat/

diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -1,3 +1,6 @@
+sudo -i -u postgres
+\password postgres
+
 # RHEL / CentOS 8
 # https://www.postgresql.org/download/linux/redhat/
 # https://www.postgresql.org/docs/current/runtime.html

diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -1,6 +1,7 @@
 # RHEL / CentOS 8
 # https://www.postgresql.org/download/linux/redhat/
 # https://www.postgresql.org/docs/current/runtime.html
+dnf list installed |grep postgresql
 dnf install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
 dnf install postgresql12 postgresql12-server
 

diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -27,6 +27,20 @@ sed -i 's/^host\s*all\s*all\s*127\.0\.0\.1\/32\s*ident/host    all             a
 #sed -i "s~^Environment=PGDATA=.*~Environment=PGDATA=\${PGDATA}/~" /usr/lib/systemd/system/postgresql-12.service
 #systemctl daemon-reload
 
+# -------------------------------
+# Debian 10
+# https://www.postgresql.org/download/linux/debian/
+# https://computingforgeeks.com/install-postgresql-12-on-debian/
+# -------------------------------
+sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ buster-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'
+wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
+sudo apt-get update
+sudo apt -y install postgresql-12 postgresql-client-12
+
+sudo systemctl status postgresql
+sudo systemctl enable postgresql
+sudo systemctl stop postgresql
+
 # -------------------------------
 # Ubuntu 18.04 LTS
 # https://www.postgresql.org/download/linux/ubuntu/

diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -37,9 +37,10 @@ deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
 apt-cache policy postgresql-12
 
 # ru_RU.UTF-8:
-# su - postgres -c "/usr/lib/postgresql/12/bin/initdb --pgdata=/var/lib/postgresql/12/main --locale=ru_RU.UTF-8"
 echo 'LC_COLLATE="ru_RU.UTF-8"' >> /etc/locale.conf
 # reboot!
+# Plan B:
+# su - postgres -c "/usr/lib/postgresql/12/bin/initdb --pgdata=/var/lib/postgresql/12/main --locale=ru_RU.UTF-8"
 
 apt install postgresql-12 postgresql-contrib
 sudo systemctl status postgresql.service

diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -34,6 +34,8 @@ sed -i 's/^host\s*all\s*all\s*127\.0\.0\.1\/32\s*ident/host    all             a
 # nano /etc/apt/sources.list.d/pgdg.list
 deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
 
+apt-cache policy postgresql-12
+
 # ru_RU.UTF-8:
 # su - postgres -c "/usr/lib/postgresql/12/bin/initdb --pgdata=/var/lib/postgresql/12/main --locale=ru_RU.UTF-8"
 echo 'LC_COLLATE="ru_RU.UTF-8"' >> /etc/locale.conf

diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -34,11 +34,12 @@ sed -i 's/^host\s*all\s*all\s*127\.0\.0\.1\/32\s*ident/host    all             a
 # nano /etc/apt/sources.list.d/pgdg.list
 deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
 
-#export LC_COLLATE="ru_RU.UTF-8"
+# ru_RU.UTF-8:
+# su - postgres -c "/usr/lib/postgresql/12/bin/initdb --pgdata=/var/lib/postgresql/12/main --locale=ru_RU.UTF-8"
 echo 'LC_COLLATE="ru_RU.UTF-8"' >> /etc/locale.conf
+# reboot!
 
 apt install postgresql-12 postgresql-contrib
-# su - postgres -c "/usr/lib/postgresql/12/bin/initdb --pgdata=/var/lib/postgresql/12/main --locale=ru_RU.UTF-8"
 sudo systemctl status postgresql.service
 sudo systemctl start postgresql.service
 sudo -i -u postgres

diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -34,8 +34,8 @@ sed -i 's/^host\s*all\s*all\s*127\.0\.0\.1\/32\s*ident/host    all             a
 # nano /etc/apt/sources.list.d/pgdg.list
 deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
 
-#echo 'LC_COLLATE="ru_RU.UTF-8"' >> /etc/locale.conf
-export LC_COLLATE="ru_RU.UTF-8"
+#export LC_COLLATE="ru_RU.UTF-8"
+echo 'LC_COLLATE="ru_RU.UTF-8"' >> /etc/locale.conf
 
 apt install postgresql-12 postgresql-contrib
 # su - postgres -c "/usr/lib/postgresql/12/bin/initdb --pgdata=/var/lib/postgresql/12/main --locale=ru_RU.UTF-8"

diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -34,7 +34,8 @@ sed -i 's/^host\s*all\s*all\s*127\.0\.0\.1\/32\s*ident/host    all             a
 # nano /etc/apt/sources.list.d/pgdg.list
 deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
 
-echo 'LC_COLLATE="ru_RU.UTF-8"' >> /etc/locale.conf
+#echo 'LC_COLLATE="ru_RU.UTF-8"' >> /etc/locale.conf
+export LC_COLLATE="ru_RU.UTF-8"
 
 apt install postgresql-12 postgresql-contrib
 # su - postgres -c "/usr/lib/postgresql/12/bin/initdb --pgdata=/var/lib/postgresql/12/main --locale=ru_RU.UTF-8"

diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -12,7 +12,7 @@ dnf install postgresql12 postgresql12-server
 #yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
 #yum install postgresql12 postgresql12-server
 
-echo 'LC_ALL="en_US.UTF-8"' >> /etc/locale.conf
+echo 'LC_ALL="ru_RU.UTF-8"' >> /etc/locale.conf
 
 #PGDATA='/srv/data/12/data'
 #PGSETUP_INITDB_OPTIONS="-D ${PGDATA}"
@@ -33,6 +33,9 @@ sed -i 's/^host\s*all\s*all\s*127\.0\.0\.1\/32\s*ident/host    all             a
 # -------------------------------
 # nano /etc/apt/sources.list.d/pgdg.list
 deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
+
+echo 'LC_COLLATE="ru_RU.UTF-8"' >> /etc/locale.conf
+
 apt install postgresql-12 postgresql-contrib
 # su - postgres -c "/usr/lib/postgresql/12/bin/initdb --pgdata=/var/lib/postgresql/12/main --locale=ru_RU.UTF-8"
 sudo systemctl status postgresql.service

diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -34,6 +34,7 @@ sed -i 's/^host\s*all\s*all\s*127\.0\.0\.1\/32\s*ident/host    all             a
 # nano /etc/apt/sources.list.d/pgdg.list
 deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
 apt install postgresql-12 postgresql-contrib
+# su - postgres -c "/usr/lib/postgresql/12/bin/initdb --pgdata=/var/lib/postgresql/12/main --locale=ru_RU.UTF-8"
 sudo systemctl status postgresql.service
 sudo systemctl start postgresql.service
 sudo -i -u postgres

diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -34,6 +34,8 @@ sed -i 's/^host\s*all\s*all\s*127\.0\.0\.1\/32\s*ident/host    all             a
 # nano /etc/apt/sources.list.d/pgdg.list
 deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
 apt install postgresql-12 postgresql-contrib
+sudo systemctl status postgresql.service
+sudo systemctl start postgresql.service
 sudo -i -u postgres
 psql --version
 psql -l

diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -34,3 +34,8 @@ sed -i 's/^host\s*all\s*all\s*127\.0\.0\.1\/32\s*ident/host    all             a
 # nano /etc/apt/sources.list.d/pgdg.list
 deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
 apt install postgresql-12 postgresql-contrib
+sudo -i -u postgres
+psql --version
+psql -l
+psql
+\password postgres
diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -33,4 +33,4 @@ sed -i 's/^host\s*all\s*all\s*127\.0\.0\.1\/32\s*ident/host    all             a
 # -------------------------------
 # nano /etc/apt/sources.list.d/pgdg.list
 deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
-apt install postgresql12
+apt install postgresql-12 postgresql-contrib
diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -25,4 +25,12 @@ sed -i 's/^host\s*all\s*all\s*127\.0\.0\.1\/32\s*ident/host    all             a
 
 #msg "Set PGDATA to "${PGDATA}
 #sed -i "s~^Environment=PGDATA=.*~Environment=PGDATA=\${PGDATA}/~" /usr/lib/systemd/system/postgresql-12.service
-#systemctl daemon-reload
+#systemctl daemon-reload
+
+# -------------------------------
+# Ubuntu 18.04 LTS
+# https://www.postgresql.org/download/linux/ubuntu/
+# -------------------------------
+# nano /etc/apt/sources.list.d/pgdg.list
+deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
+apt install postgresql12
diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -1,10 +1,13 @@
 # RHEL / CentOS 8
 # https://www.postgresql.org/download/linux/redhat/
 # https://www.postgresql.org/docs/current/runtime.html
-
 dnf install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
 dnf install postgresql12 postgresql12-server
 
+# Fedora 31
+dnf install https://download.postgresql.org/pub/repos/yum/reporpms/F-31-x86_64/pgdg-fedora-repo-latest.noarch.rpm
+dnf install postgresql12 postgresql12-server
+
 # RHEL / CentOS 7
 #yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
 #yum install postgresql12 postgresql12-server

diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -1,9 +1,13 @@
-# RedHat-based
+# RHEL / CentOS 8
 # https://www.postgresql.org/download/linux/redhat/
 # https://www.postgresql.org/docs/current/runtime.html
 
-yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
-yum install postgresql12 postgresql12-server
+dnf install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
+dnf install postgresql12 postgresql12-server
+
+# RHEL / CentOS 7
+#yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
+#yum install postgresql12 postgresql12-server
 
 echo 'LC_ALL="en_US.UTF-8"' >> /etc/locale.conf
 

diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -1,13 +1,21 @@
 # RedHat-based
 # https://www.postgresql.org/download/linux/redhat/
+# https://www.postgresql.org/docs/current/runtime.html
 
 yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
 yum install postgresql12 postgresql12-server
 
 echo 'LC_ALL="en_US.UTF-8"' >> /etc/locale.conf
+
+#PGDATA='/srv/data/12/data'
+#PGSETUP_INITDB_OPTIONS="-D ${PGDATA}"
 /usr/pgsql-12/bin/postgresql-12-setup initdb
 
 systemctl enable postgresql-12
 systemctl start postgresql-12
 
 sed -i 's/^host\s*all\s*all\s*127\.0\.0\.1\/32\s*ident/host    all             all             127.0.0.1\/32            md5/' /var/lib/pgsql/12/data/pg_hba.conf
+
+#msg "Set PGDATA to "${PGDATA}
+#sed -i "s~^Environment=PGDATA=.*~Environment=PGDATA=\${PGDATA}/~" /usr/lib/systemd/system/postgresql-12.service
+#systemctl daemon-reload
diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -4,7 +4,9 @@
 yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
 yum install postgresql12 postgresql12-server
 
+echo 'LC_ALL="en_US.UTF-8"' >> /etc/locale.conf
 /usr/pgsql-12/bin/postgresql-12-setup initdb
+
 systemctl enable postgresql-12
 systemctl start postgresql-12
 

diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -7,3 +7,5 @@ yum install postgresql12 postgresql12-server
 /usr/pgsql-12/bin/postgresql-12-setup initdb
 systemctl enable postgresql-12
 systemctl start postgresql-12
+
+sed -i 's/^host\s*all\s*all\s*127\.0\.0\.1\/32\s*ident/host    all             all             127.0.0.1\/32            md5/' /var/lib/pgsql/12/data/pg_hba.conf
diff --git a/postgresql_install.sql b/postgresql_install.sql
@@ -0,0 +1,9 @@
+# RedHat-based
+# https://www.postgresql.org/download/linux/redhat/
+
+yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
+yum install postgresql12 postgresql12-server
+
+/usr/pgsql-12/bin/postgresql-12-setup initdb
+systemctl enable postgresql-12
+systemctl start postgresql-12