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
32
votes
3 answers

Login disallowed for security reasons postgresql centos server

I am configuring my centos server. I installed postgresql and phppgadmin When i try accessing phppgadmin as my_server_ip/phpPgAdmin It redirects to login page and when i try to login getting error as Login disallowed for security reasons I even…
Prabhakaran
  • 3,900
  • 15
  • 46
  • 113
29
votes
3 answers

How can I change database encoding for a PostgreSQL database using sql or phpPgAdmin?

How can i change database encoding for a PostgreSQL database using sql or phpPgAdmin?
daniels
  • 18,416
  • 31
  • 103
  • 173
24
votes
3 answers

Login to PostgreSQL - Login failed

I installed psql and phpPgAdmin to my Ubuntu11.10 and don't know how to run it. What is the default username and password?
Ivan Z. Horvat
  • 385
  • 1
  • 4
  • 14
18
votes
3 answers

Postgres sql insert query syntax error from phpPgAdmin

Trying to execute a standard insert query, but it doesn't work. INSERT INTO users (vk_id, eu_name, eu_society, eu_notes, eu_want_team) VALUES ("123123133","Eu name","Eu society","Eu notes","true") The error I get is the following: ERROR: syntax…
user2705406
13
votes
2 answers

How to generate a CREATE script for several tables in pgAdmin III?

In pgAdmin III you can: right-click a table; scripts; CREATE script; save the script from the SQL Editor. If one has to do this for more than one table, is there a way to combine the scripts in one file (apart from manually copy-pasting them)? If…
Alexander Popov
  • 23,073
  • 19
  • 91
  • 130
10
votes
3 answers

/phppgadmin Forbidden You don't have permission to access /phppgadmin/ on this server

I recently upgrade my server from Debian Wheezy to Debian Jessie (Debian 8). A lot of packages was updated and now, I don't have the right to access to phppgadmin from http://myIP/phppgadmin Forbidden You don't have permission to access /phppgadmin/…
Macbernie
  • 1,303
  • 6
  • 24
  • 48
9
votes
1 answer

How to create read-only user in pgAdmin 4?

Creating a read-only user in pgAdmin 4 is a little tricky. Here is a guide on how I did it. First of all a few words about the process. The whole process is based on editing a schema (very simple and safe) for your DB, so this creates limitations…
Arsenii
  • 655
  • 1
  • 8
  • 20
9
votes
2 answers

show executed query in phpPgAdmin

Is there a way to show the SQL query executed by phpPgAdmin as the way phpMyAdmin does? For example, if I modify a column, it should show the ALTER command being executed. If this is not possible, what other interface could I use to get this…
juanefren
  • 2,818
  • 6
  • 32
  • 41
8
votes
3 answers

How to print the table structure from postgresql?

I am using phpPgAdmin in the browser and PgAdmin III for Windows. Is there anyway to take the printout of the table structure for the entire database?
svk
  • 4,513
  • 18
  • 63
  • 100
8
votes
2 answers

importing osm file into a postgres/postgis database

Im using the tool osm2pgsql to import an osm file into a postgres database using phppgadmin as the administrative tool. i have only downloaded a small town from osm in xml format and im having trouble importing it using the terminal on mac. Im a bit…
John
  • 619
  • 2
  • 9
  • 24
8
votes
4 answers

Error on creating database in phppgadmin

I have PostgreSQL 9.2.0. On clicking create database it shows following error: SQL error: ERROR: column "spclocation" does not exist LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio... …
Gagan Deep
  • 489
  • 1
  • 4
  • 16
7
votes
1 answer

Use for the phppgadmin Reports Database?

Phppgadmin comes with instructions for creating a reports database on the system for use with phppgadmin. The instructions describe how to set it up, but do not really give any indication of what its purpose is, and the phppgadmin site was not very…
kaybenleroll
  • 16,794
  • 16
  • 54
  • 66
7
votes
3 answers

How to fix “ERROR: column relhasoids does not exist” in phpPgAdmin?

I'm updating a Linux server with a new version of PostgreSql and I have an Error Message in phpPgAdmin when I browse a table. The Ubuntu 18.04.3 LTS server running Apache 2.4.41, PHP 7.3.11 and when I update to PostgreSQL 12.0 and phpPgAdmin 7.12.0…
Luis Cedeño
  • 211
  • 1
  • 2
  • 10
7
votes
6 answers

Installing phpPgAdmin 5.1 on Ubuntu 16.04 with PostgreSQL 10 not supported

Install based on https://www.howtoforge.com/tutorial/ubuntu-postgresql-installation/ in my ubuntu 16.04 Log into http://localhost/phppgadmin/ PostgreSQL, browser show Version of PostgreSQL not supported. Please upgrade to version or later. Any…
Ong Ming Soon
  • 1,041
  • 1
  • 10
  • 22
7
votes
5 answers

Access phppgadmin from another computer?

I have installed phppgadmin in a Ubuntu server and want to access it from another computer. It said access denied when i typed: http:///phppgadmin The port 5432 is opened in the Ubuntu server but just for local ip. Thanks
never_had_a_name
  • 90,630
  • 105
  • 267
  • 383
1
2 3
…
10 11