Re: creating a cluster

From: Alexander Cohen <alex(at)toomuchspace(dot)com>
To: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
Cc: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: creating a cluster
Date: 2004-06-23 14:38:03
Message-ID: EE9A6C06-C522-11D8-8197-000A95B947DC@toomuchspace.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Huxton 2004-06-23 14:38:53 Re: Weird NOT IN condition in SELECT (PostgreSQL 7.4.3
Previous Message Ferruccio Zamuner 2004-06-23 14:21:28 Weird NOT IN condition in SELECT (PostgreSQL 7.4.3 and 7.4.2 tested)