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

How do I create and edit composite types in phpPgAdmin?

An old changelog for phpPgAdmin says that there is an interface for creating and editing composite types, but I can't find it anywhere. Is there a GUI for this in phpPgAdmin?
Miloš Rašić
  • 2,229
  • 5
  • 24
  • 43
1
vote
1 answer

Odoo 12 encoding latin1 unable to resolve

I have installed Odoo12 on Ubuntu 18.04 using installation script Odoo Install The server started successfully and when trying to create the first database, the error below showed up. Database creation error: encoding "UTF8" does not match locale…
mohammad khamis
  • 23
  • 1
  • 8
1
vote
1 answer

Phppgadmin, No objects found

I am trying to get my localhost db listed in phpPgAdmin, but it says No object found phppgadmin GUI I have already configured conf/config.inc $conf['servers'][0]['desc'] = 'PostgreSQL' $conf['servers'][0]['host'] =…
Goran
  • 127
  • 1
  • 10
1
vote
2 answers

php pgadmin remote db connect failure

I want to connect to remote database from php to postgres but it could not connect and says Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: could not connect to server: No route to host (0x00002751/10065)…
d-man
  • 57,473
  • 85
  • 212
  • 296
1
vote
0 answers

Importing sql dump from postgresql 9.6 to postgresql 10

I have a website with a Postgis database. I access to it with phpPgAdmin with postgreSQL 9.6. I want to export my database to keep a local backup. I exported it like that: Then I want to import it in PgAdmin 4 v2.1, with PostgreSQL 10. In my SQL…
J.Delannoy
  • 345
  • 5
  • 15
1
vote
1 answer

Unable to Install phppgadmin on ubuntu 16.04 server

I am trying to install phppgadmin on my ec2 instance which have ubuntu 16.04 and apache. The steps which I followed are : sudo apt-get -y install postgresql-contrib phppgadmin Edit /etc/apache2/conf-available/phppgadmin.conf and replace the line…
iit2011081
  • 742
  • 8
  • 26
1
vote
1 answer

postgreSql “relation does not exist” even though in phpPgAdmin works

Hello I have a database that has 12 tables. I can select everything from 11 of them but using the same query for the 12th doesn't work. But if i try that query from phpPgAdmin then it works. For example I have this query: SELECT …
Alfred
  • 59
  • 11
1
vote
2 answers

How to add comment to an existing table in Rails 5.0?

I am working with a ROR project, and I want to add comments to each tables. I can do this directly by altering the tables in phppgadmin, but I want to do this using migrations. I have searched a lot but no luck. I tried to do the same in the…
Amrinder Singh
  • 5,300
  • 12
  • 46
  • 88
1
vote
0 answers

Cannot connect to database phppgadmin

I cannot connect to the database. I already have phppgadmin and made a new database and table already. In my php file i encoded:
grace d
  • 39
  • 5
1
vote
1 answer

phpPgAdmin on OpenShift is not accessible from application URL

Installed this (https://github.com/BanzaiMan/openshift-origin-cartridge-phppgadmin) to my Tiny Tiny RSS application on OpenShift to manage my database.* However, after the installation and a few restarts, .../phppgadmin/ URL gives me 404 error. Any…
nCoM1kWuDFIjxZNd2zoE
  • 49
  • 1
  • 6
1
vote
1 answer

PhpPgAdmin Syntax error when creating View

I am attempting to create a View in PhpPgAdmin (PostGreSQL db) which has the following SQL statement: DELETE FROM myTable WHERE myTable.error IS NULL; PhpPgAdmin gives me the following error: ERROR: syntax error at or near "DELETE" at character…
Ted1391
  • 139
  • 3
  • 12
1
vote
2 answers

Vagrant shell provisioning phpPgAdmin password

How would I get my Vagrant shell script to supply the password when creating a user while provisioning phpPgAdmin? ie. when I supply this command sudo htpasswd -c /etc/phppgadmin/.htpasswd vagrant it prompts for a password for the vagrant user so I…
bordeltabernacle
  • 1,603
  • 5
  • 24
  • 46
1
vote
1 answer

postgreSQL dump file generated when exporting is blank

I have a database named housing that I want to export. However, everytime i export it, it generates a blank dump file. I cannot identify what I've been doing wrong. Please help. I'm trying using phppgadmin, I clicked export, selected SQL, structure …
user2332475
  • 43
  • 1
  • 6
1
vote
1 answer

Why am I getting a syntax error on my PostgreSQL SQL?

CREATE TABLE members ( memberID SERIAL, username VARCHAR(255) NOT NULL, password VARCHAR(60) NOT NULL, email VARCHAR(255) NOT NULL, active VARCHAR(255) NOT NULL, resetToken VARCHAR(255) DEFAULT NULL, resetComplete…
Jared
  • 81
  • 1
  • 2
  • 6
1
vote
1 answer

install openshift phppgadmin cartridge failed: manifest not available. why?

I tried to install phppgadmin. I got manifest was not available (status code: 404). May I know why? rhc cartridge add https://github.com/BanzaiMan/openshift-origin-cartridge-phppgadmin.git/metadata/manifest.yml -a python The cartridge…
hosais
  • 164
  • 1
  • 1
  • 10
1 2 3
…
10 11