pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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