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

Re: Create user/create database outside template1

From: Vince Vielhaber <vev(at)michvhf(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Create user/create database outside template1
Date: 2000-05-25 17:05:03
Message-ID: Pine.BSF.4.21.0005251304240.48232-100000@paprika.michvhf.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, 25 May 2000, Bruce Momjian wrote:

> > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > > What happens if people issue create user or create database outside
> > > template1.  Do we need to prevent it?  Seems they work, but am not sure
> > > it is OK.  Do we need to add a check?
> > 
> > Works fine, no, and no.  The reason the scripts like to connect to
> > template1 is that it's the only database they can be sure is there.
> > But the commands themselves don't care where you're connected.
> 
> Well, thanks.  I was going over that for my book.  If I do createdb from
> another database, I guess I get a copy of that database, right? 
> Interesting feature that I am sure few people realize.

Say what?  That might explain a few things.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev(at)michvhf(dot)com    http://www.pop4.net
 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2000-05-25 17:05:16
Subject: Re: Create user/create database outside template1
Previous:From: Bruce MomjianDate: 2000-05-25 16:42:24
Subject: Re: Create user/create database outside template1

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