Users and multiple server environment

From: Michael Long <mlong(at)datalong(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Users and multiple server environment
Date: 2004-10-03 05:02:15
Message-ID: 415F87D7.5000800@datalong.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

I now have 2 versions of postgres running on one box (7.3.2 and 8.0b3)
each listening on a different port. When creating a database, user or
schema in 8.0 that exists in 7.3.2 I get an error saying it already
exists. Can I have only one of each of these per server or am I missing
something? If possible I would like to be able to create a test database
on my production server that contains the same schemas and users as the
production database.

tia,
Mike

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-10-03 05:18:59 Re: Users and multiple server environment
Previous Message Michael Long 2004-10-03 04:48:08 Re: Installing postgresql-8.0.0beta3