Database Migration - Mailing list pgsql-novice

From
Subject Database Migration
Date
Msg-id 20050909234934.92835.qmail@web33301.mail.mud.yahoo.com
Whole thread Raw
List pgsql-novice
Hi All,

i'm facing a db / data migration issue.  i have 3 dbs.

my dev box is pgsql 7.4.6 (laptop, winxp / cygwin)
my current production box is 7.3.x (webhost, linux)
my new production box is 8.03 (in-house, linux)

my dev db is waaaay ahead of my production db b/c i
had to code a lot of pages to include some
functionality.

i'm thinking about doing this two ways.

1. dump my table structures from my dev box and then
fill it with data from the 7.3.x production db and
hope there are are no glitches.
2. build the pgsql 8.03 from scratch and then fill it
with data from the 7.3.x production db and hope there
are are no glitches.

do these options sound reasonable?  will 7.4.6 data
types conflict with 8.03 data types?

tia...

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: Weird SQL Problem
Next
From: "Peter Schonefeld"
Date:
Subject: inserting non-ascii characters