initdb on build machine and moving to production machine

From: oberpwd(at)anubis(dot)network(dot)com (Wade D(dot) Oberpriller)
To: pgsql-general(at)postgresql(dot)org (general-help postgresql)
Subject: initdb on build machine and moving to production machine
Date: 2001-01-11 22:28:40
Message-ID: 200101112228.QAA17982@truck.network.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I want to be able to do an initdb on a build machine and then copy this new
database to a production machine and run with it. One thing I have noticed is
that initdb needs an absolute path, so if I copy the database it needs to
reside in an identical location as where it was initialized.

The problem is my build machine and production machines don't have the same
directory structures. One solution I was considering was to create an
alternative path through symbolic links to my directory where I do the initdb
on the build machine. This alternative path would match the path that the
db will reside in on the production machines.

Is there anyway to overcome this, that is can a database be initialized and
copied to another locationa and still work?

Wade Oberpriller
StorageTek
oberpwd(at)network(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alfred Perlstein 2001-01-11 22:38:44 Re: Re: Loading optimization
Previous Message Mikheev, Vadim 2001-01-11 22:10:24 RE: Re: Loading optimization