[ic] starting postmaster with "-i" option with demo database

[Andrew McBeath]

Jeff,

> How do I determine the value of the PGDATA environment variable?  

View: echo $PGDATA
Set:     export PGDATA=/path/to/data/directory

The PGDATA / -d path has little to do with the actual database (store1) 
you are using - it should be the same every time you start postmaster 
regardless of which actual database you are want to use.
It tells postmaster where to find it's internal data as well as the 
physical database files. 
To find what it should point to, try:
    find / -name postgresql.conf
or:
    find / -name PG_VERSION

> Also, When I installed InterChange the app did not give me the opportunity to set the postgres
> password. 
> I modified postgres account used for the postgres server but it will not allow me to login as postgres even with the correct password.

Are you referring to the linux postgres account or the built-in 
account?  They are two different accounts, completely unrelated. 
The linux account can be modified using passwd, the pg account can be 
modified using sql:
ALTER USER postgres WITH PASSWORD 'password';

Note: If no password has been set up (in pgsql) password authentication 
will always fail for that user.

> What is the correct path when using the default database
> within IC?  Note: my database name is store1. I have located the 
> store1 dirs but I am still not sure what the correct path should be
> for pg_ctl _d parameter or for the variable $PGDATA.

<reiterate/>It _must_ point to the same path that was used with initdb.

The PGDATA / -d path is generally static.  All the physical DB files are 
stored underneath that directory.  The actual database you connect to is 
specified at connect time rather than at daemon startup.


This is rather OT... maybe it should really go to the pgsql-admin, or 
pgsql-general lists at postgresql.org...

You might also find the administrators guide useful: 
http://www.postgresql.org/idocs/index.php?admin.html ;-)


Kind regards,

Andrew