Yes, i installed postgres 9.1
phpinfo() shows (under PDO):
Quote:
support
enabled
PDO drivers
pgsql, sqlite
pdo_pgsql
PDO Driver for PostgreSQL
enabled
PostgreSQL(libpq) Version
9.1.9
Module version
1.0.2
Revision
$Id$
|
now i have next error:
Quote:
Fatal error: PDO connection error 'pgsql:dbname=davical user=davical_app': SQLSTATE[08006] [7] could not connect to server: Permission denied Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? in /usr/share/awl-0.53/inc/AwlDBDialect.php on line 81
|
when i do:
Quote:
# sudo su - postgres
-bash-4.1$ psql -U davical_app davical
psql (9.1.9)
Type "help" for help.
davical=> select fullname from usr;
fullname
-----------------------
DAViCal Administrator
(1 row)
davical=>
|
Which give /me the idea i have a database with some info in it.....
contents of pg_hba.conf is:
Quote:
local davical davical_app trust
local davical davical_dba trust
host davical davical_app 192.168.178.12/32 trust
host davical davical_dba 192.168.178.12/32 trust
local all all peer
host all all 127.0.0.1/32 ident
host all all ::1/128 ident
|
(192.168.178.12 is the ip-address of the machine is have apache&postgresql, and trying to get 'davical' running