Re: Adding another cluster on same machine

From: Yambu <hyambu(at)gmail(dot)com>
To: Jwiencek3 <jwiencek3(at)comcast(dot)net>
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 21:12:28
Message-ID: CALhHtcDTN=ONoqX7dazbPaPvZvUPRvfKhEmOYD3cYVQ4dyyfAg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thank you all for your assistance, you have pointed me to great resources

On Fri, Dec 4, 2020 at 10:48 PM Jwiencek3 <jwiencek3(at)comcast(dot)net> wrote:

> 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

Browse pgsql-admin by date

  From Date Subject
Next Message mark armon 2020-12-05 17:02:38 unbale to use pg_ctl in Windows Cmd.
Previous Message Jwiencek3 2020-12-04 20:48:34 Re: Adding another cluster on same machine