Yandex.Cloud
  • Services
  • Why Yandex.Cloud
  • Pricing
  • Documentation
  • Contact us
Get started
Yandex Managed Service for PostgreSQL
  • Getting started
  • Step-by-step instructions
    • All instructions
    • Information about existing clusters
    • Creating clusters
    • Connecting to databases
    • Stop and start the cluster
    • SQL queries in the management console
    • Changing cluster and database settings
    • Connecting to DataLens
    • Managing PostgreSQL hosts
    • Database management
    • How to manage PostgreSQL extensions
    • Managing database users
    • Granting permissions and roles
    • Managing backups
    • Deleting clusters
    • Database migration to the Cloud
    • Creating a logical replica of Amazon RDS for PostgreSQL in Managed Service for PostgreSQL
  • Solutions
    • Creating a PostgreSQL cluster for 1C
  • Concepts
    • Relationship between service resources
    • Host classes
    • Network in Yandex Managed Service for PostgreSQL
    • Quotas and limits
    • Storage types
    • Backups
    • Assigning roles
    • Replication
    • Supported clients
  • Access management
  • Pricing policy
    • Current pricing policy
    • Archive
      • Before January 1, 2019
      • From January 1 to March 1, 2019
      • From March 1, 2019 to February 1, 2020
  • API reference
    • Authentication in the API
    • gRPC
      • Overview
      • BackupService
      • ClusterService
      • DatabaseService
      • ResourcePresetService
      • UserService
      • OperationService
    • REST
      • Overview
      • Backup
        • Overview
        • get
        • list
      • Cluster
        • Overview
        • addHosts
        • backup
        • create
        • delete
        • deleteHosts
        • get
        • list
        • listBackups
        • listHosts
        • listLogs
        • listOperations
        • move
        • rescheduleMaintenance
        • restore
        • start
        • startFailover
        • stop
        • streamLogs
        • update
        • updateHosts
      • Database
        • Overview
        • create
        • delete
        • get
        • list
        • update
      • ResourcePreset
        • Overview
        • get
        • list
      • User
        • Overview
        • create
        • delete
        • get
        • grantPermission
        • list
        • revokePermission
        • update
      • Operation
        • Overview
        • get
  • Questions and answers
    • General questions
    • Questions about PostgreSQL
    • All questions on the same page
  1. Solutions
  2. Creating a PostgreSQL cluster for 1C

Creating a PostgreSQL cluster for 1C:Enterprise

  • Create a cluster PostgreSQL
  • Connect the database to 1C:Enterprise
  • PostgreSQL extensions for 1C:Enterprise support

Managed Service for PostgreSQL allows you to create failsafe PostgreSQL clusters optimized for 1C:Enterprise. For this, the service supports PostgreSQL versions 10-1c and 11-1c with all the necessary extensions installed and connection pooler configuration changed.

Warning

You can connect 1C:Enterprise to clusters that run PostgreSQL 10-1c or 11-1c.

When you select a host class, base it on the number of users in your 1C:Enterprise installation. The s2.small hosts can accommodate up to 50 users at once. We recommend that you use the s2.medium class if 50 or more users are going to access the database. Choose the storage size based on your expected data scope and allow for possible growth in your data volumes.

Create a cluster PostgreSQL

To create a Managed Service for PostgreSQL cluster for 1C:

  1. On the folder page in management console, click Create resource and select PostgreSQL cluster.

  2. In the Name field, enter the cluster name: postgresql-1c.

  3. In the Environment field, select PRODUCTION.

  4. In the Version field, select 10-1c.

  5. Under Host class, select s2.small.

  6. Under Storage size, enter 10 GB.

  7. Under Database, enter:

    • In the DB name field, enter the cluster name: postgresql-1c.
    • In the Username field, enter user-1c.
    • In the Password field, enter the password you will use to access the DB.
  8. Under Network, select the network for the cluster hosts.

  9. Under Hosts, add two more hosts in the other availability zones to ensure failover. The database is automatically replicated.

  10. Under Additional settings, set the time to start backups.

  11. Click Create cluster.

Creating the DB cluster may take several minutes.

Connect the database to 1C:Enterprise

Add the created database as an information base to 1C:Enterprise. When adding the database, use the following parameters:

  • Secure connection: Disabled.
  • DBMS type: PostgreSQL.
  • Database server: <master host name>.mdb.yandexcloud.net port=6432.
  • Database name: postgresql-1c.
  • Database user: user-1c.
  • User password: <database user password>.
  • Create database if none present: disabled.

PostgreSQL extensions for 1C:Enterprise support

List of extensions installed in clusters running PostgreSQL 10-1c and 11-1c:

  • online_analyze
  • plantuner
  • fasttrun
  • fulleq
  • mchar
In this article:
  • Create a cluster PostgreSQL
  • Connect the database to 1C:Enterprise
  • PostgreSQL extensions for 1C:Enterprise support
Language
Careers
Privacy policy
Terms of use
© 2021 Yandex.Cloud LLC