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
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?
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
pgsql-novice by date
|Next:||From: Peter Schonefeld||Date: 2005-09-10 03:30:26|
|Subject: inserting non-ascii characters|
|Previous:||From: operationsengineer1||Date: 2005-09-08 22:03:44|
|Subject: Re: Weird SQL Problem|