Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 920C963248E
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 12 Jan 2009 05:34:33 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 72327-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 12 Jan 2009 05:34:30 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail.gmx.net (mail.gmx.net [213.165.64.20])
	by mail.postgresql.org (Postfix) with SMTP id 6041B63248D
	for <pgsql-admin@postgresql.org>; Mon, 12 Jan 2009 05:34:30 -0400 (AST)
Received: (qmail 27487 invoked by uid 0); 12 Jan 2009 09:34:27 -0000
Received: from 192.124.237.8 by www169.gmx.net with HTTP;
	Mon, 12 Jan 2009 10:34:27 +0100 (CET)
Content-Type: text/plain; charset="iso-8859-1"
Date: Mon, 12 Jan 2009 10:34:27 +0100
From: Jan-Peter.Seifert@gmx.de
Message-ID: <20090112093427.316400@gmx.net>
MIME-Version: 1.0
Subject: PGOPTIONS and default_tablespace
To: pgsql-admin@postgresql.org
X-Authenticated: #955937
X-Flags: 0001
X-Mailer: WWW-Mail 6100 (Global Message Exchange)
X-Priority: 3
X-Provags-ID: V01U2FsdGVkX18M5NJhHjUM1DQ62BSEthldHkInW97C9Xxq/cKoCQ
	aDm/EgXQazkF+iJnUuzSSAIz2i8Iw0rDnb9A==
Content-Transfer-Encoding: 8bit
X-GMX-UID: kDlZeKxTIydmGQTzemdrSPtSa2FkZtW/
X-FuHaFi: 0.58
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200901/30
X-Sequence-Number: 31077

Hello,

without success I tried to set the default tablespace via the environment variable PGOPTIONS.

My tries:
set PGOPTIONS="default_tablespace='pgdata'"
set PGOPTIONS=default_tablespace='pgdata'
set PGOPTIONS=default_tablespace(pgdata)
set PGOPTIONS=default_tablespace('pgdata')

When I try to connect to the server via psql I get the error message: "FATAL: invalid command-line arguments for server process. HINT: Try "postgres --help" for more information."

However, when I start the server with: postgres -c default_tablespace='pgdata'
it works.

What am I missing?

The OS is Windows xp Pro sp3. PostgreSQL version: 8.3.5.

BTW: Why aren't new databases created in the 'new' tablespace? Just because it's not a dbspace but a tablespace? It would be much more convenient if the createdb commands would make use of the default_tablespace setting as it's the case with tables.

Thank you very much,

Peter Seifert


-- 
Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger