- Astra Linux Special Edition 1.5 ⬝ Установка и настройка 1С
- Установка клиента 1C
- Возможные ошибки
- How to Start, Stop, and Restart PostgreSQL in Linux
- How to Start PostgreSQL Service/Server
- How to Stop PostgreSQL Service/Server
- How to Restart PostgreSQL Service/Server
- Starting/Stopping Individual Clusters
- How to Start the PostgreSQL Service/Server Automatically on Boot
- Leave a Comment Cancel reply
- SHARE:
- RELATED GUIDES
- RECENT ARTICLES
- Privacy Overview
- TablePlus
Astra Linux Special Edition 1.5 ⬝ Установка и настройка 1С
В файле /etc/hosts не должно быть записей формата localhost.localdomian или относящихся к IPv6 , в случае отсутствия DNS-сервера, в нем должно быть прописано четкое соответствие IP-адрес сервера – FQDN – короткое имя.
127.0.0.1 localhost 10.0.2.200 astra15-1c.example.ru astra15-1c
Устанавливаем необходимые пакеты для работы 1C:
Также , необходимо поставить libwebkitgtk-1.0 c диска со средствами разработки, либо скачать по ссылке и установить:
tar -xvf libwebkitgtk-1.0.tar.gz -C /tmp/libwebkit
usermod -a -G shadow postgres
setfacl -d -m u:postgres:r /etc/parsec/macdb
setfacl -R -m u:postgres:r /etc/parsec/macdb
setfacl -m u:postgres:rx /etc/parsec/macdb
setfacl -d -m u:postgres:r /etc/parsec/capdb
setfacl -R -m u:postgres:r /etc/parsec/capdb
setfacl -m u:postgres:rx /etc/parsec/capdb
Разрешаем подключения по сети, для этого меняем значения в файлах:
# - Connection Settings - listen_addresses = '*' # what IP address(es) to listen on
# IPv4 local connections: host all all 0.0.0.0/0 md5
Для корректной работы 1C с СУБД PostgreSQL также раскоментируем и меняем значения:
backslash_quote = safe_encoding escape_string_warning = off standart_conforming_strings = off
Создаем пароль для роли postgres:
psql -c «ALTER ROLE postgres WITH PASSWORD ‘12345678’;»
Перезапускаем СУБД PostgreSQL:
Для создания сервера 1C Предприятия понадобится 4 пакета:
1c-enterprise83-client_*.deb
1c-enterprise83-common*_amd64.deb
1c-enterprise83-server*_amd64.deb
1c-enterprise83-ws*_amd64.deb
Скачать их можно с сайта 1C.
Скачиваем в любую директорию, например 1csrv, переходим в нее и устанавливаем:
При возникновении ошибок об отсутствии пакетов, установим их командой:
Для работы аппаратного ключа hasp необходим драйвер haspd:
Вместо 10.0.2.0/24 нужно указать свою подсеть или хосты, которые должны видеть HASP ключ
Даем права на директорию 1C:
- Через «Администрирование серверов 1C Предприятия» для windows
- Через консольную утилиту администрирования rac.
Запустить в режиме демона сервис управления кластером:
Получить справку по командам администрирования:
Посмотреть список доступных кластеров:
Для подключения клиентов через веб, потребуется установленный и настроенный сервер Apache2
Для публикации базы 1C, нужно выполнить команду:
sudo /opt/1C/v8.3/x86_64/webinst -apache22 -wsdir pgbase -dir ‘/var/www/pgbase’ -connStr ‘Srvr=»astra15-1c»;Ref=”infobase»;’ -confPath /etc/apache2/apache2.conf
-wsdir – имя алиаса веб-сервера для соединения с базой;
-dir – директория где будут располагаться файлы web-интерфейса 1c;
-connStr – строка соединения с базой 1c предприятия(astr15-1c — имя сервера 1c, infobase — имя базы)
-confPath – расположение конфигурационного файла web-сервера apache.
Установка клиента 1C
Для подключения можно использовать нативный клиент 1C, как для windows, так и для Linux
Запустить клиента из меню:
Добавить информационную базу. Выбрать: На сервере 1C:Предприятие. Указать адрес сервера и имя базы.
Возможные ошибки
Проблема:
В некоторых случаях при подключении клиента для Linux к файловой информационной базе происходит ошибка
Ошибка загрузки библиотеки libWand.so по причине:dlopen: невозможно продолжать загрузку объекта со статичным TLS
How to Start, Stop, and Restart PostgreSQL in Linux
This short tutorial will show you how to start, stop, and restart PostgreSQL servers on your Linux system.
PostgreSQL is a flexible database system that allows you to run multiple versions of the server software on the same host. This can get a bit confusing, but thankfully PostgreSQL includes all of the tools you need to make sense of things and control each server individually.
How to Start PostgreSQL Service/Server
To start the default or primary PostgreSQL server on your system, simply run the following command:
systemctl start postgresql
The above command should work on all major Linux distributions.
How to Stop PostgreSQL Service/Server
To stop the default or primary PostgreSQL server on your system, simply run the following command:
sudo systemctl stop postgresql
The above command should work on all major Linux distributions.
How to Restart PostgreSQL Service/Server
To restart the default or primary PostgreSQL server on your system, simply run the following command:
sudo systemctl restart postgresql
The above command should work on all major Linux distributions.
Starting/Stopping Individual Clusters
If you have several running PostgreSQL clusters on your system (for example, two versions as the result of an upgrade), you may want to control the state of each cluster individually.
First, list the installed clusters by running the pg_lsclusters command:
The output should look something like this:
Ver Cluster Port Status Owner Data directory Log file 9.1 main 5433 online postgres /var/lib/postgresql/9.1/main /var/log/postgresql/postgresql-9.1-main.log 11 main 5432 online postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log
The state of each cluster can then be controlled using the below commands:
sudo pg_ctlcluster VERSIONNUMBER stop sudo pg_ctlcluster VERSIONNUMBER start
How to Start the PostgreSQL Service/Server Automatically on Boot
You can also enable or disable the automatic starting of the PostgreSQL server when your computer boots by running one of the following commands:
systemctl enable postgresql systemctl disable postgresql
If you’re new to PostgreSQL, check out our ever-evolving guide for developers here.
I’m Brad, and I’m nearing 20 years of experience with Linux. I’ve worked in just about every IT role there is before taking the leap into software development. Currently, I’m building desktop and web-based solutions with NodeJS and PHP hosted on Linux infrastructure. Visit my blog or find me on Twitter to see what I’m up to.
Leave a Comment Cancel reply
SHARE:
RELATED GUIDES
RECENT ARTICLES
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
TablePlus
In this post, we are going to figure out how to start, stop, and restart a PostgreSQL server on macOS, Linux, and Windows.
If you installed PostgreSQL via Homebrew:
pg_ctl -D /usr/local/var/postgres start
pg_ctl -D /usr/local/var/postgres stop
brew services start postgresql
brew services stop postgresql
If you want a hassle-free way to manage the local PostgreSQL database servers, use DBngin. It’s just one click to start, another click to turn off. No dependencies, no command line required, multiple drivers, multiple versions and multiple ports. And it’s free.
2. On Windows
First, you need to find the PostgreSQL database directory, it can be something like C:\Program Files\PostgreSQL\10.4\data . Then open Command Prompt and execute this command:
pg_ctl -D "C:\Program Files\PostgreSQL\9.6\data" start
pg_ctl -D "C:\Program Files\PostgreSQL\9.6\data" stop
pg_ctl -D "C:\Program Files\PostgreSQL\9.6\data" restart
- Open Run Window by Winkey + R
- Type services.msc
- Search Postgres service based on version installed.
- Click stop, start or restart the service option.
Update and install PostgreSQL 10.4
sudo apt-get update sudo apt-get install postgresql-10.4
By default, the postgres user has no password and can hence only connect if ran by the postgres system user. The following command will assign it:
sudo -u postgres psql -c "ALTER USER postgres PASSWORD 'postgres';" sudo -u postgres psql -c "CREATE DATABASE testdb;"
sudo service postgresql start
sudo service postgresql stop
Need a good GUI tool for PostgreSQL on MacOS and Windows? TablePlus is a modern, native tool with an elegant GUI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.