Re: run 2 instances of postgres 9.4 on same linux VM

Yes, the instance already running is live in that users are indirectly
querying/writing to it. I just need to launch a 2nd instance.

On Mon, Nov 9, 2015 at 9:57 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 11/09/2015 06:03 PM, anj patnaik wrote:
>
> CCing list
>
>> I used the graphical installer to install PG 9.4 on this system. Also,
>> my OS is RHEL 6.5. Thanks for any help!
>>
>
> Hmm, not sure you can mix this with an RPM install. I thought I remember
> that the graphical installer could deal with multiple instances, but I do
> not use it personally so that is just a guess. Maybe someone with more
> experience with it could offer a suggestion.
>
> One more question?:
>
> Is the 9.4 instance you have running a live production database?
>
> If not it might be easier to start over using a different method assuming
> that you cannot get the graphical method to install side by side instances.
>
>
>> On Mon, Nov 9, 2015 at 8:14 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>>
>> On 11/09/2015 03:48 PM, anj patnaik wrote:
>>
>> I found this link explaining how to launch multiple instances. I
>> was not
>> able to find detailed steps like these in the postgres docs.
>>
>> Is this accurate from what you perceive? It also says to have
>> separate
>> init.d scripts (startup). Thanks
>>
>>
>> https://opensourcedbms.com/dbms/running-multiple-postgresql-9-2-instances-on-one-server-in-centos-6rhel-6fedora/
>>
>>
>> Well if you really have your heart set on this I would take look at
>> this:
>>
>> http://yum.postgresql.org/howtoyum.php
>>
>> Though the above would depend on how you installed your current
>> version of Postgres 9.4.
>>
>> So where did you install it from?
>>
>>
>> On Mon, Nov 9, 2015 at 4:30 PM, Adrian Klaver
>> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com
>>
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>> wrote:
>>
>> On 11/09/2015 11:40 AM, anj patnaik wrote:
>>
>> I have a linux 6.5 RHEL VM in which I am running an
>> instance of
>> PG 9.4.
>> In order to test NFS, I want to run a second instance
>> on same VM but
>> different file system.
>>
>>
>> http://www.postgresql.org/docs/9.4/interactive/app-initdb.html
>>
>> init the cluster on the file system you want using -D,
>> assuming the
>> VM can access that file system.
>>
>> FYI, best practices is not to run on NFS, so do not be
>> surprised if
>> things break.
>>
>>
>> Has anyone done this and is it possible with no issues?
>>
>>
>>
>> Or is it better to run different versions of PG on same
>> server?
>>
>>
>> No, you just need to make sure the Postgres clusters are
>> listening
>> on different ports. That means going into postgresql.conf
>> in the
>> cluster and changing the port variable.
>>
>>
>> Please advise. Thanks
>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
>>
>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>