Desktop version

Main > Forum > 1C:Enterprise Platform > 1C:Enterprise – Business applications platform > PostgreSQL on Linux

Forum

Search UsersRules
PostgreSQL on Linux
#1
Active user
Points:: 0
Joined:: May 21, 2023

Which of these installation files I need to install PostgreSQL on Linux:

Profile
#2
Administrator
Points:: 0
Joined:: Oct 3, 2019

Which Linux do you plan to use?

Profile
#3
Active user
Points:: 0
Joined:: May 21, 2023

Ubuntu 22

Profile
#4
Administrator
Points:: 0
Joined:: Oct 3, 2019

Unfortunately, 1C does not support the current PostgreSQL repository, so the best option is to use a special build for 1C from the creators of PostgreSQL.

Run the following commands:

1. Download the script to add a third-party repository from the PostgreSQL developers:

Code
$ curl -o pgpro-repo-add.sh https://repo.postgrespro.ru/1c-15/keys/pgpro-repo-add.sh


2. Let's execute the script:

Code
# sh pgpro-repo-add.sh


3. Install PostgreSQL (this build is based on open PostgreSQL with patches from 1C)

Code
# apt install -y postgrespro-1c-15


4. Let's start the server

Code
# systemctl start postgrespro-1c-15


5. Check the status of the service:

Code
$ systemctl status postgrespro-1c-15

Profile
#5
Active user
Points:: 0
Joined:: May 21, 2023

If you publish to web-server 1C web app connected to empty PostgreSQL database, what the browser window should look like?

Profile
#6
Active user
Points:: 0
Joined:: May 21, 2023

How to install patch provided with PostgreSQL installation package?

Profile
#7
Administrator
Points:: 0
Joined:: Oct 3, 2019

Quote
If you publish to web-server 1C web app connected to empty PostgreSQL database, what the browser window should look like?

Sorry, but I didn't understand your question... :(

Let's do this: do you want to use 1C together with PostgreSQL on Linux? Right?

I can prepare educational material on this topic, because I am just preparing a plan for such materials for the new year.

Profile
#8
Active user
Points:: 0
Joined:: May 21, 2023

I already installed PostgreSQL from installation package provided by 1Ci. 1C Server connected to it and works fine (locally). But there is also a patch in that installation package content of which I posted here and I don't understand how to install that patch.

Profile
#9
Administrator
Points:: 0
Joined:: Oct 3, 2019

If you have already installed PostgreSQL, obtained from 1Ci, then you don't need to install additional patches.

They're already in this distribution.

Profile
#10
Active user
Points:: 0
Joined:: May 21, 2023

This patch is from installation package provided by 1Ci. Do I need just to copy the content of this folder to C:\Program Files\PostgreSQL\15.2-1.1C\?

Profile
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.