pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tim Perdue, Directricity.com <tim@directricity.com>
To: pgsql-sql@hub.org
Subject: Moving Database -> New Disk
Date: Fri, 12 Feb 1999 22:45:32 -0600
Message-ID: <002a01be570b$b0bd10f0$0b8c5aa5@timnt.weather.net> (raw)

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




view thread (3+ messages)  latest in thread

Message-ID: <002a01be570b$b0bd10f0$0b8c5aa5@timnt.weather.net>
Permalink:  ../002a01be570b$b0bd10f0$0b8c5aa5@timnt.weather.net/
Also on:    postgresql.org/message-id/002a01be570b$b0bd10f0$0b8c5aa5@timnt.weather.net

 · 

reply

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: tim@directricity.com, pgsql-sql@hub.org
  Subject: Re: Moving Database -> New Disk
  In-Reply-To: <002a01be570b$b0bd10f0$0b8c5aa5@timnt.weather.net>
  References: <002a01be570b$b0bd10f0$0b8c5aa5@timnt.weather.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