pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Uwe C. Schroeder <uwe@oss4u.com>
To: pgsql-admin@postgresql.org
Subject: Slony setup help needed
Date: Tue, 10 Aug 2004 21:32:37 -0700
Message-ID: <200408102132.37912.uwe@oss4u.com> (raw)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi all,

has anyone encountered an error when running a slony_setup.pl generated script 
to set up a master?
The problem I hit is that the xxid.v73.sql file aborts with the following 
error:

Aug 10 20:57:57 ibserver postgres[9749]: [12] ERROR:  parser: parse error at 
or near "." at character 909
Aug 10 20:57:57 ibserver postgres[9749]: [13] LOG:  query: select 1;
Aug 10 20:57:57 ibserver postgres[9749]: [14] ERROR:  current transaction is 
aborted, queries ignored until end of transaction block
Aug 10 20:57:57 ibserver postgres[9749]: [15] LOG:  query: rollback 
transaction;
Aug 10 20:57:57 ibserver postgres[9749]: [16] LOG:  pq_recvbuf: unexpected EOF 
on client connection

I traced the error to the two "CREATE CAST" statements for xxid in the script. 
According to the pg-docs the types in create cast may not be namespace 
specified, the script however adds the namespace.
Since I couldn't find a bugreport, any reference on google or anything else 
about this I have to assume it's something local to my setup. If the 
namespace specification wasn't possible at all, someone else would have run 
into this problem already.

I'm using slony1-1.0.1 on a plain vanilla mandrake 9.1 with postgres 7.3.2 
(from the rpm)

Any pointers would be greatly appreciated.

	Uwe


- --
Open Source Solutions 4U, LLC	2570 Fleetwood Drive
Phone:  +1 650 872 2425		San Bruno, CA 94066
Cell:   +1 650 302 2405		United States
Fax:    +1 650 872 2417
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFBGaFljqGXBvRToM4RAoQOAKCzoKh7iRpKQfrcQEAD2cATLpLsGwCeNkED
iFYm/KMaOmjtJadVxmh+H3E=
=6hPa
-----END PGP SIGNATURE-----




Message-ID: <200408102132.37912.uwe@oss4u.com>
Permalink:  ../200408102132.37912.uwe@oss4u.com/
Also on:    postgresql.org/message-id/200408102132.37912.uwe@oss4u.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: uwe@oss4u.com
  Subject: Re: Slony setup help needed
  In-Reply-To: <200408102132.37912.uwe@oss4u.com>
  References: <200408102132.37912.uwe@oss4u.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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