Re: Where Can I Find...
От | John R Pierce |
---|---|
Тема | Re: Where Can I Find... |
Дата | |
Msg-id | 5104D49D.5060001@hogranch.com обсуждение исходный текст |
Ответ на | Where Can I Find... (Gene Poole <gene.poole@macys.com>) |
Список | pgsql-general |
On 1/25/2013 8:21 AM, Gene Poole wrote:
lso I don't want to use RPM because I like to control where software is installed. Another piece on information is that I am running on CentOS 5.8.
if you don't want to use RPM, why did you choose an RPM based distribution?
is '6 single sided DVDs' a cute way of saying around 24 GB of data?
there's absolutely NO reason to use a bunch of tablespaces for a database that small. we use tablespaces for multi-terabyte databases. Instead, on modern hardware, just put a bunch of small/fast disks in a raid10 and use that for the whole thing.
An Oracle 'instance" is roughly equivalent to a postgres 'database', the instance can have many schemas within it.
For copying the data across, I'd look into ETL packages, such as http://www.jaspersoft.com/JasperSoft_JasperETL.html
these can connect to different database engines, and 'extract, transform, and load', with a lot of flexibilty.
-- john r pierce 37N 122W somewhere on the middle of the left coast
В списке pgsql-general по дате отправления: