Обсуждение: Problems getting rserv working properly
-----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-----
frampton@linuxninja.com writes: >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 Try this. ./Replicate --snapshot=/tmp/__Snapshot testmaster testslave It could be a permission problem. sherwin
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
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello: Thanks to Sherwin for the following tip. I didn't even notice this response for the past several weeks (didn't seem to hit the groups.google.com thread either -- strange), and when I saw it yesterday I tried it, and it solved my problem. On Fri, 21 Sep 2001, pgsql-admin wrote: > >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 > > Try this. > > ./Replicate --snapshot=/tmp/__Snapshot testmaster testslave > > It could be a permission problem. - ---------------< 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 iD8DBQE7vWR7mnLx9dBV68URAtakAJ416cEAKab3R/0kymGKpjipvfwumgCfXsP4 WnBhgTtplebPj6AXUoCFKcM= =NLlg -----END PGP SIGNATURE-----
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello: I am constructing a billing system using PostgreSQL, ODBC, and C++. I have a primary database set up on a beefy server which is fed 24/7 by a transaction feeder, and is also used for processing the billing. I have a 2nd server which is being used as a hot backup server, which is also being fed by the transaction feeder. However, billing processing does not run through the feeder, so I find myself doing a daily dump on the appropriate tables on the production server, deleting the old data from the backup, and importing with copy from. Needless to say, RServ would be a better solution for this. I'm not sure how I would set up RServ to access a remote database, however. Is this possible? Also, I would like to provide the ability for users to look up their billing data via a CGI interface, which would perform queries to yet another server, to be set up for R/O access only (for performance, and security). I was thinking of using RServ for this purpose as well, but an even better solution seems to be to run my production (or backup mirror) from a NetApp over Gb NFS so there's no issues with replication. Is it possible, safe, and advisable to share a PostgreSQL database file via NFS, as long as non-masters are only accessing it R/O? Thank you in advance for your advice. - ---------------< 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 iD8DBQE7vWY3mnLx9dBV68URAnQ0AJ92iZAsLkwcmtq8AzOK9NVoiZZT2gCeMHEz 3CZfmNcKahm67S6gfNtWX2k= =JVfy -----END PGP SIGNATURE-----