Hi,

I installed the PostgreSQL 8.1.5, Slony 1.1.5 using the binaries from
Debain (apt-get) and have manually created a cluster that works.

I would like to create another Slony 1.1.5 cluster with PgAdmin III
1.4.3. But PgAdmin says: "Slony-I creation scripts not available; only
joining possible". Which scripts does PgAdmin mean?

TIA


--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

On 29/10/06 04:55, "Joost Kraaijeveld" <J.Kraaijeveld@Askesis.nl> wrote:

> Hi,
>
> I installed the PostgreSQL 8.1.5, Slony 1.1.5 using the binaries from
> Debain (apt-get) and have manually created a cluster that works.
>
> I would like to create another Slony 1.1.5 cluster with PgAdmin III
> 1.4.3. But PgAdmin says: "Slony-I creation scripts not available; only
> joining possible". Which scripts does PgAdmin mean?

It's looking for the Slony SQL script (slony1_funcs.sql, xxid.sql etc). You
can set the path to them under File -> Options iirc.

Regards, Dave.


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Hi Dave,

On Sun, 2006-10-29 at 06:15 +0000, Dave Page wrote:
> > I would like to create another Slony 1.1.5 cluster with PgAdmin III
> > 1.4.3. But PgAdmin says: "Slony-I creation scripts not available; only
> > joining possible". Which scripts does PgAdmin mean?
>
> It's looking for the Slony SQL script (slony1_funcs.sql, xxid.sql etc). You
> can set the path to them under File -> Options iirc.
OK, those scripts are on my machine (/usr/share/slony1). Maybe this info
(which scripts are needed) could be added to the online docs?

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

On 29/10/06 06:22, "Joost Kraaijeveld" <J.Kraaijeveld@Askesis.nl> wrote:

> Hi Dave,
>
> On Sun, 2006-10-29 at 06:15 +0000, Dave Page wrote:
>>> I would like to create another Slony 1.1.5 cluster with PgAdmin III
>>> 1.4.3. But PgAdmin says: "Slony-I creation scripts not available; only
>>> joining possible". Which scripts does PgAdmin mean?
>>
>> It's looking for the Slony SQL script (slony1_funcs.sql, xxid.sql etc). You
>> can set the path to them under File -> Options iirc.
> OK, those scripts are on my machine (/usr/share/slony1). Maybe this info
> (which scripts are needed) could be added to the online docs?

It does: http://www.pgadmin.org/docs/dev/slony-install.html (except it
describes them as 'Slony-I cluster creation scripts'.

Regards, Dave.


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

On Sun, 2006-10-29 at 07:34 +0000, Dave Page wrote:

> It does: http://www.pgadmin.org/docs/dev/slony-install.html (except it
> describes them as 'Slony-I cluster creation scripts'.
Yes, I have seen that remark, but that made *me* wonder which of the
scripts that are part of the slony source distribution I should use: the
perl scripts in tools or tools/altperl. And the correct answer was the
sql scripts in src/backend.

Maybe I am not smart enough ;-)

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match