Forum OpenACS Q&A: How create DB between OpenACS and Postgres

1: How create DB between OpenACS and Postgres

Posted by Dayra Munoz on 11/05/01 10:31 PM

Hi friends

I have two servers:

Server A: It has installed OpenACS-4
Server B: It has installed Postgresql 7.1

Both has on Linux Red Hat 6.2. How create a DB in Server A for to
create one connection beteewn Server a and Server B?

Thanks

2: Response to How create DB between OpenACS and Postgres (response to 1)

Posted by Ben Adida on 11/14/01 04:18 PM

I haven't done this myself, but I know others have. You should make sure your PostgreSQL server is running on a TCP/IP socket by providing the "-i" option to postmaster at start time. Then, your connect string in your AOLserver .tcl initialization file should specificy the IP, the port, and the username and password for logging into Postgres.

Thus, your main issue is making sure that you have Postgres correctly running in username/password authentication mode.

I know someone out there has done this and can add more details?