X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7F4D1D6D85 for ; Tue, 13 Sep 2005 04:35:02 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78928-02 for ; Tue, 13 Sep 2005 07:34:59 +0000 (GMT) Received: from silver.veritas.com (silver.veritas.com [143.127.12.111]) by svr1.postgresql.org (Postfix) with ESMTP id 09B06D8B12 for ; Tue, 13 Sep 2005 04:34:59 -0300 (ADT) Received: from unknown (HELO GPKXCHCON2.enterprise.veritas.com) (10.14.84.161) by silver.veritas.com with ESMTP; 13 Sep 2005 00:35:00 -0700 Received: from oryxchmb1.enterprise.veritas.com ([166.98.18.22]) by GPKXCHCON2.enterprise.veritas.com with Microsoft SMTPSVC(6.0.3790.211); Tue, 13 Sep 2005 08:31:53 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5B835.351F66B8" Subject: Re: Date: Tue, 13 Sep 2005 10:31:51 +0300 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] Thread-Index: AcW4NAmeJ+uHvJT8S/KZYUXYq/5HQQAAKnlw From: "Yossi Kachlon" To: , X-OriginalArrivalTime: 13 Sep 2005 07:31:53.0559 (UTC) FILETIME=[36698670:01C5B835] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.397 required=5 tests=[AWL=0.031, HTML_MESSAGE=0.001, SUBJ_ALL_CAPS=0.365] X-Spam-Level: X-Archive-Number: 200509/126 X-Sequence-Number: 18863 This is a multi-part message in MIME format. ------_=_NextPart_001_01C5B835.351F66B8 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Thanks for the quick answer. I have two more questions: =20 1 - Does PostgeSql support partitions and/or partition views? =20 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? =20 =20 _____ =20 From: hubert depesz lubaczewski [mailto:depesz@gmail.com]=20 Sent: Tuesday, September 13, 2005 10:23 To: Yossi Kachlon; pgsql-admin@postgresql.org Subject: Re: [ADMIN] =20 =20 On 9/13/05, Yossi Kachlon wrote: =20 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) =20 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. =20 =20 3 - Is there support for multi-CPU? of course. =20 =20 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 =20 =20 ------_=_NextPart_001_01C5B835.351F66B8 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

 

 

------_=_NextPart_001_01C5B835.351F66B8--