Re: Adding another cluster on same machine

From: Jwiencek3 <jwiencek3(at)comcast(dot)net>
To: Yambu <hyambu(at)gmail(dot)com>
Cc: Ron <ronljohnsonjr(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Adding another cluster on same machine
Date: 2020-12-04 20:48:34
Message-ID: 5FAFBEDD-637A-4DDA-BD26-6C539ED2727D@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)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(at)gmail(dot)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.
>>
>>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Yambu 2020-12-04 21:12:28 Re: Adding another cluster on same machine
Previous Message David G. Johnston 2020-12-04 19:37:16 Re: Adding another cluster on same machine