Users and multiple server environment - Mailing list pgsql-admin

From Michael Long
Subject Users and multiple server environment
Date
Msg-id 415F87D7.5000800@datalong.com
Whole thread Raw
Responses Re: Users and multiple server environment  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-admin by date:

Previous
From: Michael Long
Date:
Subject: Re: Installing postgresql-8.0.0beta3
Next
From: Tom Lane
Date:
Subject: Re: Users and multiple server environment