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

[interchange-users@interchange.redhat.com (Gill, Jeffrey L)]

Hi Andrew,

Thanks for your response.  The problem is I did not create the database.
The InterChange application created the demo database.   Maybe I can search
through the install scripts and figure it out.   How do I determine the
value of the PGDATA environment variable?  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.  I
can still launch the Interchange Admin tool though when logged on as myself
i.e. jeff and I can manually connect to the database by doing $psql store1
postgres.  I need to use the built-in demo database for the research testing
I am doing.   I would have more control if I manually created a database but
I need the features of the InterChange app.  

Jeff  

-----Original Message-----
From: Andrew McBeath [mailto:andrew@zeald.com]
Sent: Thursday, March 07, 2002 2:41 PM
To: interchange-users@interchange.redhat.com
Subject: Re: [ic] starting postmaster with "-i" option with demo
database


Gill, Jeffrey L wrote:

> How do you automatically start the postmaster with the "-i" option to
allow
> TCP/IP connections 

just put -i into the startup command - eg: 
/usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data

> 
> when using the default demo (construction store) database in InterChange
> 4.8.   
> 
> I uderstand the use of pg_ctl but I am unable to login as postgres and do
> not know the correct -D parameter for pg_ctl -D.   
> I tried pg_ctl -D /var/lib/psql/data start when logged on as a general
user
> and I get 
> 
> $ postmaster successfully started
> $ /usr/bin/postmaster does not find the database system.
>      Expected to find it in the PGDATA directory "/var/lib/psql/data", but
> unable to open file
>      "/var/lib/psql/data/global/pg-control/": no such file or directory.


-D needs to point to the dir that was specified when initdb was 
run...(eg: /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data) - also 
check the PGDATA environment variable...that can be used instead of the 
-D parameter...

Make sure that the database system *has* been created using 
initdb...something like:

   mkdir /usr/local/pgsql/data
   chown postgres /usr/local/pgsql/data
   su - postgres
    /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data


Cheers,

Andrew McBeath
System Administrator / Senior Developer
Zeald Ltd
ICQ: 53879543
Ph: +64 9 415 7575
Mob: +64 21 434104


_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users