Hi zipman,
You have to edit apps/config/database.php with your specific postgres
database details. Here's mine:
var $default = array('driver' => 'postgres',
'connect' =>
'pg_connect',
'host' =>
'172.16.237.101',
'login' =>
'postgres',
'password' =>
'a',
'database' =>
'testdata',
'prefix' => '');
I have postgres running in a virtual machine. You must create a
database with the user and password before connecting from cake...
OB
zipman wrote:
> I was using mysql as database up to now and had no problem.
> The problem is that now I have to move to postgresql and cakephp
> doesn't seem to cooperate.
> I changed the settings in database.php
> and I get
>
> Your database configuration file is present.
>
> Cake is able to connect to the database.
>
> in the main page but whenever I try to access a controller
> (and the according view) I get
>
> Warning: pg_query(): Query failed: ERROR: Namespace
> "information_schema" does not exist . in
> /home/mgovadmin/cake/libs/model/dbo/dbo_postgres.php on line 111
>
> My settings in database.php are
>
>
> var $default = array('driver' => 'postgres',
> 'connect' => 'pg_connect',
> 'host' => 'localhost',
> 'login' => 'login',
> 'password' => 'password',
> 'database' => 'database',
> 'prefix' => '');
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cake-php
-~----------~----~----~----~------~----~------~--~---
