Message-ID: <3FB6DF08.4040603@Yahoo.com>
Date: Sat, 15 Nov 2003 21:20:56 -0500
From: Jan Wieck <JanWieck@Yahoo.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.4) Gecko/20030624
MIME-Version: 1.0
To: Jan Wieck <JanWieck@Yahoo.com>
Cc: ow <oneway_111@Yahoo.com>, Peter Eisentraut <peter_e@gmx.net>,
	pgsql-sql@postgresql.org
Subject: Re: Programatically switching database
References: <20031116015008.76880.qmail@web21402.mail.yahoo.com>
	<3FB6DE5B.1020000@Yahoo.com>
In-Reply-To: <3FB6DE5B.1020000@Yahoo.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Jan Wieck wrote:

> ow wrote:
> 
>> --- ow <oneway_111@yahoo.com> wrote:
>>> How? The doc only mentions db: pg_dump [option...] [dbname]
>>> 
>>> Then, how would I lock users out from the schema while it's being loaded?
>> 
>> Never mind how, I see there's "-n namespace" option in 7.4. But still, how
>> would I lock users out from the schema while it's being loaded?
> 
> #!/bin/sh
> 
> (
>      echo "start transaction;"
>      cat $2
>      echo "commit transaction;"
> ) psql $1

gosh, there's the pipe missing before the psql

> 
> 
> 
> then call it as
> 
> reload_in_transaction my_db my_namespace.dump
> 
> Since the whole dump will be restored inside of one transaction, nobody 
> will see it while it's reloading.
> 
> 
> Jan
> 


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #