Bug #72544 [Opn->Fbk]: pg_connect using the "service" parameter
Edit report at https://bugs.php.net/bug.php?id=72544&edit=1
ID: 72544
Updated by: requinix@php.net
Reported by: floriparob at gmail dot com
Summary: pg_connect using the "service" parameter
-Status: Open
+Status: Feedback
Type: Bug
Package: PostgreSQL related
Operating System: Debian
PHP Version: 5.6.23
Block user comment: N
Private report: N
New Comment:
It seems to be supported as far as I can tell. What's the error message?
Previous Comments:
------------------------------------------------------------------------
[2016-07-05 02:19:56] floriparob at gmail dot com
Description:
------------
The documentation for pg_connect says that it recognises the "service" parameter as a
connect string.
In the pg_service.conf file you can have entries for several databases, each with their own distinct
IP addresses, passwords, etc. So, in your PHP code you'd expect to be able to do something like
this wrapped up in a try catch block:-
$connect_string = "service=staging";
$pg_handle = pg_connect($connect_string);
to access the "staging" data base.
With psql you have to do this:-
PGSERVICE=staging;export PGSERVICE
psql
is run without any parameters. It opens the pg_service.conf file and finds the entry defined as
"staging" and from that obtains all the necessary configuration parameters in order to
open a connection to that database.
I tried this:-
putenv("PGSERVICE=staging");
$connect_string = "service=staging";
$pg_handle = pg_connect($connect_string);
but still no luck.
So, if this is not a bug could somebody please enlighten me about the correct way to connect using
pg_service.conf.
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=72544&edit=1
Thread (6 messages)