From: Jan-Peter.Seifert@gmx.de
To: pgsql-admin@postgresql.org
Subject: PGOPTIONS and default_tablespace
Date: Mon, 12 Jan 2009 10:34:27 +0100
Message-ID: <20090112093427.316400@gmx.net> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Jan-Peter.Seifert@gmx.de
Subject: Re: PGOPTIONS and default_tablespace
In-Reply-To: <20090112093427.316400@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox