Problems setting up slony-1
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.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 5301
Ph/Fax: +64 6 357 8168, Mob: +64 27 5 424 015, Web: www.godzone.net.nz
"A Ministry specialising in providing low-cost professional Internet
Services to NZ Christian Churches, Ministries and Organisations"
A long time ago, in a galaxy far, far away, geustace@godzone.net.nz (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.
The problem likely falls into one of two things:
a) pg_hba.conf is configured to deny access from the host you are
running slonik on;
b) The 'slony' user is not a superuser which, it is quite clearly
documented, it must be...
--
(reverse (concatenate 'string "gro.mca" "@" "enworbbc"))
<http://cbbrowne.dyndns.info:8741/cgi-bin/twiki/view/Sandbox/SlonyIAdministration>
Outside of a dog, a book is man's best friend. Inside of a dog, it's
too dark to read. -Groucho Marx