Skip site navigation (1) Skip section navigation (2)

PGOPTIONS and default_tablespace

From: Jan-Peter(dot)Seifert(at)gmx(dot)de
To: pgsql-admin(at)postgresql(dot)org
Subject: PGOPTIONS and default_tablespace
Date: 2009-01-12 09:34:27
Message-ID: 20090112093427.316400@gmx.net (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Thomas MarkusDate: 2009-01-12 09:44:07
Subject: Re: PGOPTIONS and default_tablespace
Previous:From: Greg Sabino MullaneDate: 2009-01-09 23:56:43
Subject: Re: suggestions/hints for multimaster solution

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group