Stack Overflow
Stack Overflow

Questions tagged [phppgadmin]

phpPgAdmin is a fully functional web-based administration utility for a PostgreSQL database server.

phpPgAdmin is a fully functional web-based administration utility for a PostgreSQL database server. It handles all the basic functionality as well as some advanced features such as triggers, views and functions (stored procs)

162 questions
2
votes
2 answers

undefined index: plugins in /usr/share/phppgadmin/classes/

After updating ubuntu from 13.04 to 13.10 In phppgadmin this error message appear undefined index: plugins in /usr/share/phppgadmin/classes/PluginManager.php
Arjun Thakur
  • 635
  • 8
  • 21
2
votes
3 answers

Transaction roll back not working in Postgresql

I am working on PostgreSQL 9.1.4 . I am inserting the data into 2 tables its working nicely. I wish to apply transaction for my tables both table exist in same DB. If my 2nd table going fail on any moment that time my 1 st table should be…
Kanchetianeel
  • 189
  • 2
  • 3
  • 15
2
votes
2 answers

phpPgAdmin for Heroku database

When I create an app in Heroku and add a database (PostgreSQL) to it, is there a way to add a web interface for that database (such as phpPgAdmin)?
Chin
  • 19,717
  • 37
  • 107
  • 164
2
votes
2 answers

Query works from pgAdmin. Won't work from PHP with no errors

I'm rebuilding app for my client. I write scripts to migrate data from old db to new one. To prevent empty values in column etiquette_start (what happened in old db), I run UPDATE items SET etiquette_start = 'E' WHERE trim(both ' ' from…
ex3v
  • 3,518
  • 4
  • 33
  • 55
2
votes
1 answer

File size limit for importing text file into postgreSQL using phpPGAdmin

I'm still trying to import a large text file into phpPgAdmin and not succeeding. I have changed the following fields in the php.ini file, but it didn't help. I changed the following fields to: upload_max_filesize = 3G post_max_size =…
Beardo
  • 65
  • 1
  • 2
  • 9
1
vote
1 answer

Cannot edit or delete data or rows within PostgreSQL 9.2.24

When I try to edit data in phppgadmin, no matter which table or row, I always got the error 'No unique identifier for this row.' and nothing is changed/saved. The user I'm logged in with has full privileges on the database and all tables in the…
Daniela Zavallone
  • 13
  • 4
1
vote
0 answers

can't install phpPgAdmin with cwp

I am using cwp on my VPS and I have this problem when I try to login to https://hostname:2031/phpPgAdmin/ The PHP configuration on this server does not support PostgreSQL. You need to reinstall PHP using the --with-pgsql configure option. i tried to…
ibrahim shazly
  • 15
  • 6
1
vote
1 answer

How to connect "Add to Favorites" activity from logged on users to pg admin 4 database

First of all, I am totally new to PHP and databases in general. I have a question regarding the creation of a website, in which I've created a database that users can login into and interact with. To be more specific, I created a music store website…
Vel_More
  • 293
  • 1
  • 10
1
vote
1 answer

docker and bitnami/phppgadmin: How to connect to the remote postgresql database

I am trying to connect to a remote postgresql database using the bitnami/phppgadmin docker How to mention the host name phppgadmin: image: "bitnami/phppgadmin:7.13.0" ports: - "8080:8080" - '443:8443' environment: …
Santhosh
  • 9,965
  • 20
  • 103
  • 243
1
vote
1 answer

posgresql: relation does not exist

I have ported a database to a new laptop by using an sql dump from the old computer and then executing this dump on the new computer. Thea data was copied correctly, and all the SQL statements regarding the tables work perfectly. For creating new…
user1479670
  • 1,145
  • 3
  • 10
  • 22
1
vote
2 answers

ERROR: syntax error at or near "PGDMP" LINE 1: PGDMP

I am trying to upload a postgres database backup file to my hosting server. But I am getting these errors. No idea what is wrong with this file.
Pashupati Sah
  • 426
  • 5
  • 9
1
vote
0 answers

Phppgadmin not working on localhost , WAMP(bitnami)

I've installed wamp for Windows from this website: https://bitnami.com/stack/wamp/installer . I can run the 127.0.0.1 (localhost) , but when I try to enter the 127.0.0.1/phppgadmin/ I get no found message. Does anyone now how to solve this? Thank…
ichbin
  • 11
  • 1
1
vote
1 answer

Trying phppgadmin docker container to view postgres database on host: it says login failed

I want to view the host postgresql with phppgadmin docker container My host is archlinux and with postgresql server running on it. I have /var/lib/postgres/data/postgresql.conf listen_addresses = "*" and /var/lib/postgres/data/pg_hba.conf host …
Santhosh
  • 9,965
  • 20
  • 103
  • 243
1
vote
2 answers

Printing the same column twice

How can I print the 'ID' column twice. I've already got it in the start of the table, and also want it to also print out as the last column again for easy viewing purposes. ALTER TABLE EMPLOYEES ADD ID int; 'ID already exists' Also, when I update…
ROOT
  • 57
  • 1
  • 3
  • 10
1
vote
1 answer

nginx not run php by location

I should get phppgadmin by example.com/phppgadmin, but something is going wrong. I could get it by example.com/ (see the comments in conf below). But if I'm trying to get phppgadmin by creating locationin nginx config I'm getting 404 not found. What…
ekhodzitsky
  • 103
  • 1
  • 1
  • 10
1 2 3
…
10 11