Обсуждение:

Поиск
Список
Период
Сортировка

От
"Yossi Kachlon"
Дата:

 

Hello,

I have a few questions:

1 - I would like to know if I can install several installations of PostgreSql on the same machine with silent install (different ports) ?

2 – Can I make a backup of the database without shutting it down?

3 – Is there support for multi-CPU?

4 – Is there a support for OSF1 OS?

 

I will greatly appreciate a response for my questions.

 

Thanks,

 

 

 

Yossi kahlon

Sr. Software Engineer

Application Performance Prods

Symantec Corporation

-----------------------------------------------------

Office: 972-37352293

Email: yossi_kachlon@symantec.com

-----------------------------------------------------

Symantec Logo

 

Re:

От
hubert depesz lubaczewski
Дата:


On 9/13/05, Yossi Kachlon <yossi_kachlon@symantec.com> wrote:

1 - I would like to know if I can install several installations of PostgreSql on the same machine with silent install (different ports) ?



of course. you can have as many installations as you want (limited by number of ports, memory and disk size of course)

2 – Can I make a backup of the database without shutting it down?



of course. actually it is the only way to do real backup. doing file-copy is not safe, and requres person who does it to think more than neccessary. pg_dump utility makes dumps of working database, does it reasonably quickly, and without any observable (at least by me) disturbance to other applications.
 

3 – Is there support for multi-CPU?



of course.
 

4 – Is there a support for OSF1 OS?



i dont know. but you can have the sources, so with just a little bit of luck you will be able to cmopile it.

depesz


Re:

От
"Yossi Kachlon"
Дата:

Thanks for the quick answer.

I have two more questions:

 

1 – Does PostgeSql support partitions and/or partition views?

 

2- I tried to install two installations of PostgreSql on windows-2000 and after the first installation the wizard ask me if I want to modify or remove the first installation but didn't give me the option to install another one. How do I install more than one instance?

 

 

From: hubert depesz lubaczewski [mailto:depesz@gmail.com]
Sent: Tuesday, September 13, 2005 10:23
To: Yossi Kachlon; pgsql-admin@postgresql.org
Subject: Re: [ADMIN]

 

 

On 9/13/05, Yossi Kachlon <yossi_kachlon@symantec.com> wrote:

 

1 - I would like to know if I can install several installations of PostgreSql on the same machine with silent install (different ports) ?



of course. you can have as many installations as you want (limited by number of ports, memory and disk size of course)

 

2 – Can I make a backup of the database without shutting it down?



of course. actually it is the only way to do real backup. doing file-copy is not safe, and requres person who does it to think more than neccessary. pg_dump utility makes dumps of working database, does it reasonably quickly, and without any observable (at least by me) disturbance to other applications.
 

 

3 – Is there support for multi-CPU?



of course.
 

 

4 – Is there a support for OSF1 OS?



i dont know. but you can have the sources, so with just a little bit of luck you will be able to cmopile it.

depesz

 

 

Re:

От
Peter Eisentraut
Дата:
Yossi Kachlon wrote:
> 1 - I would like to know if I can install several installations of
> PostgreSql on the same machine with silent install (different ports)

Yes

> 2 - Can I make a backup of the database without shutting it down?

Yes

> 3 - Is there support for multi-CPU?

Yes

> 4 - Is there a support for OSF1 OS?

Yes

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Re:

От
hubert depesz lubaczewski
Дата:
On 9/13/05, Yossi Kachlon <yossi_kachlon@symantec.com> wrote:

 – Does PostgeSql support partitions and/or partition views?



not yet. but usually using partial indices works as well. usually. not always.
 

2- I tried to install two installations of PostgreSql on windows-2000 and after the first installation the wizard ask me if I want to modify or remove the first installation but didn't give me the option to install another one. How do I install more than one instance?



sorry, can't help with this one - i dont know windows, and isntallation under linux is totally different.

depesz