Различия

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

--- postgres:uuid [2021/11/10 15:38]
werwolf
+++ postgres:uuid [2023/01/12 12:18] (текущий)
@@ Строка 18: / Строка 18: @@
 If it is installed you should see it listed like it is below
-{{https://miro.medium.com/max/60/1*VtQNCDrIlyo7vYBCHj04_Q.png?q=20?700x209}}{{https://miro.medium.com/max/700/1*VtQNCDrIlyo7vYBCHj04_Q.png?700x209}}{{https://miro.medium.com/max/1400/1*VtQNCDrIlyo7vYBCHj04_Q.png?700x209}}If not present, install “uuid-ossp”
+{{https://miro.medium.com/max/700/1*VtQNCDrIlyo7vYBCHj04_Q.png?700x209}}\\
+{{https://miro.medium.com/max/1400/1*VtQNCDrIlyo7vYBCHj04_Q.png?700x209}} \\
+If not present, install “uuid-ossp”
 <code>
@@ Строка 67: / Строка 72: @@
 sudo -u postgres psql icx -c 'CREATE EXTENSION IF NOT EXISTS "uuid-ossp";'
 </code>
-==== I can’t connect to PostgreSQL¶ ====
-It is possible that PostgreSQL complains when you’re trying to connect. The solution is to modify the ''pg_hba.conf'' (in Debian, located in ''/etc/postgresql/X.X/main'') and add the following line at the end :
 <code>
-local   all     all     trust
+SELECT uuid_generate_v4()
 </code>