dbTalk Databases Forums  

[BUGS] initdb: directory not empty issue

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] initdb: directory not empty issue in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jeffrey Quinn
 
Posts: n/a

Default [BUGS] initdb: directory not empty issue - 01-30-2004 , 02:02 PM






Hi,

Don't know if this is a bug or more of a feature request, but here goes:
It would appear that by default initdb refuses to configure a database
within a directory that already contains files/directories. I understand
that this is desirable in most cases.

The problem, however, is that this will fail if I am trying to enable a
separate filesystem as the data location. It's rather annoying to have
to remove a lost+found directory (or other files), init the db, and then
remake lost+found (and restore other files). How about a --force
flag? I reckon if an admin is willing to type out that, s/he can take
the responsibility of the consequences.

And of course: fantastic work on release 7.4, and postgreSQL in general!

Cordially,
Jeff Quinn

--
-----------------------------------------------------------
Jeffrey Quinn jquinn (AT) cs (DOT) usfca.edu
Shaman | UNIX Journeyman http://cs.usfca.edu/~jquinn
-----------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: [BUGS] initdb: directory not empty issue - 01-30-2004 , 06:58 PM






Jeffrey Quinn <jquinn (AT) cs (DOT) usfca.edu> writes:
Quote:
The problem, however, is that this will fail if I am trying to enable a
separate filesystem as the data location. It's rather annoying to have
to remove a lost+found directory (or other files), init the db, and then
remake lost+found (and restore other files). How about a --force
flag?
Why not create a /data directory just below the filesystem root, and use
that?

I believe it's generally considered that root should own filesystem
mount points, so using a filesystem root directory directly as the PG
data directory seems like bad practice.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.