Forum OpenACS Q&A: Re: DB Connection Error

Collapse
5: Re: DB Connection Error (response to 1)
Posted by danny kim on
I'm sure my database server(openacs) is running.
review following Info. and previous log and configuration files.

===========================================================================
1. ps

cs@debian:~$ ps axw |grep post
1588 ? S 0:01 /usr/lib/postgresql/8.4/bin/postgres -D /var/lib/postgresql/8.4/main -c config_file=/etc/postgresql/8.4/main/postgresql.conf
1652 ? Ss 0:00 postgres: writer process
1653 ? Ss 0:00 postgres: wal writer process
1654 ? Ss 0:00 postgres: autovacuum launcher process
1655 ? Ss 0:00 postgres: stats collector process
2201 ? Ss 0:00 postgres: www-data openacs [local] idle
2457 pts/1 S+ 0:00 grep post

===========================================================================
2. psql



postgres@debian:~$
postgres@debian:~$ psql -l
List of databases
Name | Owner | Encoding | Collation | Ctype | Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
openacs | www-data | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
pool1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
service1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
: postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
: postgres=CTc/postgres

Thanks