From: | "Tony Sullivan" <tony(at)exquisiteimages(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Multiple PostgreSQL instances on one machine |
Date: | 2018-06-08 20:29:26 |
Message-ID: | 43cd24d444bb19a06c028f24dadbc5cc.squirrel@www.exquisiteimages.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am trying to consolidate some machines in my server room particularly in
the testing environment and I was hoping someone could point me in the
right direction.
I currently have three machines running PostgreSQL for testing purposes.
Each week a backup is made of the production database and this is deployed
onto these three machines. None of these machines is any where near
capacity. I would like to host all three instances on one machine.
I know that "initdb" can be used to create additional installations, but
the part I am unsure about is the tablespace. The production database has
a tablespace defined that resides on its SSD. When I use the production
backup, I have to create a mount point on the test machine with the same
name as the one on the production database. I am not certain how I would
handle this situation if I am serving three separate instances of that
database from one computer.
From | Date | Subject | |
---|---|---|---|
Next Message | Vick Khera | 2018-06-08 20:38:28 | Re: Multiple PostgreSQL instances on one machine |
Previous Message | Steve Atkins | 2018-06-08 20:26:12 | Re: Performance problem postgresql 9.5 |