Skip site navigation (1) Skip section navigation (2)

Database Migration

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Database Migration
Date: 2005-09-09 23:49:34
Message-ID: 20050909234934.92835.qmail@web33301.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: 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 

Responses

pgsql-novice by date

Next:From: Peter SchonefeldDate: 2005-09-10 03:30:26
Subject: inserting non-ascii characters
Previous:From: operationsengineer1Date: 2005-09-08 22:03:44
Subject: Re: Weird SQL Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group