Postgres Pro
Downloads
Home   >   mailing lists

Thread: Adding another cluster on same machine

Adding another cluster on same machine

From
Yambu
Date:
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

regards

Re: Adding another cluster on same machine

From
"David G. Johnston"
Date:
On Thursday, December 3, 2020, Yambu <hyambu@gmail.com> 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 is “postgresql-10-setup” ?

David J. 

Re: Adding another cluster on same machine

From
Ron
Date:
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.

Re: Adding another cluster on same machine

From
Yambu
Date:
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.


Re: Adding another cluster on same machine

From
Ron
Date:

The problem might be that you have to do the initdb after "systemctl start  postgresql-10.service".

On 12/4/20 10:20 AM, Yambu 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.



--
Angular momentum makes the world go 'round.

Re: Adding another cluster on same machine

From
"David G. Johnston"
Date:
On Fri, Dec 4, 2020 at 10:10 AM Ron <ronljohnsonjr@gmail.com> wrote:

The problem might be that you have to do the initdb after "systemctl start  postgresql-10.service".

No.  You definitely need to initialize the database cluster before you try starting it.

> -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

This made-up command is the problem.

After some searching I found this:

https://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob_plain;f=rpm/redhat/master/non-common/postgresql-10/master/postgresql-10-README-systemd.rpm-dist;hb=HEAD

The section titled: "MULTIPLE POSTMASTERS (For the same PostgreSQL version)"

Though, if you don't care about systemd just ignore all the RPM-specific stuff and follow the instructions in the PostgreSQL documentation.  IOW, don't use "postgresql-10-setup".

David J.


Re: Adding another cluster on same machine

From
Jwiencek3
Date:
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.


Re: Adding another cluster on same machine

From
Yambu
Date:
Thank you all for your assistance, you have pointed me to great resources

On Fri, Dec 4, 2020 at 10:48 PM Jwiencek3 <jwiencek3@comcast.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@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.