Re: [HACKERS] creating a cluster

2004-06-23 Thread Alexander Cohen
On Jun 23, 2004, at 11:36 AM, Tom Lane wrote:
David Garamond <[EMAIL PROTECTED]> writes:
Alvaro Herrera wrote:
On Mon, Jun 21, 2004 at 09:16:35PM -0400, Alexander Cohen wrote:
Does anyone have any new ways to create clusters without using 
initdb
or bootstrap mode? I need to be able to create one without those 2
things. Any ideas?
initdb'ing somewhere else and copying the resulting directory?

Btw, I've been doing this for a binary distribution on Windows 
(Cygwin)
and Linux.
Yeah, that would work fine as long as the "somewhere else" is using an
identical Postgres build.  I found out in off-list conversation that
Alexander wants to build a hacked-up version of Postgres with all
bootstrap code removed (and, I suppose, a bunch of other changes too).
Seems to me that file-level compatibility would be difficult to
guarantee under such circumstances, so I told him he ought to put back
the bootstrap support ... it's not like it's large ...
For the meantime, i ended up compiling a normal version of postgres and 
using that with initdb, then switching it over to my "hacked-up" 
version. It works, and thats all i need for now!

Alex
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [HACKERS] creating a cluster

2004-06-23 Thread Alexander Cohen
On Jun 23, 2004, at 10:18 AM, David Garamond wrote:
Alvaro Herrera wrote:
On Mon, Jun 21, 2004 at 09:16:35PM -0400, Alexander Cohen wrote:
Does anyone have any new ways to create clusters without using 
initdb or bootstrap mode? I need to be able to create one without 
those 2 things. Any ideas?
initdb'ing somewhere else and copying the resulting directory?
Btw, I've been doing this for a binary distribution on Windows 
(Cygwin) and Linux. Primarily because initdb-ing + doing a bunch of 
SQL commands to the db takes a long time on Cygwin. Seems fine so far.
And how do you take care of users for your distribution. If you created 
the cluster on your computer, does it not have your user name as the 
main root user? That needs to be changed when copying over the cluster, 
how do i that?

Alex
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[HACKERS] creating a cluster

2004-06-21 Thread Alexander Cohen
Does anyone have any new ways to create clusters without using initdb 
or bootstrap mode? I need to be able to create one without those 2 
things. Any ideas?

thanks!
Alex
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
 subscribe-nomail command to [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly