PostgreSql Service different path

From: chris navarroza <canavarroza(dot)work(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSql Service different path
Date: 2022-10-24 07:51:30
Message-ID: CADRdQ7qtqTGPbeKg2Seod0-s+54fa_QG8kBP3JBRpea0ueX5SA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I install postgresql14.5 with the following commands

sudo yum install postgresql14-server postgresql14-contrib

sudo su postgres

cd /tmp

/usr/pgsql-14/bin/initdb -D /home/dmartuser/pgsql/14/data
and update the postgresql.conf to the new path, now when I start the
service, it has an error and when I check it says

-- Unit postgresql-14.service has begun starting up.
Oct 24 15:16:45 datamartds postgresql-14-check-db-dir[132338]:
*"/var/lib/pgsql/14/data/"
is missing or empty.*
Oct 24 15:16:45 datamartds postgresql-14-check-db-dir[132338]: Use
"/usr/pgsql-14/bin/postgresql-14-setup initdb" to initialize the database
cluster.
Oct 24 15:16:45 datamartds postgresql-14-check-db-dir[132338]: See
/usr/share/doc/postgresql14/README.rpm-dist for more information.
Oct 24 15:16:45 datamartds systemd[1]: postgresql-14.service: Control
process exited, code=exited status=1
Oct 24 15:16:45 datamartds systemd[1]: postgresql-14.service: Failed with
result 'exit-code'.

How can I point the service to read the new path (
/home/dmartuser/pgsql/14/data )?

Thanks,

Chris Albert Navarroza
Information Technology Officer I
CTCO - ITDS - RDMD

Responses

Browse pgsql-general by date

  From Date Subject
Next Message 黄宁 2022-10-24 08:34:51 GIN Index use statistic information?
Previous Message Laurenz Albe 2022-10-24 04:08:22 Re: synchronous streaming replication