Re: [Q] createdb for existing directory - Mailing list pgsql-general

From Alfred Perlstein
Subject Re: [Q] createdb for existing directory
Date
Msg-id 20001016114228.L272@fw.wintelcom.net
Whole thread Raw
In response to [Q] createdb for existing directory  ("Roderick A. Anderson" <raanders@altoplanos.net>)
Responses Re: [Q] createdb for existing directory  ("Roderick A. Anderson" <raanders@altoplanos.net>)
List pgsql-general
* Roderick A. Anderson <raanders@altoplanos.net> [001016 11:38] wrote:
> Typically when I want to place a database on a different partition I
> create it then copy all the stuff from the new databases directory(s) to
> the new partition followed by a mount.  I check things out and then
> unmount the partition remove all the stuff in the database directories,
> remount, and then update /etc/fstab for the system.
>
>    Seems to work but it is a kludgy method to do it.  What I'd like to do
> is mount the partition before doing a createdb.
>
> Will this work with 7.1?  (I'm writing up some instructions that I'd like
> to not have to change later.)

huh?  How are you copying to an unmounted partition?

Afaik you need the device node to be mounted before you can write to
it.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: dump vs dumpall
Next
From: Partyka Robert
Date:
Subject: Re: dump vs dumpall