Различия

Показаны различия между двумя версиями страницы.

--- it:debian:apt:postgresql [2019/12/23 12:03] – создано ura2404
+++ it:debian:apt:postgresql [2025/03/06 09:17] (текущий) – ura2404
@@ Строка 3: / Строка 3: @@
 https://wiki.postgresql.org/wiki/Apt\\
 https://www.tecmint.com/install-postgresql-on-debian-and-ubuntu/
+[[https://www.postgresql.org/download/linux/debian/]] - здесь САМ Postgres пишет как его установить
 **1. File /etc/apt/sources.list.d/pgdg.list**
->--------------- On Buster 10.x ---------------
+<code bash>
->deb http://apt.postgresql.org/pub/repos/apt/ buster-pgdg main
+sudo sh -c 'echo "deb https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
->--------------- On Stretch 9.x ---------------
->deb http://apt.postgresql.org/pub/repos/apt/ stretch-pgdg main
->--------------- On Jessie 8.x ---------------
->deb http://apt.postgresql.org/pub/repos/apt/ jessie-pgdg main
->--------------- On Wheezy 7.x ---------------
->deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main
+#--------------- On Buster 10.x ---------------
+#deb http://apt.postgresql.org/pub/repos/apt/ buster-pgdg main
+#--------------- On Stretch 9.x ---------------
+#deb http://apt.postgresql.org/pub/repos/apt/ stretch-pgdg main
+#--------------- On Jessie 8.x ---------------
+#deb http://apt.postgresql.org/pub/repos/apt/ jessie-pgdg main
+#--------------- On Wheezy 7.x ---------------
+#deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main
+</code>
 **2. Import the repository key from https://www.postgresql.org/media/keys/ACCC4CF8.asc**
+<code>
-> # sudo apt-get install curl ca-certificates gnupg
+# sudo apt-get install curl ca-certificates gnupg
-> # curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
+# curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
-> # sudo apt update
+# sudo apt update
+</code>
 или
-> # sudo apt-get install wget ca-certificates gnupg
+<code>
-> # wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
+# sudo apt-get install wget ca-certificates gnupg
-> # sudo apt update
+# wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
->
+# sudo apt update
+</code>
 **3. **
+<code>
+# apt install postgresql-9.5
+# apt install postgresql-9.6
+# apt install postgresql-10
+# apt install postgresql-11
+# apt install postgresql-12
+</code>
+----
+Для Debian 10 (buster)
+<code bash>
+sudo sh -c 'echo "deb https://apt.postgresql.org/pub/repos/apt bullseye-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
+</code>
-> # apt install postgresql-9.5
-> # apt install postgresql-9.6
-> # apt install postgresql-10
-> # apt install postgresql-11
-> # apt install postgresql-12