Re: Problems getting rserv working properly

Поиск
Список
Период
Сортировка
От Justin Clift
Тема Re: Problems getting rserv working properly
Дата
Msg-id 3BAC8D02.3B817D9@postgresql.org
обсуждение исходный текст
Ответ на Problems getting rserv working properly  (Steve Frampton <frampton@LinuxNinja.com>)
Список 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@LinuxNinja.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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "pgsql-admin"
Дата:
Сообщение: how long backends stay connected
Следующее
От: david@netventures.com.au
Дата:
Сообщение: pg_dump, ERROR: More than one tuple returned