pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
CVS Database 2+ messages / 2 participants [nested] [flat]
* CVS Database @ 2005-02-24 04:35 JinNet Picker <netpicker9@yahoo.com> 0 siblings, 1 reply; 2+ messages in thread From: JinNet Picker @ 2005-02-24 04:35 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: CVS Database @ 2005-02-24 15:43 Scott Marlowe <smarlowe@g2switchworks.com> parent: JinNet Picker <netpicker9@yahoo.com> 0 siblings, 0 replies; 2+ messages in thread From: Scott Marlowe @ 2005-02-24 15:43 UTC (permalink / raw) To: JinNet Picker <netpicker9@yahoo.com>; +Cc: pgsql-admin On Wed, 2005-02-23 at 22:35, JinNet Picker wrote: > 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. You could configure postgresql to log every statement (look in the $PGDATA/postgresql.conf file, it's in the logging section.) And then just filter the logs for alter / drop / create statements... > Question 2: > Some of my clients request for MySql database, is there anytoll that > can convet the Postgres Database to MySql Database? None that I'm familiar with. But if the databases are pretty simple, it shouldn't be that hard. Do they really need MySQL or are they just more familiar with it? It might behoove them and you to stick to postgresql. I find that it's easy to outgrow MySQL's limitations as you learn more about databases and relational theory. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-02-24 15:43 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-02-24 04:35 CVS Database JinNet Picker <netpicker9@yahoo.com> 2005-02-24 15:43 ` Scott Marlowe <smarlowe@g2switchworks.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox