Re: Copying database directory - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Copying database directory
Date
Msg-id 4D0CBC290200002500038793@gw.wicourts.gov
Whole thread Raw
In response to Copying database directory  ("Tsing, Vadim" <Vadim.Tsing@snapon.com>)
Responses Re: Copying database directory  ("Tsing, Vadim" <Vadim.Tsing@snapon.com>)
List pgsql-admin
"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

pgsql-admin by date:

Previous
From: "Tsing, Vadim"
Date:
Subject: Re: Copying database directory
Next
From: "Tsing, Vadim"
Date:
Subject: Re: Copying database directory