From: Fabrice Scemama <fabrice.scemama@gesnet.net>
To: Tim Perdue, Directricity.com <tim@directricity.com>
Cc: pgsql-sql@hub.org
Subject: Re: [SQL] Moving Database -> New Disk
Date: Sun, 14 Feb 1999 00:17:41 +0000
Message-ID: <36C61625.624E56A6@gesnet.net> (raw)
References: <002a01be570b$b0bd10f0$0b8c5aa5@timnt.weather.net>
What about using a symlink ?
mv /usr/local/pgsql /fireball
ln -s /fireball/pgsql /usr/local/pgsql
Should do the whole trick.
Fabrice
"Tim Perdue, Directricity.com" wrote:
>
> I'm trying to do somethat that shouldn't be so darn difficult - moving a
> database to a new bigger disk.
>
> The database is db_domain at /usr/local/pgsq/data/base/db_domain
>
> I want it to reside on /fireball/pgsql/...
>
> I created a dump of db_domain and was able to do initdb on the new
> location - but when I try to createdb, of course db_domain is already taken.
> If I try to createdb using the -D switch I get an error about it not being
> able to find the directory (it's there).
>
> If I don't specify the -D switch, any new database is created under
> /usr/local/pgsql/data/base/, even though I restarted postmaster with -D
> pointing to /fireball/pgsql/....
>
> So Could someone give some specific instructions on moving db_domain over to
> the new hard disk? If there's a FAQ please give a full URL to find it.
>
> Tim
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-sql@postgresql.org
Cc: fabrice.scemama@gesnet.net, tim@directricity.com, pgsql-sql@hub.org
Subject: Re: [SQL] Moving Database -> New Disk
In-Reply-To: <36C61625.624E56A6@gesnet.net>
References: <002a01be570b$b0bd10f0$0b8c5aa5@timnt.weather.net> <36C61625.624E56A6@gesnet.net>
* 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