On November 26, 2004 01:40 pm, Glen Eustace wrote:
> I am trying to setup slony-1 and need some off list assistance from
> someone who has got things going ( or at least knows more than me :-).
>
> I am running 7.4.6 on both master and slave but when I run the slonik
> script, I get the error.
>
> <stdin>:5: Initializing the cluster
> <stdin>:7: PGRES_FATAL_ERROR create schema "_GZ"; - ERROR:  permission
> denied for database admin
> <stdin>:9: Could not initialize the cluster!
>
> I am using a 'slony' user which has createdb rights but the database
> admin was created by a different user.
>
> Any assistance, as always, much appreciated.

Is the slony user a super user on both nodes, and is pg_hba.conf properly 
configured to allow the slony user access to the db's on both nodes ?

-- 
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx:  250.763.1759
http://www.wavefire.com