X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9CA2E8B9EFE for ; Thu, 10 Feb 2005 19:44:05 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 93080-09 for ; Thu, 10 Feb 2005 19:43:34 +0000 (GMT) Received: from out014.verizon.net (out014pub.verizon.net [206.46.170.46]) by svr1.postgresql.org (Postfix) with ESMTP id 736758B9EA2 for ; Thu, 10 Feb 2005 19:43:34 +0000 (GMT) Received: from jfradkin ([66.15.127.235]) by out014.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20050210194333.CLWI28388.out014.verizon.net@jfradkin> for ; Thu, 10 Feb 2005 13:43:33 -0600 From: "Joel Fradkin" To: Subject: postgres 8 data directory other then default? Date: Thu, 10 Feb 2005 14:47:07 -0500 Message-ID: <000201c50fa9$4ec1f1b0$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0003_01C50F7F.65EBE9B0" X-Authentication-Info: Submitted using SMTP AUTH at out014.verizon.net from [66.15.127.235] at Thu, 10 Feb 2005 13:43:32 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.191 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE, MSGID_DOLLARS X-Spam-Level: *** X-Archive-Number: 200502/128 X-Sequence-Number: 20239 This is a multi-part message in MIME format. ------=_NextPart_000_0003_01C50F7F.65EBE9B0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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. 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 original_pg_xlog/* pg_xlog 3) start postmaster and confirm correct startup in log files. 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's (Since I did not install 7 with the OS it asked for the fedora cd's a few times but all rpm's went ok). 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) Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. 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. ------=_NextPart_000_0003_01C50F7F.65EBE9B0 Content-Type: text/html; charset="us-ascii" 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.

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

original_pg_xlog/* = pg_xlog

3) start postmaster = and confirm correct startup in log files.

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’s (Since I did not = install 7 with the OS it asked for the fedora cd’s a few times but all = rpm’s went ok).

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)

Joel Fradkin

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida = 34243
Tel. 941-753-7111 ext 305

jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced = tools.
© 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
This email message is for the use of the intended recipient(s) and = may contain confidential and privileged information. Any unauthorized = review, use, disclosure or distribution is prohibited. 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.

------=_NextPart_000_0003_01C50F7F.65EBE9B0--