From: Scott Marlowe <scott.marlowe@gmail.com>
To: Jan-Peter.Seifert@gmx.de
Cc: pgsql-admin@postgresql.org
Subject: Re: PGOPTIONS and default_tablespace
Date: Mon, 12 Jan 2009 13:09:19 -0700
Message-ID: <dcc563d10901121209v61c13a76v2c7031a50cf8a0ac@mail.gmail.com> (raw)
In-Reply-To: <20090112093427.316400@gmx.net>
References: <20090112093427.316400@gmx.net>
On Mon, Jan 12, 2009 at 2:34 AM, <Jan-Peter.Seifert@gmx.de> wrote:
> 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."
I do this one of two ways usually. Either I set the user / database
to have a default tablespace permanently via alter user / database, or
I put it at the top of my script I'm running. PGOPTIONS isn't really
the place I think of setting it myself.
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: scott.marlowe@gmail.com, Jan-Peter.Seifert@gmx.de
Subject: Re: PGOPTIONS and default_tablespace
In-Reply-To: <dcc563d10901121209v61c13a76v2c7031a50cf8a0ac@mail.gmail.com>
* 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