Re: Adding another cluster on same machine - Mailing list pgsql-admin

From Jwiencek3
Subject Re: Adding another cluster on same machine
Date
Msg-id 5FAFBEDD-637A-4DDA-BD26-6C539ED2727D@comcast.net
Whole thread Raw
In response to Re: Adding another cluster on same machine  (Yambu <hyambu@gmail.com>)
Responses Re: Adding another cluster on same machine  (Yambu <hyambu@gmail.com>)
List pgsql-admin
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.


pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Adding another cluster on same machine
Next
From: Yambu
Date:
Subject: Re: Adding another cluster on same machine