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
5 answers

Setting up Phppgadmin 5.0.2 with Xampp 1.7.4

I was asked to perform(first time) a task in PHP with PostgreSQL for the purpose I intalled XAMPP 1.7.4, PostgreSQL 9.X, I was unaware how to setup phpPgadmin(5.0.2) so I googled and found Configuration Instruction here; and here after configuring…
Mubashar
  • 12,300
  • 11
  • 66
  • 95
0
votes
1 answer

How to upload my postgresql db in phppgadmin into postgres server on some host

I am very beginner to PostgreSQL. I have created database with tables in phppgadmin and now I need to upload it to the remove Postgres server. I knnow username and password. What do I need for doing that?
user245548
  • 11
  • 7
0
votes
1 answer

phppgAdmin has more than 1 Error - also Error Loading servers.php

I am trying to learn PostgreSQL and so installed it and phppgAdmin on my laptop. I went to localhost/phppgadmin, logged in and I get all these errors on the front page: I tried going troubleshooting on Google, but unfortunately there are not enough…
user9581798
0
votes
1 answer

change from adodb to php7.2-pgsql

Change phppgadmin connection from adodb to php7.2-pgsql Tried running an SQL query on database from phppgadmin and got error "Deprecated: The each() function is deprecated. This message will be suppressed on further calls in…
user4560
  • 57
  • 1
  • 7
0
votes
0 answers

How to import data into DB from an text file?

How can I copy data from a text file to a postgresql database? I tried this but it doesnt work: COPY data FROM '/home/pi/Downloads/data.tsv' DELIMITER ' \ tab' COPY data FROM '/home/pi/Downloads/data.tsv' DELIMITER '\t' COPY data FROM…
MaZzEe
  • 1
0
votes
1 answer

Problem importing 'db.backup' to phpPgAdmin

I know this will appear to be a duplicate of this Import sql dump using phppgadmin However I AM clicking the correct place but I never get shown a Browse button. I can't copy and paste either as file I've been provided is 'backup' format so I…
anoldermark
  • 366
  • 3
  • 8
0
votes
1 answer

Integrating phpPgAdmin to XAMPP throws errors

I installed Postgre with Xampp 7.2.1. Postgre Database. The database just works just fine, but I`m having trouble getting phpPgAdmin to work. I downloaded phpPgAdmin from here: https://sourceforge.net/projects/phppgadmin/ I followed the instructions…
Heinz
  • 115
  • 2
  • 9
0
votes
0 answers

Error while connecting to my phppgadmin page

Every time, I try to go to my localhost/phppgadmin page, I always get this message, (i'm using ubuntu 16.04): printHeader('', null, true); $rtl = (strcasecmp($lang['applangdir'], 'rtl') == 0); $cols = $rtl ? '*,'.$conf['left_width'] :…
0
votes
1 answer

Update statement according to condition

How to update the discount_price in DB I need to add value to existing value according to my condition Example: any product has the price from 10 to 30 I have to add 1.5 to it. product with 15 should be 16.5 for example I have written this query…
0
votes
1 answer

How do I modify this PostgreSQL table?

I'm using PostgreSQL in my SBC, running Parabola (Arch and ALARM based). I was reading this tutorial so I can use PostgreSQL databases and make Postfix work with them. However, in this step I have to fill up some info in the tables I've created,…
Megver83
  • 185
  • 1
  • 11
0
votes
1 answer

phpPgAdmin - log in works but I have to login again after clicking on any links

I have setup Postgres 9.6 and phppgadmin on a Centos 7 server with nginx, I can log in to phpPgAdmin, however PostgreSQL server on the right of the page remains crossed out and any link I try to browse to (databases, roles etc) requires I log in…
BigJ
  • 103
  • 2
  • 10
0
votes
1 answer

Set a password for PhpPgAdmin users

I've installed phpPgAdmin in my PostgreSQL server, and configured it on Apache to access through HTTP. The point is that, although it works OK, I see a security issue. As of now, I see only one server called "PostgreSQL" in the "Servers" side,…
Megver83
  • 185
  • 1
  • 11
0
votes
1 answer

Export PostgreSQL using phppgadmin

I want to export and download my database using phppgadmin, but it always downloaded with 0 bytes. what I do wrong? Choose DBname > SQL > Then I choose structure and data> with format SQL> Then I choose Download for the option then click export
adn
  • 430
  • 2
  • 7
  • 20
0
votes
0 answers

PHP: postgresql & Apache unique page not loading

All, We have a page connected to a database in which a colleague created and now have some issues. I am a newbie so trying to get some clues about what to do. I launch the services from the server called "Apache2.4" & "postgres" so that we can get…
elnene2k
  • 1
  • 1
0
votes
1 answer

WAMP - phppgadmin - 403 Forbidden

I'm trying to setup phppgadmin on a WAMP server, but when I go to: http://localhost/phppgadmin I get 403 Forbidden. Here's whats in the C:/wamp64/alias/phppgadmin.conf file: Alias /phppgadmin "C:/wamp/apps/phppgadmin5.1/"
Horse O'Houlihan
  • 1,659
  • 4
  • 14
  • 29