Problems with new data location
От | Karen Ellrick |
---|---|
Тема | Problems with new data location |
Дата | |
Msg-id | GAELLCMOCEGMDMHDMIILMEFLCIAA.k-ellrick@sctech.co.jp обсуждение исходный текст |
Ответы |
Re: Problems with new data location
|
Список | pgsql-general |
Right after a new installation (7.1.1) and building my first table with the data directory being the normal /usr/local/pgsql/data, I decided I wanted to put my data directory on a different partition, for space reasons (room for database growth) - I chose /var/pgdata. At first I tried just copying the whole data directory, but I got some sort of error (I don't remember it now). Then I tried creating /var/pgdata fresh and doing initdb -D /var/pgdata, and that was okay until I tried to create the database again, when it said a database of that name already existed. Yes, I have changed my startup script to reflect the new path. The next thing I tried was to change the name of /usr/local/pgsql/data to /usr/local/pgsql/data.old (to hide it), erase the stuff in /var/pgdata, and then go through the initdb, pg_ctl, createdb process again. Now createdb complains: pgsql: Missing or erroneous pg_hba.conf file, see postmaster log for details createdb: database creation failed I have a perfectly good /var/pgdata/pg_hba.conf file. Is it still looking for stuff in /usr/local/pgsql/data? How can I determine where it is looking? I don't where the "postmaster log" is - the log file I specify with pg_ctl -l (/var/pgdata/serverlog) is not showing anything about this (just one older error about a lock file). What is the right way to move a data directory or to start over with a new one? (It would be gravy to keep my already created database, but starting over is no big deal - there is no data in it yet.) Thanks for your help. -------------------------------- Karen Ellrick S & C Technology, Inc. 1-21-35 Kusatsu-shinmachi Hiroshima 733-0834 Japan (from U.S. 011-81, from Japan 0) 82-293-2838 --------------------------------
В списке pgsql-general по дате отправления: