Received: from clio.trends.ca (root@clio.trends.ca [209.47.148.2]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA69953 for ; Sat, 8 Jan 2000 01:08:28 -0500 (EST) (envelope-from cgriffin@websales.com) Received: from websales.com (websales.com [192.153.125.97]) by clio.trends.ca (8.9.3+Sun/8.9.3) with ESMTP id BAA24715 for ; Sat, 8 Jan 2000 01:03:01 -0500 (EST) Received: from [207.67.207.131] (webcc-isdn-131.webcc.net [207.67.207.131]) by websales.com (8.9.3/8.8.5) with ESMTP id WAA07671 for ; Fri, 7 Jan 2000 22:08:52 -0800 User-Agent: Microsoft Outlook Express Macintosh Edition - 5.0 (1513) Date: Fri, 07 Jan 2000 22:02:33 -0800 Subject: createdb -D xxxx not working From: Chris Griffin To: Message-ID: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit This is a transcript of what I am trying: # setenv PGDATA2 /web/sites/1.192/db-data # initlocation PGDATA2 initlocation: input argument points to /web/sites/1.192/db-data We are initializing the database area with username root (uid=0). This user will own all the files and must also own the server process. Creating Postgres database system directory /web/sites/1.192/db-data Creating Postgres database system directory /web/sites/1.192/db-data/base # createdb -D PGDATA2 ERROR: Unable to locate path 'PGDATA2/root' This may be due to a missing environment variable in the server createdb: database creation failed on root.