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 E33D05640D for ; Thu, 24 Feb 2005 04:35:12 +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 75708-05 for ; Thu, 24 Feb 2005 04:35:03 +0000 (GMT) Received: from web50703.mail.yahoo.com (web50703.mail.yahoo.com [206.190.38.101]) by svr1.postgresql.org (Postfix) with SMTP id 54F97563AC for ; Thu, 24 Feb 2005 04:35:02 +0000 (GMT) Received: (qmail 41447 invoked by uid 60001); 24 Feb 2005 04:35:07 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=4cxn9jqVt7jXukFp0kF1Y/+XNEdPebg3MxdboB+LLOdGOvnaqARNX8l+I3rFq1FCQ+wCLVWWUl8ia01ACgPl6ueEJk4tiigfIGkOaip7FYHuMjvcIIxcyG3AyOlL0O7/qp4pFICH/up/R3NvHIjoMcL4vo//GrvIdc7kEtPNf6M= ; Message-ID: <20050224043507.41445.qmail@web50703.mail.yahoo.com> Received: from [60.48.146.106] by web50703.mail.yahoo.com via HTTP; Wed, 23 Feb 2005 20:35:06 PST Date: Wed, 23 Feb 2005 20:35:06 -0800 (PST) From: JinNet Picker Subject: CVS Database To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1020763483-1109219706=:40507" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.879 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_20_30, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200502/276 X-Sequence-Number: 16444 --0-1020763483-1109219706=:40507 Content-Type: text/plain; charset=us-ascii Hi, I am using Postgres database for my Application. All my developers will be updating the database during development, i.e like Adding a New Field, Drop Field, Add Records etc things. The main database will be on Server, My question is , Question 1: If i want to update the database which is on Production Server, i am dropping that first and taking export of Development Server database.. and then i am creating Same database on Production Server with this export. Is there any facility or tool that Logs (with Statements i.e ALTER, INSERT etc ) the changes to my Development Server database ? If this available, i can just take from that Log file and i can update the Production Server database. Question 2: Some of my clients request for MySql database, is there anytoll that can convet the Postgres Database to MySql Database? Any help? Thanks Jen __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --0-1020763483-1109219706=:40507 Content-Type: text/html; charset=us-ascii
Hi,
 
I am using Postgres database for my Application.
 
All my developers will be updating the database during development, i.e like Adding a New Field, Drop Field, Add Records etc things.
 
The main database will be on Server, My question is ,
 
Question 1:
If i want to update the database which is on Production Server, i am dropping that first and taking export of Development Server database.. and then i am creating Same database on Production  Server with this export. Is there any facility or tool that Logs (with Statements i.e ALTER, INSERT etc ) the changes to my Development Server database ? If this available, i can just take from that Log file and i can update the Production Server database.
 
Question 2:
Some of my clients request for MySql database, is there anytoll that can convet the Postgres Database to MySql Database?
 
Any help?
 
Thanks
Jen
 
 
 

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com --0-1020763483-1109219706=:40507--