X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 781BE529B8 for ; Wed, 20 Jul 2005 11:32:43 -0300 (ADT) 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 87959-02 for ; Wed, 20 Jul 2005 14:32:40 +0000 (GMT) Received: from vms048pub.verizon.net (vms048pub.verizon.net [206.46.252.48]) by svr1.postgresql.org (Postfix) with ESMTP id 7FD1C52943 for ; Wed, 20 Jul 2005 11:32:39 -0300 (ADT) Received: from jfradkin ([66.15.127.235]) by vms048.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0IJX00LUIKEH9454@vms048.mailsrvcs.net> for pgsql-admin@postgresql.org; Wed, 20 Jul 2005 09:32:42 -0500 (CDT) Date: Wed, 20 Jul 2005 10:33:53 -0400 From: "Joel Fradkin" Subject: Re: Determine PG version used for initdb In-reply-to: <15725.1121868322@sss.pgh.pa.us> To: "'Tom Lane'" , "'Dario'" Cc: "'Hannes Dorbath'" , Message-id: <002801c58d38$0e1ca350$797ba8c0@jfradkin> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.836 tagged_above=0 required=5 tests=AWL, MSGID_DOLLARS X-Spam-Level: ** X-Archive-Number: 200507/160 X-Sequence-Number: 18216 Not being a postgres guru can you give me a simple plan to follow to re = init db. I am running on linux redhat as4. I have links to spindles for my wal and my data. I am on 8.0.3, but did not initdb the database, so security issues have = not been addressed. I can do a dump, initdb (this is where I am not 100% sure what to do, to = get rid of the existing intdb stuff) and do a restore. I am guessing I would just stop postgres delete the data folder in /var/lib/pgsql. Go into the pgsql folder and do a initdb database name? prefer to do it Unicode if I can get my drivers and such figured and tested (still = having serious issues there). Re-link the wal and base folders And I am done? What would be the exact syntax for the initdb command? Joel Fradkin =20 Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 =20 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. =20 =20 -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Tom Lane Sent: Wednesday, July 20, 2005 10:05 AM To: Dario Cc: Hannes Dorbath; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Determine PG version used for initdb=20 > That tells the server version running, but does it tell the initdb > binary version used to init the cluster? Normally there's not any difference between dot-release initdb's. In this case there is; read the 8.0.3 release notes: http://developer.postgresql.org/docs/postgres/release.html#RELEASE-8-0-3 You could determine which was used by looking at the declared arguments of the conversion functions. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings