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
1 answer

XAMPP Apache won't start after i added phpPgAdmin alias

I want to install phpPgAdmin with XAMPP on Windows. After i did all the steps, my Apache module on XAMPP won't start. I got this error log [Mon Nov 14 16:36:16.661538 2016] [ssl:warn] [pid 10612:tid 504] AH01909: www.example.com:443:0 server…
0
votes
2 answers

How to run a .sql file with phppgadmin or psql

While importing .sql file in phppgadmin it produces an error "Import error: Failed to automatically determine the file format". How to import the file? And in terminal it shows as postgres-# \i Documents/sample.sql Documents/sample.sql: No…
Rajasree
  • 35
  • 4
0
votes
1 answer

Getting errors while installing Phppgadmin

"sudo apt-get install phppgadmin" Reading package lists... Done Building dependency tree Reading state information... Done phppgadmin is already the newest version. 0 upgraded, 0 newly installed, 0 to remove and 65 not upgraded. 1 not fully…
Rajasree
  • 35
  • 4
0
votes
1 answer

cannot connect phpPgAdmin on ec2 instance to RDS Pgsql

I am trying to connect my AWS RDS postgres database to my remotely accessible phpPgAdmin which is running on an ec2 instance. I am able to access the phpPhAdmin page, and have edited the config.inc.php file in the phpPgAdmin folder so that it…
0
votes
1 answer

Performance stats table

Is bigger percentage value in tables with computerisons good or not?
0
votes
2 answers

Can I use PostgreSQL 8.3.x for OpenStreetMap?

I'm trying to install phpPgAdmin as an XAMPP addon when I encountered an error because the latest phpPgAdmin supports upto PostgreSQL version 8.3.x. So I decided to install PostgreSQL 8.3.11 instead of the latest (PGSQL 8.4.x). Will this matter to…
John Bautista
  • 1,480
  • 3
  • 29
  • 60
0
votes
1 answer

PostgreSQL phpPgAdmin ENUM field

I'm using PostgreSQL and phpPgAdmin for database manipulation. Now I have problem to create ENUM field with phpPgAdmin. Is it possible to do it with that tool and how?
Remark
  • 31
  • 4
0
votes
0 answers

Create SuperUser in postgresql Windows

I'm trying to create a new user and set up a password for it in postgresql in Windowns 7. I tried: 1. Start menu > All Programs > PostgreSQL 9.5 > psql to 'postgres' 2. Type in: CREATE ROLE username LOGIN PASSWORD 'password However, when I try to…
Samuel
  • 109
  • 2
  • 12
0
votes
1 answer

Authentication problems using phpPgAdmin / PGSQL

I experiencing some problems with PostgreSQL that i need to install to run a SIlverpeas project. Normally, the postgres part is correctly configured, because i've sent a command to make the user silverpeas owner of the database silverpeas, and i can…
Nicolas Frbezar
  • 497
  • 1
  • 5
  • 24
0
votes
1 answer

postgresql: Failing to connect locally via pgadmin3 (and phppgadmin)

I am able to connect via command line but getting the usual error message in pgadmin3. Error connecting to the server: FATAL: password authentication failed for user "postgres" (and login failed in phppgadmin) I know there are several q/a about…
pkaramol
  • 16,451
  • 43
  • 149
  • 324
0
votes
1 answer

How to import a CSV?

I've got a CSV file that looks like this: id, name 0, A.D. TRAMONTANA 1, Abarth 2, Abbot-Detroit 3, AC ... I'm trying to import it into my table via phpPgAdmin. It gives me this error: SQL error: ERROR: column "id, name" of relation…
mpen
  • 272,448
  • 266
  • 850
  • 1,236
0
votes
1 answer

Phppgadmin sorting doesn't work

If I choose the table (or view) and take same conditions (WHERE) the result appears in internal sorting. But if I press column name (for sorting on that column) - it goes to schema page. This problem doesn't appears if I just take view the table (or…
Tomasz Brzezina
  • 1,452
  • 5
  • 21
  • 44
0
votes
0 answers

How to import dump.psql file to PostgreSQL?

I want to import dump.psql file to PostgreSQL. Postgres admin panel only supports executing sql files not psql. How can I do this?
gprtskh
  • 29
  • 2
0
votes
1 answer

phpPgAdmin access denied for remote access on ubuntu 14.04

I've looked at quite a few answers for this, but all seem apparently out of date. I'm using Ubuntu 14.04 and Apache 2.4.7. My /etc/apache2/conf.d/phppgadmin file looks like this: Alias /phppgadmin /usr/share/phppgadmin
eriophora
  • 999
  • 1
  • 8
  • 20
0
votes
1 answer

Fedora cannot log into phppgadmin, but to psql

I have fedora 21 and I want to access postgresql db using phpPgAdmin. To do it I have installed httpd and phppgadmin, postgresql too. I can log with no problem to pgql using for example psql -U learning -W template1 or psql -W template1 but when I…