Welcome Guest, Not a member yet? Register   Sign In
I'm getting a blank screen when trying to connect to postgresql
#1

[eluser]yassir[/eluser]
I'm getting a blank screen when trying to connect to postgresql. is there anything wrong with this config ?

Code:
$active_group = "default";
$active_record = TRUE;
$db['default']['hostname'] = "localhost";
$db['default']['username'] = "postgres";
$db['default']['password'] = "mypassword";
$db['default']['database'] = "mydatabase";
$db['default']['dbdriver'] = "Postgre";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";

i also autoload the database library :

Code:
$autoload['libraries'] = array('database');

oh i forgot i'm running windows using wamp with PHP 5.3 (WAMP)

i also enabled php_pgsql and php_pdo_pgsql extensions.

What am i missing ??
#2

[eluser]n0xie[/eluser]
Do you know if you installed the php - postgresql lib? On Debian based systems:
Code:
sudo apt-get install php5-pgsql
#3

[eluser]yassir[/eluser]
[quote author="n0xie" date="1279049929"]Do you know if you installed the php - postgresql lib? On Debian based systems:
Code:
sudo apt-get install php5-pgsql
[/quote]

i'm using windows with WAMP
#4

[eluser]n0xie[/eluser]
That doesn't really answer the question now does it.
#5

[eluser]yassir[/eluser]
[quote author="n0xie" date="1279050148"]That doesn't really answer the question now does it.[/quote]

php - postgresql lib ? where can i get it from ? sorry i m still new to PHP
#6

[eluser]n0xie[/eluser]
This might help: http://stackoverflow.com/questions/84248...indows-php

May I ask why you are trying to install postgresql if you are using WAMP (implying MySQL). Especially if you're new to PHP?
#7

[eluser]yassir[/eluser]
[quote author="n0xie" date="1279050371"]This might help: http://stackoverflow.com/questions/84248...indows-php

May I ask why you are trying to install postgresql if you are using WAMP (implying MySQL). Especially if you're new to PHP?[/quote]

I have been using ASP.NET with MSSQL for a long time and now i'm looking for something new to learn that is why i chose CI and i didn't want to use MySQL because it has lot of limitations and postgresql seemed a better choise ...
#8

[eluser]n0xie[/eluser]
In that case I would suggest just using MySQL: it's basically what the whole world is using anyway. The differences between MySQL-InnoDB and PostgreSQL aren't that great (yes I know some fanboy will probably flame me for this) at least not when you are just getting to grips with a new environment and a new language. The moment the differences do matter to you, you probably wont need to ask here how to set it up.
#9

[eluser]yassir[/eluser]
[quote author="n0xie" date="1279051295"]In that case I would suggest just using MySQL: it's basically what the whole world is using anyway. The differences between MySQL-InnoDB and PostgreSQL aren't that great (yes I know some fanboy will probably flame me for this) at least not when you are just getting to grips with a new environment and a new language. The moment the differences do matter to you, you probably wont need to ask here how to set it up.[/quote]

anyway can you help me solve this problem
#10

[eluser]yassir[/eluser]
Anyway i installed WAPP and everything works




Theme © iAndrew 2016 - Forum software by © MyBB