Multiple instances with same version?

From: durumdara <durumdara(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Multiple instances with same version?
Date: 2011-04-20 06:04:15
Message-ID: 4DAE775F.70408@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear Everybody!

I want to ask that have some way to install PGSQL 9.0 as two instances
in one machine?

Most important question. The OS is can be Windows or Linux.

I asked this, because formerly we heard about a story. I cite this as I
remember:

We have some product, and in the only one server of the customer
(Win) have a PG9.0 version installed.
But the developer company lost in the space, only the software
(must) working...

We don't know the root password, and we don't want to hack it (the
system must work).
But we needed to install the our version of the PG what is also 9.0
(because of the new functions)...
...

We want to prepare to same situations with learn about PG.

With Firebird and MS-SQL this case is not problem, because on same
machine we can install another instances with same version.

But I don't know that is PG supports multiple instances with same
version or not?

Also interesting question are the "users".

In our systems we create user for every real user. If they are 100, we
have same number of db users.

But if we want to server more database in one place, we may do conflict
on users. For example: all of the databases have user JohnM.

If we can do multiple instances, the problem is vanishing, because all
have it's own user list.

If we cannot, then only idea if have if we make prefix on usernames
based on short dbname.
For example:
offer_db users: off_JohnM, off_MaryK
press_db users: prs_JohnM, prs_TomR

Please help just a little to I can know the limitations of PG.

Thanks for it!

Regards:
dd

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Toby Corkindale 2011-04-20 06:15:19 Re: SSDs with Postgresql?
Previous Message Toby Corkindale 2011-04-20 05:50:12 Re: SSDs with Postgresql?