Re: Copying database directory

Actually, that same app we ship on the media is also available as a web
app. The media is offered to customers who are requesting local access
or that have slow or unreliable Internet access. These are the
requirements we have to deal with. :-(

-----Original Message-----
From: Kevin Grittner [mailto:Kevin(dot)Grittner(at)wicourts(dot)gov]
Sent: Saturday, December 18, 2010 2:51 PM
To: pgsql-admin(at)postgresql(dot)org; Tsing, Vadim
Subject: RE: [ADMIN] Copying database directory

"Tsing, Vadim" wrote:

> Out databases vary in size, bat many of the have tables with
> millions of rows. Those tables are indexed. One of the databases
> that we've timed, took about 12 min to load the data and another
> 10-12 min to re-create indexes. The dump file is about 400 MB. This
> is by far not the largest one we will have to deal with.

Any chance that you can just have the app make requests to a database
on your server, and not ship the database with the software? Maybe
even do this as a web app?

-Kevin