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 B44AB3A3CC1 for ; Mon, 25 Oct 2004 03:21:31 +0100 (BST) 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 00358-03 for ; Mon, 25 Oct 2004 02:20:52 +0000 (GMT) Received: from web90008.mail.scd.yahoo.com (web90008.mail.scd.yahoo.com [66.218.94.66]) by svr1.postgresql.org (Postfix) with SMTP id 86B033A3C66 for ; Mon, 25 Oct 2004 03:21:19 +0100 (BST) Message-ID: <20041025022126.38014.qmail@web90008.mail.scd.yahoo.com> Received: from [202.155.103.196] by web90008.mail.scd.yahoo.com via HTTP; Sun, 24 Oct 2004 19:21:26 PDT Date: Sun, 24 Oct 2004 19:21:26 -0700 (PDT) From: aditya s Subject: pgsql replicator To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=FORGED_YAHOO_RCVD X-Spam-Level: X-Archive-Number: 200410/316 X-Sequence-Number: 15309 Dear All My name is Yosi Aditya Sembada. recently I'm developing DRP with postgresql using postgresql replicator. After I have installed pgreplicator on my computer, I try to create a database replication with "createdbr" command. I'm having the following error when I execute this command [replicator@emware bin]$ ./createdbr test ...postgreSQL database test created ...test replica files created ...adding replica tables to database test... ...Done psql:/home/replicator/pgreplica/bin/Rlayout/create_RST.sql:23: ERROR: Type "datetime" does not exist psql:/home/replicator/pgreplica/bin/Rlayout/create_RST.sql:36: ERROR: Type "datetime" does not exist psql:/home/replicator/pgreplica/bin/Rlayout/create_RST.sql:107: ERROR: Type "datetime" does not exist psql:/home/replicator/pgreplica/bin/Rlayout/grant-revoke.sql:1: ERROR: Relation "pgr_monitor" does not exist psql:/home/replicator/pgreplica/bin/Rlayout/grant-revoke.sql:4: ERROR: Relation "pgr_monitor" does not exist psql:/home/replicator/pgreplica/bin/Rlayout/grant-revoke.sql:16: ERROR: Relation "pgr_monitor" does not exist psql:/home/replicator/pgreplica/bin/Rlayout/grant-revoke.sql:17: ERROR: Relation "pgr_monitor" does not exist After the database created, I try to run it with several commands in postgresql. After I create table named customers, I get the error again when I execute this command in postgresql test=# SELECT pgr_replica_table ('customers'); ERROR: Adding NOT NULL columns is not implemented. Add the column, then use ALTER TABLE ... SET NOT NULL. Anybody can give me a solution for these problems? For additional information, I use Postgresql 7.3.2 in Redhat Linux 9.0 Operating system. __________________________________ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail