| From: | Glen Eustace <geustace(at)godzone(dot)net(dot)nz> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Problems setting up slony-1 |
| Date: | 2004-11-26 20:43:43 |
| Message-ID: | 1101501823.20980.20.camel@agree-6 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keary Suska | 2004-11-26 20:58:06 | Re: Inserting greek letters |
| Previous Message | Tom Lane | 2004-11-26 19:06:52 | Re: Query on exception handling in PL/pgSQL |