Stack Overflow
Stack Overflow

Questions tagged [pgadmin-4]

pgAdmin 4 is an Open Source administration and development GUI for PostgreSQL.

pgAdmin 4 is a complete rewrite of pgAdmin 3.

pgAdmin4 is cross platform (i.e., Linux, FreeBSD, Solaris, macOS and Windows) and supports PostgreSQL v9.2 and above.

It is available as separate download https://www.pgadmin.org/, but also included in PostgreSQL https://www.postgresql.org/.

1180 questions
-1
votes
1 answer

pgAdmin 4 (Mac): I Lost My Tree Where I Can Access My Servers

Earlier today I was able to view my server tree. I clicked something I supposed before I closed the application. I thought that maybe something else happened so I cleaned my Mac Mini Server. I still had the problem along with none of the dropdown…
Pamela Cook - LightBe Corp
  • 3,912
  • 5
  • 50
  • 86
-2
votes
1 answer

Error while trying to configure Python environment for pgAdmin4 on WSL 2

I'm trying to install pgAdmin4 from its source code on WSL 2 (running Ubuntu 22.04 (Jammy Jellyfish) distribution), and I've been following the steps in the README document in pgAdmin4's GitHub repository. To configure the Python environment, I've…
Emmanuel Allison
  • 56
  • 1
  • 6
-2
votes
1 answer

Is it good practise in PostgreSQL to add extra foreign keys columns for a speedy lookup?

When I make ER diagram in MySQL Workbench the software makes automaticly multiple foreign key columns where I would have expected just one foreign key: In the image you see the following foreign keys with multiple columns: fk_city_state1 in table…
DevQandA
  • 51
  • 6
-2
votes
1 answer

I am trying to practice for sql using pgadmin with northwind database please check images for what i am trying to do

[enter image enter image description heredescription here](https://i.stack.imgur.com/g62jB.png) please help me out i tried to restart the pgadmin also tried other column from same table nothing worked
rockslusture
  • 1
  • 2
-2
votes
2 answers

Get IPAddress of a podman container

I'm trying to connect connect my postgre DB (in a container) using pgadmin (in a different container). I tried using the inspect command but the IPAddress is just an empty string: $ podman inspect serene_lovelace | grep -i ipaddress returns …
Topaz Rindu Nabiyallah
  • 13
  • 4
-2
votes
1 answer

pgadmin4 inside a Docker container doesn't login

when i tried to login in pgadmin4 with this credentials i get this error Unable to connect to server: connection to server at "db" (172.18.0.3), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP…
Wruce Bayne
  • 7
  • 1
-2
votes
1 answer

Why can't I edit user privileges in pgAdmin 4?

Everything is in the title: I can't edit user privileges in pgAdmin 4. To be more precise: I launch pgAdmin 4, enter the global password, enter the server password, click on Login/Group Roles, click on the user for which I want to edit the…
Takamura
  • 347
  • 5
  • 12
-2
votes
2 answers

SQL Query for joining 5 tables

I have five tables: Cutomer(CustomerID, name, surname) PaymentMethod(cardNo,securityCode,expirationDate) Ticket(ticketID, parkingnumber) Has(CustomerID, CardNo) Reserve(TicketID,cardNo) How can I write SQL query in pgadmin-4 for listing the…
Yasemin Eldayih
  • 1
-2
votes
1 answer

Can't connect to postgres via PSQL or php, only pgAdmin4

I have PostgreSQL 12 installed and using Windows 10. My goal is to connect to postgre via php, because it didn't work I tried with plsql but it didn't work either, i always get (with both plsql and php using PDO): FATAL: password authentication…
MasterPaw
  • 3
  • 2
-2
votes
1 answer

How to view pg_dump data with .sql extension?

I have downloaded pg_dump data from DeepDive Open Datasets. It is a file with extension .sql and to my knowledge that is a text file with SQL commands in it to recreate the database. I'm trying to peruse the data. How do I set up a Postgres database…
jzm5
  • 31
  • 4
-2
votes
3 answers

FATAL: password authentication failed for user "postgres" pgadmin4

I'm using postgresql 12 with pgadmin4 on ubuntu 20.04. I'm having an issue with creating a new server. I don't remember specifying any password during installation but now i don't know what the password is and whatever i try to put it just gives a…
Zamran Butt
  • 1
  • 1
-2
votes
1 answer

Docker/PostgreSQL creating server using pgadmin4 and having a user problem

After some problems i removed the postgres container and pgadmin and recreate them and after it i try to create a server and the error was shown to me FATAL: password authentication failed for user "postgres". I saw some things here in the…
Messias
  • 1
-2
votes
1 answer

Counting the max value in SQL (PostgreSQL)

I have a database with 3 tables (customers, tickets, company_transactions). customers(customer_id, full_name) tickets(ticket_id, type, price, start_date, end_date, category) company_transactions(transaction_id, customer_id, ticket_id, purchase_date,…
npateras
  • 9
  • 5
-2
votes
2 answers

Golang and accessing postgres via a client in an Ubuntu VPS?

I'm trying to follow the digital ocean tutorial on configuring pgadmin4 in server mode, but damn it is long, and I have to first configure apache server, python and virtualenv (via other 2 tutorials). I don't want to install so many dependencies in…
CommonSenseCode
  • 23,522
  • 33
  • 131
  • 186
-2
votes
2 answers

parsing Json objects in array into relational objects and fields

Hi I need to parse the json objects under operationsList array into relational fields and objects but the trick here is the sample I pasted had seven objects under the operationsList array, my code is able to parse each json object individually but…
sreecharan rao yadagiri
  • 1
  • 2
1 2 3
…
78
79