Re: Copying database directory

Поиск
Список
Период
Сортировка
От Tsing, Vadim
Тема Re: Copying database directory
Дата
Msg-id 035B18EFA3CCA540AF17AD5D3DFD9847E09B5B@LISL-XBCK-C1-V2.snaponglobal.com
обсуждение исходный текст
Ответ на Re: Copying database directory  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список 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 по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Copying database directory
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Postgres 8.4.2 "could not receive data from client: Unknown winsock error 10061"