Re: Copying database directory - Mailing list pgsql-admin

From Tsing, Vadim
Subject Re: Copying database directory
Date
Msg-id 035B18EFA3CCA540AF17AD5D3DFD9847E09B5B@LISL-XBCK-C1-V2.snaponglobal.com
Whole thread Raw
In response to Re: Copying database directory  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
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.Grittner@wicourts.gov]
Sent: Saturday, December 18, 2010 2:51 PM
To: pgsql-admin@postgresql.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

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Copying database directory
Next
From: "Kevin Grittner"
Date:
Subject: Re: Postgres 8.4.2 "could not receive data from client: Unknown winsock error 10061"