From: | "Karen Ellrick" <k-ellrick(at)sctech(dot)co(dot)jp> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Problems with new data location |
Date: | 2001-05-29 09:39:19 |
Message-ID: | GAELLCMOCEGMDMHDMIILMEFLCIAA.k-ellrick@sctech.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
--------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | zilch | 2001-05-29 09:46:22 | Get status of connection (C) |
Previous Message | Patrik Kudo | 2001-05-29 08:13:35 | Re: Disk space usage with PostgreSQL |