Questions tagged [phppgadmin]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
2answers
14k views

psql: FATAL: password authentication failed for user “postgres”

I am running postgresql-9.6 on Rhel7. I know that the default/root user doesnt have a password, however i will like to use phpPgAdmin to do my work. the problem is I have edited my pg_hba.conf file to ...
-4
votes
2answers
716 views

Auto fix the auto increment in MySQL [closed]

I have a table, and I have admin panel which can delete the records from the db, so that the ID becomes like 1, 4, 7, 9, 11, 24, etc. But am using the ID count for a chart. The problem is that I ...
0
votes
1answer
787 views

Cannot import database exported by phpPgAdmin

I have exported database with phpPgAdmin tool - format sql, structure and data. When I try to import this sql using: psql command \i filename.sql After some time (file is 2GB) I get following ...
1
vote
0answers
344 views

How to view phppgadmin as the application name in PostgreSQL's log files?

I am using PostgreSQL 9.2.2 (Windows) with phpPgAdmin 5.1. I need to monitor who connects to the server, and with which application. In the logging parameters of postgresql.conf, I use the following ...
1
vote
1answer
428 views

How to use language PL/PythonU on a PostgreSQL database via phpPgAdmin?

I am used to PgAdmin III where I can simply create python functions like the following on a PostgreSQL database: CREATE OR REPLACE FUNCTION pyHello (x integer) RETURNS void AS $$ if x == 1: ...
3
votes
1answer
9k views

How to set bytea_output to hex?

I cannot seem to change bytea_output to hex. I have tried this method: ALTER DATABASE dbname SET bytea_output TO 'hex'; I have tried to edit postgresql.conf bytea_output = 'hex' and restarted the ...
1
vote
1answer
1k views

phpPgAdmin does not see databases [closed]

When I go to databases in phpPgAdmin it says that there are 0 databases. Yet, if I run SELECT datname FROM pg_database it displays all databases OK. I would like to be able to 'explore' tables and ...