From: "Joel Fradkin" <jfradkin@wazagua.com>
To: <pgsql-sql@postgresql.org>
Subject: postgres 8 data directory other then default?
Date: Thu, 10 Feb 2005 14:48:47 -0500
Message-ID: <000701c50fa9$89ea4ad0$797ba8c0@jfradkin>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I am trying to use a different drive for the data.
I have edited postgres.conf to point to the new location, but I get the
error /pgdata/PG_VERSION is missing.
Do I have to do a initdb?
When I try an initdb it says it is not empty. (has lost and found folder =
in
it).
Fedora Core 3 linux.
I was able to do an init db if I create a folder called data in the =
pgdata,
but I was not sure if it then would use that folder for all the files (I
just want my data to be there).
I also want to move my wal files to the /wal drives once I get it to =
start
using pgdata drive for data.
=A0
I got some info on this
0) backup your data
1) stop postmaster and verify.
2) cd $PGDATA; mv pg_xlog original_pg_xlog; ln -s /wal pg_xlog; cp=20
original_pg_xlog/* pg_xlog
3) start postmaster and confirm correct startup in log files.
=A0
Will this work? I am guessing this info would be in the var/lib folder =
not
the /pgdata folder?
Thanks in advance and sorry for asking so many dumb newb questions.
Least this time the install of 8 went super smooth, just went to the
postgres site and got the rpm=92s (Since I did not install 7 with the OS =
it
asked for the fedora cd=92s a few times but all rpm=92s went ok).
=A0
On the 8.1 files which are in tar files do I need to get those as well =
to
get to 8.1 if so what is the procedure other then copying the files to =
my
system (I have the .tar.bz)
=A0
=A0
Joel Fradkin
=A0
Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.=A0 941-753-7111 ext 305
=A0
jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
=A9 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA,=A0Inc
=A0This email message is for the use of the intended recipient(s) and =
may
contain confidential and privileged information.=A0 Any unauthorized =
review,
use, disclosure or distribution is prohibited.=A0 If you are not the =
intended
recipient, please contact the sender by reply email and delete and =
destroy
all copies of the original message, including attachments.
=A0

=A0
=A0