Skip site navigation (1) Skip section navigation (2)

Re: What's the point of multiple databases?

From: Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
To: mmaney(at)bigfoot(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: What's the point of multiple databases?
Date: 2000-06-29 13:18:09
Message-ID: 395B4C91.230BAD45@cupid.suninternet.com (view raw or flat)
Thread:
Lists: pgsql-novice
Martin Maney wrote:
> 
> I hope I don't regret too much not waiting for morning and a fresh take on
> all this.  :-)
> 
> So I've got this nice new postgreSQL and it seems to be working nicely.
> I've setup a user identity with create database priviliges, and set out to
> setup a couple databases for separate projects I want to work on.  That's
> what separately named databases are for, right?
> 
> Well, maybe it's just a quirk of the utilities (psql and pgaccess), but it
> seems that no matter which database I open, I can see and access all the
> tables in any database created by this user.  This seems, well, wrong.
> 
> This is from the Debian "potato" install, which is based on 6.5.3.  All I
> need is a sanity check, please: is this doable, or is there no point in
> setting up more than one database per postgres user?

First, show us what you're seeing. Next, if you create something
in the template1 DB, then it will appear in all newly created
databases...

HTH,

-- 
Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
http://cupid.suninternet.com/~kleptog/

In response to

Responses

pgsql-novice by date

Next:From: D. DucciniDate: 2000-06-29 14:05:02
Subject: Re: What's the point of multiple databases?
Previous:From: matDate: 2000-06-29 12:51:19
Subject: Re: Problems with Installation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group