V
V
vlarkanov2018-10-17 09:09:16
linux
vlarkanov, 2018-10-17 09:09:16

Postgres Pro 1C: how to get into the database and where do the configs live?

Product: PostgreSQL 1C 10.5
Platform: x86_64
Package: postgrespro-1c-10-server_10.5-1.bionic_amd64.deb
I did the installation according to the instructions:


apt-get update -y
apt-get install -y wget gnupg2 || apt-get install -y gnupg
wget -O - repo.postgrespro.ru/keys/GPG-KEY-POSTGRESPRO | apt-key add -
echo deb repo.postgrespro.ru/1c-archive/pg1c-10.5/ubuntu bionic main > /etc/apt/sources.list.d/postgrespro-1c.list
apt-get update -y
apt-get install -y postgrespro-1c-10-server
/opt/pgpro/1c-10/bin/pg-setup initdb
service postgrespro-1c-10 start

After that, I see that the DBMS is running:

ps aux | grep postgres
postgres 8727 0.0 0.0 319128 26392 ? Ss Oct16 0:00 /opt/pgpro/1c-10/bin/postgres -D /var/lib/pgpro/1c-10/data
postgres 8746 0.0 0.0 319244 6784 ? Ss Oct16 0:00 AM postgres: checkpointer process
postgres 8747 0.0 0.0 319128 4008 ? Ss Oct16 0:00 AM postgres: writer process
postgres 8748 0.0 0.0 319128 8860 ? Ss Oct16 0:00 AM postgres: wal writer process
postgres 8750 0.0 0.0 319532 6856 ? Ss Oct16 0:00 AM postgres: autovacuum launcher process
postgres 8752 0.0 0.0 173932 3336 ? Ss Oct16 0:00 postgres: stats collector process
postgres 8753 0.0 0.0 319416 4820 ? Ss Oct 16 0:00 AM postgres: bgworker: logical replication launcher
root 36779 0.0 0.0 13136 1060 pts/1 S+ 08:59 0:00 grep --color=auto postgres

I'm trying to get into the database through a socket:

#sudo -u postgres psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Apparently, socket connection is not configured. And if through TCP?

# psql -h localhost -U postgres
Password for user postgres:
psql: IMPORTANT: user "postgres" is not authenticated (by password)

I set a password for the postgres user (created automatically during the installation of the DBMS) - it does not let him in. I decided to configure pg_hba.conf so that it would start up locally via a socket - I can't find /etc/postgresql, /etc/pgpro. In /opt/pgpro/1c-10/share I found only prototypes of configs like

big.conf.sample
medium.conf.sample
pg_hba.conf.sample
pg_ident.conf.sample
pg_service.conf.sample
postgresql.conf.sample
psqlrc.sample
recovery.conf.sample
small.conf.sample

What to do, comrades - how to get into the database and where to find the configs?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Saenara, 2018-10-17
@vlarkanov

And there they looked:
-D /var/lib/pgpro/1c-10/data

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question