pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re:
2+ messages / 2 participants
[nested] [flat]

* Re:
@ 2005-09-13 07:31 Yossi Kachlon <yossi_kachlon@symantec.com>
  2005-09-14 09:47 ` Re: hubert depesz lubaczewski <depesz@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Yossi Kachlon @ 2005-09-13 07:31 UTC (permalink / raw)
  To: depesz@gmail.com; pgsql-admin

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

 

 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re:
  2005-09-13 07:31 Re: Yossi Kachlon <yossi_kachlon@symantec.com>
@ 2005-09-14 09:47 ` hubert depesz lubaczewski <depesz@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: hubert depesz lubaczewski @ 2005-09-14 09:47 UTC (permalink / raw)
  To: Yossi Kachlon <yossi_kachlon@symantec.com>; +Cc: pgsql-admin

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


^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-09-14 09:47 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-13 07:31 Re: Yossi Kachlon <yossi_kachlon@symantec.com>
2005-09-14 09:47 ` hubert depesz lubaczewski <depesz@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox