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
0
votes
0 answers

phpPgAdmin refused to connect

I have Ubuntu 18, php 7.4 and trying to install phpPgAdmin. I did all steps from this instruction: https://www.rosehosting.com/blog/how-to-install-phppgadmin-on-ubuntu-18-04/ My /etc/hosts file: #127.0.0.1 localhost #127.0.1.1 site-1.loc 127.0.0.2…
karmeljuk
  • 54
  • 1
  • 7
0
votes
2 answers

Bitnami Wapp stack: In the installation wizard, PhpPgAdmin is grayed out and I cannot be selected to enable it. Is there away around this?

I am trying to use the phppgAdmin with the Bitnami Wapp Stack installer on a Windows 10 virtual machine. The installer seemed to install just fine except the option to include phppgadmin was grayed out and there was no way to enable it. Does anyone…
0
votes
1 answer

How can I uninstall phpPgAdmin?

I want to uninstall phpPgAdmin. How can I do this?
Sheehan Alam
  • 60,111
  • 124
  • 355
  • 556
0
votes
1 answer

bitnami/phppgadmin: Gives Bad request. Nothing found in the error_log

I am using a docker-compose file for postgresql and phppgadmin as follows: I have postgresql: image: "postgres:13-alpine" restart: always environment: POSTGRES_DB: project POSTGRES_USER: django POSTGRES_PASSWORD:…
Santhosh
  • 9,965
  • 20
  • 103
  • 243
0
votes
1 answer

How to avoid duplicates between two tables on using join?

I have two tables work_table and progress_table. work_table has following columns: id[primary key], department, dept_name, dept_code, created_time, updated_time progress_table has following columns: id[primary…
angular
  • 39
  • 1
  • 1
  • 6
0
votes
0 answers

Manually edit an individual row in phppgadmin

I would just like to edit manually WITHOUT using a query in phppgadmin is it possible? I can only see the list of the contents of the table when i click browse, seems like there is no edit row button here as well at the bottom of the pages the…
Button Press
  • 623
  • 6
  • 26
0
votes
0 answers

Why does PHPPGAdmin gives insert error when the command line does not?

I'm trying to do an insert into PHPPGadmin into one of my tables: INSERT INTO teachers (first_name,last_name,school,hire_date,salary) VALUES ('Ron','Buckby','F.D. Roosevelt School','04-17-1979',34900); And I get an error back: SQL error: ERROR: …
bluethundr
  • 1,005
  • 17
  • 68
  • 141
0
votes
2 answers

postgresql and django - No unique identifier for this row

Two entries on my Django postgresql database are causing me a world of trouble when I go a-querying to create reports. When I try to delete these entries (via phpPgAdmin), I get the error "No unique identifier for this row." There are no duplicate…
Zach Marin
  • 23
  • 7
0
votes
3 answers

PHPPGAdmin on windows gives a `Virtual Class -- cannot instantiate` error

I have PHPPGAdmin installed on windows 10. Postgres is fine and I can log into it on the command line. But when I try to log into PHPPGadmin web UI I get the following error: Virtual Class -- cannot instantiate Here is my PHPPGAdmin config…
Tim Dunphy
  • 685
  • 2
  • 10
  • 25
0
votes
0 answers

Fill postgresql table with CSV and UTF-8 encoding files

I create custom Database with UTF-8 Encoding in postgreSQL (PHPPgAdmin) and create CSV file with Excel in windows too. I want to import CSV file to one of my table. When I open my csv file in Windows, some characters in the form Are shown with ?…
0
votes
0 answers

postgresql - remote database : phppgadmin not able to login, where python psycopg2 is able to connect and fetch data

I am trying to access a remote database of postgresql. I am working in a python project I am able to access a table using psycopg2 import psycopg2 server_host = 'xx.x.xx.xx' server_dbname = 'dbname' server_username = 'username' server_password =…
Santhosh
  • 9,965
  • 20
  • 103
  • 243
0
votes
2 answers

Devilbox pgMyAdmin Error Cannot change session name when session is active

Hello I'm totally new to devilbox, I've installed it without errors but when I'm trying to log into pgmyadmin I'm getting the following warnings: Warning: session_name(): Cannot change session name when session is active in…
Allex Radu
  • 1,257
  • 13
  • 24
0
votes
1 answer

problem changing password on pgadmin with php

I'm writing a PHP file to allow the user to change their password, but I'm having a strange problem. I require the old password to confirm the account and the new password. Given that the credentials are correct, this page always returns me that the…
0
votes
1 answer

In docker I can not login into phppgadmin

I make in docker php/postgres app with phppgadmin and I have problems that I can not login in phppgadmin and got error Invalid login I have: version: '3' services: web: build: context: ./web …
mstdmstd
  • 2,195
  • 17
  • 63
  • 140
0
votes
1 answer

Authentication with nodejs

I have a problem to make login work in my nodejs app. When I authenticate even if I enter the wrong user I have my page home render: This is my code for the authentication: app.post('/auth', urlencodedParser, function(req, res) { var username =…