Обсуждение: Adding another cluster on same machine
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
systemctl: invalid option -- 'D'
failed to find PGDATA setting in -D.service
regards
On Thursday, December 3, 2020, Yambu <hyambu@gmail.com> wrote:
HiIm 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.
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.
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
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.
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:
HiCentos 7Postgres v10yum 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.serviceOn 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.
Angular momentum makes the world go 'round.
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:
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.
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:
HiCentos 7Postgres v10yum 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.serviceOn 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.
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 portUse system to to start the ‘new’ service .Sent from my iPadOn Dec 4, 2020, at 10:20 AM, Yambu <hyambu@gmail.com> wrote:HiCentos 7Postgres v10yum 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.serviceOn 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.