Re: Environment variables

Hi Roy,

Fisrt, the good syntax is

setenv PGDATA "/usr/local/pgsql/data" (with or without "")

Because PGDATA is a variable with only one value 
(/usr/local/pgsql/data), so before this setenv, PGDATA is empty and 
after it should take only /usr/local/pgsql/data.
You use $PGDATA when you want to know wath the variable PGDATA contains

for example :

setenv PGDATA anywhere/your/data/are
echo $PGDATA   ->>>>>>>>>>>>> in the screen you take anywhere/your/data/are



Second, you must give the path where are you data, ie where you say to 
initdb.
Were you used initdb ? (initdb -D DATADIR)

BR

Bruno



Roy MacGregor Paterson wrote:

> Hi Bruno,
>
> Thanks: my .tcshrc works with this...
>
> setenv PATH "$PATH":/Library/MySQL/bin
> setenv PATH "$PATH":/usr/local/bin
> setenv PATH "$PATH":/usr/local/pgsql
> setenv PATH "$PATH":/usr/local/pgsql/bin
>
> ...so now I get this response...
> [MacGregor:/Users/roy] postgres% pg_ctl  -D /usr/local/pgsql/data start
> postmaster successfully started
> [MacGregor:/Users/roy] postgres% LOG:  database system was shut down 
> at 2003-11-22 12:06:33 GMT
> LOG:  checkpoint record is at 0/805FB4
> LOG:  redo record is at 0/805FB4; undo record is at 0/0; shutdown TRUE
> LOG:  next transaction id: 490; next oid: 16977
> LOG:  database system is ready
>
>
> OK. Now I'm trying to get the PGDATA environment variable to work. 
> I've tried each the following lines in . tcshrc one at a time...
> setenv PGDATA "$PGDATA":/usr/local/pgsql
> setenv PGDATA "$PGDATA":/usr/local/pgsql/data
> setenv PGDATA /usr/local/pgsql
> setenv PGDATA /usr/local/pgsql/data
> setenv $PGDATA /usr/local/pgsql
> setenv $PGDATA /usr/local/pgsql/data
>
> ...and always get this response...
> [MacGregor:/Users/roy] postgres% pg_ctl start
> pg_ctl: no database directory or environment variable $PGDATA is 
> specified
> Try 'pg_ctl --help' for more information.
> [MacGregor:/Users/roy] postgres%
>
> ...so what's going on?
>
> regards,
> Roy
--
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno.leveque@xxxxxxxxx
http://www.net6d.com



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings