| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Jan-Peter(dot)Seifert(at)gmx(dot)de |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: PGOPTIONS and default_tablespace |
| Date: | 2009-01-12 20:09:19 |
| Message-ID: | dcc563d10901121209v61c13a76v2c7031a50cf8a0ac@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Jan 12, 2009 at 2:34 AM, <Jan-Peter(dot)Seifert(at)gmx(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Whitney | 2009-01-13 17:37:00 | Strange deadlock error last night |
| Previous Message | Jan-Peter.Seifert | 2009-01-12 16:53:57 | Re: PGOPTIONS and default_tablespace |