On Tue, 2005-11-22 at 12:18, Melvin Davidson wrote:

> > > I have no problem implementing the slony example scripts, however,
> > > when I try to implement a second slave, the script fails.
> > >     
> > More information please.  What point does it fail at?  How does it 
> > fail?  What error message(s) do you see?
> > 
> >   
> > > Does anyone have a short example script for this simple replication?
> > > 
> > >     
> > It would be better if you could post your script, and we could point out 
> > what's wrong with it.
> I have attached the script once again for review:
> 

The script fails at the following line:
> 
> store node (id=3, comment = 'Rep Slave2 node');
> 
> It fails with:
> [postgres at slv postgres]$ ./slony_multi_slave.sh
> <stdin>:105: loading of file /usr/local/pgsql/share//xxid.v74.sql:
> PGRES_FATAL_ERROR ERROR:  current transaction is aborted, commands
> ignored until end of transaction block
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block 

This is NOT THE ERROR you are looking for.
Note a couple of things here...

1:  Once PostgreSQL gets one error in a transaction, everything after
that is ignored until rollback.  That's the error you're posting.  That
means there's an error from before this that's your problem.

2:  You are getting line numbers (the :105: up there).  So, read your
file with line numbering of some kind (on unix "cat -n filename" will
add line numbers to the front of each line).  Then, look for the FIRST
error message you get and look it up by the line number in that file.

Let us know what you find.