Answer the question
In order to leave comments, you need to log in
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
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
#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"?
# psql -h localhost -U postgres
Password for user postgres:
psql: IMPORTANT: user "postgres" is not authenticated (by password)
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
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question