Skip to Content
This question has been flagged
2 Replies
5373 Views
Avatar
Bevan Agard

Hello All


I am trying to do an install of Odoo 15 (nightly build) on Centos 7.  After much effort i got it to install with no errors.  However when I try to launch for the first time where it would create the database and set things up it gives me the following error:


Database creation error: unrecognized configuration parameter "lock_timeout" 


I have looked for why this is happening and I cannot determine why. Any ideas would be appreciated.

Avatar
Discard
Avatar
stephen
Best Answer

Solved this in Centos 7 by upgrading postgres from version 9.2 to version 13

Avatar
Discard
Avatar
mrajuarez
Best Answer

I have exactly the same problem. I get an error that says "Database creation error: unrecognized configuration parameter "lock_timeout"" when creating the first database in my recent installation of Odoo 15 on CentOS 7. I already checked the internet for someone who has this same error and I was only able to find out that the "lock_timeout" parameter corresponds to a client configuration that connects to a PostgreSQL server. Client which in this case is an Odoo 15 server. However, I have not been able to find how to include this parameter in my recent installation of Odoo 15 on CentOS. If I find the solution to this error, I will return to this post to indicate the solution. Although I wanted to collaborate with my findings.

Avatar
Discard
mrajuarez

I have exactly the same problem. I get an error that says "Database creation error: unrecognized configuration parameter "lock_timeout"" when creating the first database in my recent installation of Odoo 15 on CentOS 7. I already checked the internet for someone who has this same error and I was only able to find out that the "lock_timeout" parameter corresponds to a client configuration that connects to a PostgreSQL server. Client which in this case is an Odoo 15 server.

I found that the lock_timeout parameter was not included in PostgreSQL versions 9.2. Since I had this version I removed my full installation of PostgreSQL 9.2 and Odoo 15 and replaced it with PostgreSQL 10 with Odoo 15 and everything worked fine.

Here are the commands I use:

yum remove -y postgresql-server postgresql-contrib postgresql-libs
rm -Rf /var/lib/pgsql
rm -Rf /usr/share/pgsql
sudo yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm -y
sudo yum install -y postgresql10 postgresql10-server postgresql10-contrib postgresql10-libs
sudo cp /root/Documents/Software/postgresql.conf /var/lib/pgsql/10/data/postgresql.conf
sudo cp /root/Documents/Software/pg_hba.conf /var/lib/pgsql/10/data/pg_hba.conf
sudo chown postgres:postgres /var/lib/pgsql/10/data/postgresql.conf
sudo chown postgres:postgres /var/lib/pgsql/10/data/pg_hba.conf
sudo systemctl stop postgresql-10
sudo systemctl enable postgresql-10
sudo systemctl start postgresql-10
su - postgres
createuser -s odoo
exit
passwd postgres
su - postgres
psql postgres postgres
ALTER USER postgres WITH PASSWORD '*@ehJo06FCCSgiQ6';
\password postgres
ALTER USER odoo WITH PASSWORD '*@ehJo06FCCSgiQ6';
\password odoo
\q
exit