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

Re: [SQL] Moving Database -> New Disk

From: Fabrice Scemama <fabrice(dot)scemama(at)gesnet(dot)net>
To: "Tim Perdue, Directricity(dot)com" <tim(at)directricity(dot)com>
Cc: pgsql-sql(at)hub(dot)org
Subject: Re: [SQL] Moving Database -> New Disk
Date: 1999-02-14 00:17:41
Message-ID: 36C61625.624E56A6@gesnet.net (view raw or flat)
Thread:
Lists: pgsql-sql
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



In response to

pgsql-sql by date

Next:From: Kim MarkleDate: 1999-02-14 16:29:50
Subject: RE: [SQL] connection timeout?
Previous:From: Michael ScheunerDate: 1999-02-13 18:33:04
Subject: replace missing

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