Stack Overflow
Stack Overflow

Questions tagged [php-pgsql]

This is for questions related to getting the PostgreSQL client libraries and PHP extensions working with PHP

89 questions
15
votes
6 answers

PHP Startup : Unable to load dynamic library PGSQL

I'am trying to run Symfony 3.x with : Ubuntu 16.04 PHP 7.0 NGinx I would like to interact with my PGSQL database that I created but I get this error : PHP Warning: PHP Startup: Unable to load dynamic library …
Hurobaki
  • 3,728
  • 6
  • 24
  • 41
9
votes
2 answers

How to execute a stored procedure directly in postgresql?

I have created a procedure like : CREATE OR REPLACE FUNCTION insert_user_ax_register( user_name character varying(50), password character varying(300), role_id character varying(10), created_dt date, status boolean, email…
Debs
  • 331
  • 1
  • 3
  • 22
5
votes
1 answer

I can't add pgsql PDO Driver in MAMP on Mac Big Sur

I have installed MAMP and PostgreSQL with PGAdmin4, but I'm having some problems. I'm getting a psql "command not found error" in my terminal. I have added export PATH=/Library/PostgreSQL/10/bin:$PATH into ~/.bash_profile, but whenever I reopen the…
jalal uddin
  • 63
  • 1
  • 5
4
votes
1 answer

Connecting to PGSQL over SSL via PHP PDO

Where would I be able to pass my client certificates to connect to a PostgreSQL database? Do I have to pass these certificates in the dsn or options parameters in the PDO constructor? I'm unable to find any documentation online. I am using PHP…
Jared Dunham
  • 1,467
  • 2
  • 17
  • 29
4
votes
1 answer

install php7.0-pgsql - Unable to locate package php-pgsql

I am trying to install php7.0-pgsql, but always get E: Unable to locate package phpXXX-pgsql I am trying apt-get update apt-get install php7.0-pgsql=7.0.12-1+deb or apt-get install php7.0-pgsql=7.0.12-1 or apt-get install php7.0-pgsql or…
TheRealPir
  • 445
  • 1
  • 6
  • 15
4
votes
1 answer

PHP PostgreSQL open/close connection performance

I am new in programming (especially in PHP). I write simple PHP site. I also use PostgreSQL database. Here is my little class for work with database. class dbWorker { private static $conString = "host=localhost port=5432 dbname=myDB…
Dmitry Novice
  • 155
  • 2
  • 12
3
votes
1 answer

ERROR: right sibling's left-link doesn't match: block 19 links to 346956 instead of expected 346955 in index "pg_depend_reference_index"

I have a DB in postgres. The DB is big with total size over 4TB and over 500,000 tables and many indexes. The DB is over 4 yr old. Recently, the Pgsql DB server was not starting up, so I did the following to get it started…
charak
  • 187
  • 3
  • 15
3
votes
2 answers

Where can i find php-pgsql package for RedHat 7?

I am developing my project with PHP 5.6.27 PostgreSQL 9.6.1 RedHat 7 OS I had searched for the php_pgsql package everywhere. also tried with some rpms. but still I am not able to get the package. I developed my whole project in php_pgsql package…
Telen Stanley
  • 310
  • 1
  • 6
  • 16
3
votes
2 answers

Unable to install php5-pgsql on Ubuntu 16.04

I updated my OS from Ubuntu 14.04 to version 16.04, and php 7 was installed, but I want to use php 5.6. So I installed php 5.6 and tell Apache to use that version instead of php 7. But I'm having problems installing php5-pgsql. I tried with this…
Dafne Defant
  • 79
  • 1
  • 1
  • 9
3
votes
3 answers

Postgresql, phpPgAdmin in xammp

Hi I have this error while I'm trying to launch phpPgAdmin: Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option. I'm using XAMPP ver 1.7.7, Postgresql 9.2.4 64 bit, and phpPgAdmin…
miles
  • 225
  • 3
  • 10
  • 20
2
votes
1 answer

Postgresql query returns string values between quotation marks " if it contains any space character or without quotation if it had no space char

so I got this strange issue and I have no idea what's causing it. We are using Charts.js in PHP to plot some charts. We store the arguments needed to create a chart into a PSQL table to load when needed. My issue lies with the title, group and label…
Electrolite
  • 149
  • 2
  • 16
2
votes
1 answer

UPDATE with INSERT RETURNING value PGSQL

Trying to update certain column with newly created id. Example: ╔═══════════════════════════╗ ║ TABLE_LIST_BINDER ║ ╠════╦══════════════════════╣ ║ id ║ tbl_id_lists ║ ╠════╬══════════════════════╣ ║ 1 ║ 1,2,3,4,5,6,7,8,9,10…
Thomas J.
  • 593
  • 8
  • 21
2
votes
0 answers

Postgres PDOStatement::errorInfo() driver specific error message persists across queries

I've encountered the following bizarre behavior: //assume $dbh is a valid handle $stmt = $dbh->prepare("UPDATE mytable SET myintcol = :myintval"); $stmt->bindValue(':myintval', 'notanint',…
Danny
  • 439
  • 5
  • 9
2
votes
0 answers

php libpq postgres version

I have PHP Version 5.6.29 with pgsql PostgreSQL Support enabled PostgreSQL(libpq) Version 9.2.18. Working Ok! I added new version of postgresql server (9.6) (from postgres repos with yum) in another port works correctly too, Now, How can I do whit…
user2144831
  • 21
  • 3
2
votes
1 answer

Upgrade PHP PDO_PGSQL version from 8.4 to 9.4 EC2 Instance

I have an EC2 Amazon Linux Ami instance running PHP server version 5.6.22, also PostgreSQL 9.4.6 installed. Doing an echo phpinfo(); it give the following value for PDO_PGSQL library: PostgreSQL(libpq) Version 8.4.20 This is causing that the app…
Socram
  • 51
  • 1
  • 7
1
2 3 4 5 6