Answers.Body: <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>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-11-20T09:04:58.647Z
Answers.LastActivityDate: 2022-01-18T11:15:20.157Z
Answers.LastEditDate: 2022-01-18T11:15:20.157Z
Answers.UserDisplayName: Dominik Krulak
Body: <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>
  
Tags: <craft3><install><docker>
Title: ERROR: relation "info" does not exist
ThreadText: # 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+](https://www.postgresql.org/docs/12/release-12.html) could cause this behavior but downgrading *PgSQL12* to lower versions like *PostgreSQL11* worked as expected.
  
  However [Craft's docs](https://docs.craftcms.com/v3/requirements.html) 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](https://drive.google.com/file/d/1HPcu4zHkVZ4_FXRJdC_O8ieq1MeIF3xh/view)
  * [web.log](https://drive.google.com/open?id=1j9SXk-UHKZ4QF1UrjlFCfExc9CveAgAB)
  
  ---
  
  ## Update
  
  Running *Craft 3.4.6* along with *PostgreSQL 12.2* seems to remove the problem. I checked the [CHANGELOG-v3](https://github.com/craftcms/cms/blob/develop/CHANGELOG-v3.md) 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.
  
  
  ---
  
  