connection statement

sreenisha

Hi
i am trying to connect postgres database using php.my database name is DB username=GPME and password=secret.I tried the pg_connect() using host=localhost parameter also.The following error occurs.

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: Database "DB,user=GPME,password=secret" does not exist in the system catalog. . in /var/www/html/GPME/technical.php on line 3
Warning: pg_close(): supplied argument is not a valid PostgreSQL link resource in /var/www/html/GPME/technical.php on line 10

My php version is 4.3.3 and pgsql version is 7.3.4.I tried this with mysql and it is working.Anyone please help me in this issue.

rski

I think you use commas to separate all connections params, i'm not php specialist but maybe try to write connection string like that

Expand|Select|Wrap|Line Numbers

pg_connect("host=localhost dbname=xxx password=xxx");

Did you write connection string in that way?

sreenisha

Ye,I tried that.I tried to edit the pg_hba.conf file and removed the comment on the line
host all all 127.0.0.1 255.255.255.255 trust

too and restarted the postmaster service.

But still warning is there :

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: Missing or erroneous pg_hba.conf file, see postmaster log for details . in
Warning: pg_close(): supplied argument is not a valid PostgreSQL link resource in /var/www/html/GPME/sample.php

rski

Quote:

Originally Posted by sreenisha

Ye,I tried that.I tried to edit the pg_hba.conf file and removed the comment on the line
host all all 127.0.0.1 255.255.255.255 trust

too and restarted the postmaster service.

But still warning is there :

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: Missing or erroneous pg_hba.conf file, see postmaster log for details . in
Warning: pg_close(): supplied argument is not a valid PostgreSQL link resource in /var/www/html/GPME/sample.php

Oh, so you've got wrong pg_hba file. Look at it. Maybe there is somewere missing # (is a comment). Show here lines from pg_hba without leading #. Do you log events if so check postgres log.

sreenisha

I cudnt find any postmaster log files.One folder pg_xlog is there which lists
0000000000000000
Shall we create a log file or does it come with POstgresql itself.

rski

Quote:

Originally Posted by sreenisha

I cudnt find any postmaster log files.One folder pg_xlog is there which lists
0000000000000000
Shall we create a log file or does it come with POstgresql itself.

The place where log files are stored is defined in postgres.conf.
BTW what about not commented lines from pg_hba.conf .

sreenisha

Here is my ph_hba.conf file entries which is not leading by a #.That is the last line of the configuration file.

local all all ident sameuser

connection statement

re: connection statement

re: connection statement

re: connection statement

re: connection statement

re: connection statement

re: connection statement

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about