PostgreSQL on Linux

The 1C:Enterprise developers forum

#1
People who like this:0Yes/0No
Active user
Rating: 8
Joined: May 21, 2023
Company:

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

Download pic17.png (55.03 KB)
 
#2
People who like this:0Yes/0No
Administrator
Rating: 23
Joined: Oct 3, 2019
Company:

Which Linux do you plan to use?

 
#3
People who like this:0Yes/0No
Active user
Rating: 8
Joined: May 21, 2023
Company:

Ubuntu 22

 
#4
People who like this:0Yes/0No
Administrator
Rating: 23
Joined: Oct 3, 2019
Company:

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

 
#5
People who like this:0Yes/0No
Active user
Rating: 8
Joined: May 21, 2023
Company:

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

 
#6
People who like this:0Yes/0No
Active user
Rating: 8
Joined: May 21, 2023
Company:

How to install patch provided with PostgreSQL installation package?

Download pic18.png (21.97 KB)
 
#7
People who like this:0Yes/0No
Administrator
Rating: 23
Joined: Oct 3, 2019
Company:

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.

 
#8
People who like this:0Yes/0No
Active user
Rating: 8
Joined: May 21, 2023
Company:

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.

 
#9
People who like this:0Yes/0No
Administrator
Rating: 23
Joined: Oct 3, 2019
Company:

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

They're already in this distribution.

 
#10
People who like this:0Yes/0No
Active user
Rating: 8
Joined: May 21, 2023
Company:

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\?

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.