pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <smarlowe@g2switchworks.com>
To: JinNet Picker <netpicker9@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: CVS Database
Date: Thu, 24 Feb 2005 09:43:23 -0600
Message-ID: <1109259803.30529.176.camel@state.g2switchworks.com> (raw)
In-Reply-To: <20050224043507.41445.qmail@web50703.mail.yahoo.com>
References: <20050224043507.41445.qmail@web50703.mail.yahoo.com>

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.



view thread (2+ messages)

Message-ID: <1109259803.30529.176.camel@state.g2switchworks.com>
Permalink:  ../1109259803.30529.176.camel@state.g2switchworks.com/
Also on:    postgresql.org/message-id/1109259803.30529.176.camel@state.g2switchworks.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: smarlowe@g2switchworks.com, netpicker9@yahoo.com
  Subject: Re: CVS Database
  In-Reply-To: <1109259803.30529.176.camel@state.g2switchworks.com>
  References: <20050224043507.41445.qmail@web50703.mail.yahoo.com> <1109259803.30529.176.camel@state.g2switchworks.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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