Problems getting rserv working properly

Lists: pgsql-admin
From: Steve Frampton <frampton(at)LinuxNinja(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Problems getting rserv working properly
Date: 2001-09-21 09:54:28
Message-ID: Pine.LNX.4.33.0109210437570.20223-100000@astro.phpwebhosting.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

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

Hello:

I am trying to get rserv working, so that I can do replication between a
master and a slave DB. I seem to be getting an error when I attempt
replication:

./Replicate testmaster testslave

>>>>>>>>>>>>> ERROR

Hmmm. Anyway, I attempted to get replication working by doing the
following:

MasterInit testmaster
SlaveInit testslave
MasterAddTable testmaster test id
SlaveAddTable testslave test id
Replicate testmaster testslave

(above error)

MasterAddTable testmaster test name
MasterAddTable testmaster test age
SlaveAddTable testslave test name
SlaveAddTable testslave test age
Replicate testmaster testslave

(Same error).

Any idea as to what kind of error this is? I am doing everything as the
postgres user.

Also, does enabling replication put much of a load on the master DB? I
would rather avoid slowing down my DB as much as possible. If this is a
factor, perhaps I should just do an n-daily dump of the DB and import it
on the replica. (Asynchronous updates ala rserv would be so, so much
better, however.)

Thanks in advance...

- ---------------< LINUX: The choice of a GNU generation. >-------------
Steve Frampton <frampton(at)LinuxNinja(dot)com> http://www.LinuxNinja.com
GNU Privacy Guard ID: D055EBC5 (see http://www.gnupg.org for details)
GNU-PG Fingerprint: EEFB F03D 29B6 07E8 AF73 EF6A 9A72 F1F5 D055 EBC5
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.0 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7qw5XmnLx9dBV68URAnYpAKCI0Fme4KvVHJedvlxdKNiat1yZZwCfc6si
iy2SLg04iLzxCSWrz/wjbCg=
=PPg4
-----END PGP SIGNATURE-----


From: Justin Clift <justin(at)postgresql(dot)org>
To: Steve Frampton <frampton(at)LinuxNinja(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problems getting rserv working properly
Date: 2001-09-22 13:07:14
Message-ID: 3BAC8D02.3B817D9@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

Hi Steve,

Not sure if it'll help, but there's a HOWTO for getting rServ with
PostgreSQL 7.0.3 at :

http://techdocs.postgresql.org/techdocs/settinguprserv.php

Not sure if you've seen it already or not.

Regards and best wishes,

Justin Clift

Steve Frampton wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello:
>
> I am trying to get rserv working, so that I can do replication between a
> master and a slave DB. I seem to be getting an error when I attempt
> replication:
>
> ./Replicate testmaster testslave
>
> >>>>>>>>>>>>> ERROR
>
> Hmmm. Anyway, I attempted to get replication working by doing the
> following:
>
> MasterInit testmaster
> SlaveInit testslave
> MasterAddTable testmaster test id
> SlaveAddTable testslave test id
> Replicate testmaster testslave
>
> (above error)
>
> MasterAddTable testmaster test name
> MasterAddTable testmaster test age
> SlaveAddTable testslave test name
> SlaveAddTable testslave test age
> Replicate testmaster testslave
>
> (Same error).
>
> Any idea as to what kind of error this is? I am doing everything as the
> postgres user.
>
> Also, does enabling replication put much of a load on the master DB? I
> would rather avoid slowing down my DB as much as possible. If this is a
> factor, perhaps I should just do an n-daily dump of the DB and import it
> on the replica. (Asynchronous updates ala rserv would be so, so much
> better, however.)
>
> Thanks in advance...
>
> - ---------------< LINUX: The choice of a GNU generation. >-------------
> Steve Frampton <frampton(at)LinuxNinja(dot)com> http://www.LinuxNinja.com
> GNU Privacy Guard ID: D055EBC5 (see http://www.gnupg.org for details)
> GNU-PG Fingerprint: EEFB F03D 29B6 07E8 AF73 EF6A 9A72 F1F5 D055 EBC5
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.0 (GNU/Linux)
> Comment: For info see http://www.gnupg.org
>
> iD8DBQE7qw5XmnLx9dBV68URAnYpAKCI0Fme4KvVHJedvlxdKNiat1yZZwCfc6si
> iy2SLg04iLzxCSWrz/wjbCg=
> =PPg4
> -----END PGP SIGNATURE-----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi