Received: from moran.grauel.com (usr1-17.mintel.net [63.81.123.32]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA48294 for ; Tue, 16 May 2000 11:24:42 -0400 (EDT) (envelope-from rjk@moran.grauel.com) Received: (from rjk@localhost) by moran.grauel.com (8.9.3/8.9.3) id KAA05636; Tue, 16 May 2000 10:25:48 -0500 (EST) (envelope-from rjk) From: Richard J Kuhns MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <14625.26748.356187.68826@localhost.grauel.com> Date: Tue, 16 May 2000 10:25:48 -0500 (EST) To: pgsql-general@postgresql.org Subject: Question about databases in alternate locations... X-Mailer: VM 6.75 under 21.1 (patch 8) "Bryce Canyon" XEmacs Lucid X-Archive-Number: 200005/37 Could anyone please tell me what I'm doing wrong? I'm sure I'm just overlooking something, but what? ====================== moran:/acct$ id uid=1007(postgres) gid=1003(postgres) groups=1003(postgres) moran:/acct$ export P=/acct/pindybook moran:/acct$ initlocation P The location will be initialized with username "postgres". This user will own all the files and must also own the server process. Fixing permissions on pre-existing directory /acct/pindybook Creating directory /acct/pindybook/base initlocation is complete. You can now create a database using CREATE DATABASE WITH LOCATION = 'P' in SQL, or createdb -D 'P' from the shell. moran:/acct$ createdb indybook -D 'P' ERROR: The database path 'P' is invalid. This may be due to a character that is not allowed or because the chosen path isn't permitted for databases createdb: database creation failed moran:/acct$ ls -ld pindybook drwx------ 3 postgres postgres 512 May 16 09:40 pindybook moran:/acct$ ls -l pindybook total 1 drwx------ 2 postgres postgres 512 May 16 09:40 base moran:/acct$ ====================== Thanks... -- Richard Kuhns rjk@grauel.com PO Box 6249 Tel: (765)477-6000 \ 100 Sawmill Road x319 Lafayette, IN 47903 (800)489-4891 /