<p>A compatibility issue with <em>Craft 3.4.1</em> and maybe earlier. Running <em>PostgreSQL12+</em> (PgSQL12+) couldn't finish Craft's installation setup.</p>
<p>I have no idea what <a href="https://www.postgresql.org/docs/12/release-12.html" rel="nofollow noreferrer">change in PgSQL12+</a> could cause this behavior but downgrading <em>PgSQL12</em> to lower versions like <em>PostgreSQL11</em> worked as expected.</p>
<p>However <a href="https://docs.craftcms.com/v3/requirements.html" rel="nofollow noreferrer">Craft's docs</a> states that <em>PostgreSQL 9.5+</em> should meet Craft’s server requirements.</p>
<p>I can't take this for answer to my question because if this is an incompatibility issue than downgrading doesn't answer my question. I believe you guys get to it and crack it as always.</p>
<p>Anyway here are the logs when tried to run Craft with <em>PgSQL12+</em>.</p>
<ul>
<li><a href="https://drive.google.com/file/d/1HPcu4zHkVZ4_FXRJdC_O8ieq1MeIF3xh/view" rel="nofollow noreferrer">phperrors.log</a></li>
<li><a href="https://drive.google.com/open?id=1j9SXk-UHKZ4QF1UrjlFCfExc9CveAgAB" rel="nofollow noreferrer">web.log</a></li>
</ul>
<hr />
<h2>Update</h2>
<p>Running <em>Craft 3.4.6</em> along with <em>PostgreSQL 12.2</em> seems to remove the problem. I checked the <a href="https://github.com/craftcms/cms/blob/develop/CHANGELOG-v3.md" rel="nofollow noreferrer">CHANGELOG-v3</a> and I couldn't find anything related to <em>PgSQL</em> database.</p>
<hr />
<h2>Update</h2>
<p>I decided to upgrade all underlying software that Craft depends on with higher security precautions in mind.</p>
<p>Recently I got into troubles when I couldn't finish installation on my setup -&gt; NGINX, PHP-FPM, PostgreSQL and Redis.
No matter what version I tried (now latest) I always got<br />
<code>ERROR:  relation &quot;info&quot; does not exist ...</code>.<br />
I even tried MySQL database. No luck.</p>
<p><strong>I found the issue</strong> in my NGINX's nginx.conf file.
The directives <code>client_header_buffer_size</code> and <code>large_client_header_buffers</code>. I went with lowest sizes possible to avoid avoidable. And that was my problem why I couldn't finish my Craft's installation. Craft (v3.x+) writes longer cookies with <code>POST</code> request and it couldn't fit into buffer size set in nginx.conf file</p>
<p>My setup was:</p>
<pre><code>client_header_buffer_size 1k;
large_client_header_buffers 1 2k;
</code></pre>
<p>now</p>
<pre><code>client_header_buffer_size 2k;
large_client_header_buffers 4 8k;
</code></pre>
<p>with security in mind. Tweak it according to your project's needs.</p>
<p>And the reason why I couldn't find out right away was that I run my local website with locally SSL installed and for some reason <code>“Request Entity Too Large” (413)</code> wasn't showing up in my console. Good thing was that from my last effort I switched SSL off and the error showed up. From there it was easy to fix that.</p>

CC BY-SA 4.0
2019-11-20T09:04:58.647Z
2022-01-18T11:15:20.157Z
2022-01-18T11:15:20.157Z
Dominik Krulak
<p><em>Be warned this is sort of Docker related question too.</em></p>

<p>I try to build local development environment using Docker (nginx <em>1.16.1</em> + postgresql <em>12.1.0</em>) running <em>Craft 3.4.1</em>.
I've came up to a point where I run the setup wizard over browser. During the steps <em>(connection to database is skipped)</em> I fill the required fields and proceed to final "Next" button where the installation step begins.</p>

<blockquote>
  <p>Install failed  Please check your logs for more info.</p>
</blockquote>

<p><strong>PHPerrors log shows:</strong> </p>

<p><code>An Error occurred while handling another error:
PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "queue" does not exist ...</code></p>

<p><strong>Web log shows:</strong> </p>

<p>There is a lot of it but it's about <code>info</code> table and to summarise to one general sentence I've picked this line</p>

<p><code>ERROR:  relation "info" does not exist ...</code></p>

<p><strong>What I'm able to:</strong></p>

<ul>
<li>I'm able to connect to database over <code>docker</code> CLI and PGadmin</li>
<li>I'm able to create database over <code>docker</code> CLI and PGadmin</li>
</ul>

<p><strong>What I'm not able to:</strong></p>

<ul>
<li>I'm not able to successfully run <code>./craft setup</code> which reports back this failure <code>SQLSTATE[08006] [7] could not translate host name "postgresql" to address: Name or service not known</code></li>
</ul>

<p>Every image lives in it's own container and are connected over external network. If more info required I'd be happy to provide.</p>

<p>Is there anyone Who have experienced similar issue?</p>

<craft3><install><docker>
ERROR: relation "info" does not exist
# ERROR: relation "info" does not exist

(Asked by: username_0 on 2019-11-19)

*Be warned this is sort of Docker related question too.*

I try to build local development environment using Docker (nginx *1.16.1* + postgresql *12.1.0*) running *Craft 3.4.1*.
I've came up to a point where I run the setup wizard over browser. During the steps *(connection to database is skipped)* I fill the required fields and proceed to final "Next" button where the installation step begins.

> Install failed Please check your logs for more info.

**PHPerrors log shows:**

`An Error occurred while handling another error:
PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "queue" does not exist ...`

**Web log shows:**

There is a lot of it but it's about `info` table and to summarise to one general sentence I've picked this line

`ERROR: relation "info" does not exist ...`

**What I'm able to:**

* I'm able to connect to database over `docker` CLI and PGadmin
* I'm able to create database over `docker` CLI and PGadmin

**What I'm not able to:**

* I'm not able to successfully run `./craft setup` which reports back this failure `SQLSTATE[08006] [7] could not translate host name "postgresql" to address: Name or service not known`

Every image lives in it's own container and are connected over external network. If more info required I'd be happy to provide.

Is there anyone Who have experienced similar issue?

**Tags:** craft3, install, docker

---

## 1 answers

### Answer by username_0 on 2019-11-20. Score: 1 | Accepted answer

A compatibility issue with Craft 3.4.1 and maybe earlier. Running PostgreSQL12+ (PgSQL12+) couldn't finish Craft's installation setup.
I have no idea what change in PgSQL12+ could cause this behavior but downgrading PgSQL12 to lower versions like PostgreSQL11 worked as expected.
However Craft's docs states that PostgreSQL 9.5+ should meet Craft’s server requirements.
I can't take this for answer to my question because if this is an incompatibility issue than downgrading doesn't answer my question. I believe you guys get to it and crack it as always.
Anyway here are the logs when tried to run Craft with PgSQL12+.

phperrors.log
web.log


Update
Running Craft 3.4.6 along with PostgreSQL 12.2 seems to remove the problem. I checked the CHANGELOG-v3 and I couldn't find anything related to PgSQL database.

Update
I decided to upgrade all underlying software that Craft depends on with higher security precautions in mind.
Recently I got into troubles when I couldn't finish installation on my setup -> NGINX, PHP-FPM, PostgreSQL and Redis.
No matter what version I tried (now latest) I always got
ERROR:  relation "info" does not exist ....
I even tried MySQL database. No luck.
I found the issue in my NGINX's nginx.conf file.
The directives client_header_buffer_size and large_client_header_buffers. I went with lowest sizes possible to avoid avoidable. And that was my problem why I couldn't finish my Craft's installation. Craft (v3.x+) writes longer cookies with POST request and it couldn't fit into buffer size set in nginx.conf file
My setup was:
client_header_buffer_size 1k;
large_client_header_buffers 1 2k;

now
client_header_buffer_size 2k;
large_client_header_buffers 4 8k;

with security in mind. Tweak it according to your project's needs.
And the reason why I couldn't find out right away was that I run my local website with locally SSL installed and for some reason “Request Entity Too Large” (413) wasn't showing up in my console. Good thing was that from my last effort I switched SSL off and the error showed up. From there it was easy to fix that.


---

