X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BB8A43A4668 for ; Thu, 20 Jan 2005 05:58:01 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25085-02 for ; Thu, 20 Jan 2005 05:57:57 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 9446F3A4603 for ; Thu, 20 Jan 2005 05:57:56 +0000 (GMT) Received: from [192.168.1.20] (clbb-248.saw.net [64.146.135.248]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j0K5vsa8002399; Wed, 19 Jan 2005 21:57:54 -0800 Message-ID: <41EF4867.8000907@commandprompt.com> Date: Wed, 19 Jan 2005 21:57:59 -0800 From: "Joshua D. Drake" User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Theo Galanakis Cc: pgsql-admin@postgresql.org Subject: Re: Command prompt replication. References: In-Reply-To: Content-Type: multipart/mixed; boundary="------------010004060105000200050907" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.027 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/206 X-Sequence-Number: 16065 This is a multi-part message in MIME format. --------------010004060105000200050907 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Theo Galanakis wrote: > I also should add.... > > This is the results of slave_stat when running on the slave, this > looks peculiar: Hello, O.k. something is not right. Could you please post a request to support@commandprompt.com with the following information: 1. master postgresql.conf replication configuration, we don't need the whole postgresql.conf 2. slave postgresql.conf replication configuration, we don't need the whole postgresql.conf 3. The schema of the table you are inserting into 4. The schema of the table that is supposed to be recieving the updates. Thanks. Joshua D. Drake Command Prompt, Inc. > > /usr/local/pgsql/bin/slave_stat /usr/local/pgsql/mcp_data 0 > Sync: DESYNC > First record in queue: 0 > Last received record: 0 > Last restored record: 0 > > -----Original Message----- > *From:* Theo Galanakis > *Sent:* Thursday, 20 January 2005 2:09 PM > *To:* pgsql-admin@postgresql.org > *Subject:* [ADMIN] Command prompt replication. > > Hi, > I'm evaluating command prompts replication server and have > an issue I need help to resolve. > > I have install the master and slave from the postgres code > supplied from command prompt. Have created a benchpg database > which is automatically created by the contrib program, pg_bench. > Then proceeded to copy that database to the slave via pg_dump, etc... > > Im currently running both databases on separate servers. > And I have started up : > > /usr/local/pgsql/bin/mcp_server -c > /usr/local/pgsql/etc/mcp_server.conf -l /var/log/mcp_server.log & > > Based on the output both pg servers connect to the mcp > server successfully.. > > Ok.. > > Not testing the replication by inserting a record into the > master database table branches. > > As soon as I enter this record /var/log/mcp_server.log is > populated with : > > > DEBUG_MSG: MCP-M-Recv| recno: 16003065 txnid: 85 datalen: > 25 flags: TABLE_BEGIN TABLE_LIST TABLE_END > > DEBUG: Store master tables list in > /usr/local/pgsql/mcp_data/txlog_mcp_master_table_list > DEBUG_MSG: MCP-M-Recv| recno: 16003066 txnid: 86 > datalen: 4 flags: TXBEGIN DATA > > DEBUG_MSG: MCP-M-Recv| recno: 16003067 txnid: 86 > datalen: 4 flags: DATA > > DEBUG_MSG: MCP-M-Recv| recno: 16003068 txnid: 86 datalen: > 44 flags: DATA > > DEBUG_MSG: MCP-M-Recv| recno: 16003069 txnid: 86 datalen: > 12 flags: DATA > > DEBUG_MSG: MCP-M-Recv| recno: 16003070 txnid: 86 datalen: > 16 flags: DATA > > DEBUG_MSG: MCP-M-Recv| recno: 16003071 txnid: 86 > datalen: 4 flags: DATA TXEND > > DEBUG_MASTER: MCP Receive TXEND => mcp_ack_recno: 16003071 > DEBUG_MASTER: MCP Send ACK to Master => ACK reco: 16003071, > mcp_ack_recno = 0 > DEBUG_MSG: MCP-M-Send| recno: 16003071 txnid: 0 > datalen: 0 flags: !ACK > > DEBUG_SLAVE: 0: TABLE_LIST => SKIP recno: 16003065 > DEBUG_SLAVE: MCP Send TXBEGIN to Slave(0) > DEBUG_SLAVE: MCP send TXEND to Slave(0) > DEBUG_SLAVE: 0, Send INCSKIP > DEBUG_MSG: MCP-S(0)-Send| recno: 16003071 txnid: 86 > datalen: 4 flags: DATA TXEND > > DEBUG_MSG: MCP-S(0)-Recv| recno: 16003071 txnid: 0 > datalen: 0 flags: !ACK > > DEBUG_SLAVE: 0: Recv ACK from Slave(0) => Slave(0).vrecno = 16003071 > > > On the slave server the /var/log/postgresql.log is polutated with > this: > > LOG: INCSKIP to 16003071 > LOG: SET mcp_ack_recno: 16003071 > > Based on my limited knowledge and little documentation provided by > command prompt, all looks well??? However the record I added to > the master has not been copied to the slave. > > Regards, > Theo > > ______________________________________________________________________ > This email, including attachments, is intended only for the addressee > and may be confidential, privileged and subject to copyright. If you > have received this email in error, please advise the sender and delete > it. If you are not the intended recipient of this email, you must not > use, copy or disclose its content to anyone. You must not copy or > communicate to others content that is confidential or subject to > copyright, unless you have the consent of the content owner. > -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL --------------010004060105000200050907 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard --------------010004060105000200050907--