Re: Adding another cluster on same machine

You need to copy the service file to /etc/systemd /system and give it a new name.   Edit the new file and change the environment variable to point to the new data directory.

You will need to change the port number in the Postgresql.conf file before starting the service.  Can’t have two clusters on the same server using the same port

Use system to to start the ‘new’ service .   

Sent from my iPad

On Dec 4, 2020, at 10:20 AM, Yambu <hyambu@gmail.com> wrote:



Hi

Centos 7

Postgres v10

yum install postgresql10-server

/usr/pgsql-10/bin/postgresql-10-setup initdb

systemctl enable postgresql-10.service
systemctl status  postgresql-10.service
systemctl start  postgresql-10.service

On Fri, Dec 4, 2020 at 3:34 PM Ron <ronljohnsonjr@gmail.com> wrote:

On 12/4/20 12:27 AM, Yambu wrote:
> Hi
>
> Im trying to add a second cluster on the same machine, but im getting
> error below,what could be the problem?
>
> -bash-4.2$ /usr/pgsql-10/bin/postgresql-10-setup initdb -D
> /var/lib/pgsql/10/data-log -p 5433
> systemctl: invalid option -- 'D'
> failed to find PGDATA setting in -D.service

What distro (including version!) are you running?
How did you install Postgres?

--
Angular momentum makes the world go 'round.