Stack Overflow
Stack Overflow

Questions tagged [pgadmin]

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

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL. There are native builds available for Linux, FreeBSD, Solaris, Mac OSX and Windows. Use it to manage PostgreSQL 7.3 and above running on any platform, as well as derived versions such as Postgres Plus Advanced Server and Greenplum database.

The graphical interface covers anything from writing simple SQL queries to developing complex databases. A new major version is usually released in connection with every major version of PostgreSQL and supports all PostgreSQL features. It includes an SQL editor with syntax highlighting and a graphical query builder, an SQL/batch/shell job scheduling agent, support for Slony-I replication engine, a scripting engine and much more. Connect to any server via TCP/IP or via Unix Domain Sockets on *nix platforms, optionally SSL encrypted.

pgAdmin is available in many languages. It is Free Software released under the PostgreSQL License. The latest version as of 2012-10-26 is 1.16.0

1862 questions
0
votes
1 answer

pgAdmin 4 Crashes on Query Builder (before executing query)

I am dealing with a frustrating issue (pgAdmin crashes on query builder) that is described in this question dealing with pgAdmin 3. The accepted answer gives the solution of deleting a file that was corrupted, but I can't find the file on Mac. I…
Douglas
  • 1,238
  • 5
  • 15
  • 27
0
votes
1 answer

How can I connect to local database on a windows machine from a tomcat server on Ubuntu in a virtual machine

I am trying to set up a server in a virtual machine using the Oracle VirtualBox. I use Ubuntu 18.04 LTS in the VirtualBox. I use PostgreSQL as my database. In my Tomcat, I have a property file where I provide the database URL and password. I want…
Geo Thomas
  • 1,139
  • 3
  • 26
  • 59
0
votes
1 answer

Ubuntu 18.04 & PostgreSQL 10.9: What do I fill in the Properties Form to Get Them to Connect?

I have PostgreSQL 10.9 and Ubuntu localhost installed on my machine. I downloaded pgAdmin III on my machine for the first time. I tried filling in the following based on a suggestion. I get the following error: Below is my config file:
PineNuts0
  • 4,740
  • 21
  • 67
  • 112
0
votes
1 answer

Can't load data in Windows PgAdmin using SQL

I am trying to load data from Gordon Linhoff's book "Data Analysis Using SQL and EXCEL" into a PostGres db via pgadmin on a Windows 10 system using the an SQL script file. Part of the SQL script is CREATE TABLE Customers ( CustomerId int NOT…
PetGriffin
  • 495
  • 1
  • 4
  • 13
0
votes
0 answers

Lost all databases in postgresql because of automatic recovery

What actually Happend: Running windows 7 on my system and system was shutdown due to power failure. when system restarted, I opened PostgreSQL and all my databases were deleted. I checked logs and there were some entries Database system was…
Zohaib Waqar
  • 1,204
  • 11
  • 18
0
votes
2 answers

docker: get container's external IP

Running several docker containers including postgres database remotely. $docker-compose ps Name Command State …
arilwan
  • 3,374
  • 5
  • 26
  • 62
0
votes
1 answer

Loading dblink.sql in Postgres 8.4

I found good article in dblink http://www.postgresonline.com/journal/archives/44-Using-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html, but got stuck on loading dblink.sql. Can anyone give me information on loading the dblink.sql into…
Rohita Khatiwada
  • 2,835
  • 9
  • 40
  • 52
0
votes
1 answer

Changing Dashboard Settings From Configuration File: PG Admin4

I am trying to find a way to easily deploy a change to everybody in my large group using PG Admin 4. Our goal is to reduce performance issues that can be caused by a few of the dashboard settings. I need to find the necessary file to change the…
SQLNOOB
  • 13
  • 3
0
votes
1 answer

How to automatically fill columns on a row based on the foreign key being the primary key on another table

I'm working on a sql database for QGIS. I have 8 tables: 3 three of them are the base tables and the others are relational tables. One relational table, "tabela_is_po", has 4 fields: indice_sequencial_po (integer and Primary Key), tema (character…
João Pinheiro
  • 1
  • 1
  • 1
0
votes
1 answer

What are some of the other viewer of Postgres that folks use?

I've been holding out on upgrading my Postgres installation because I don't want to use the new pgAdmin viewer. What are some of the other alternatives that people like?
Matt
  • 967
  • 2
  • 9
  • 23
0
votes
0 answers

Issue with importing database in pgAdmin (.sql format)

I'm trying to reload PostgreSQL database into pgAdmin. The base is in .sql format (db.sql) When I'm trying to reload it, the following problem appears: pg_restore: [archiver] input file appears to be a text format dump. Please use psql. I've…
Sammy Merk
  • 21
  • 8
0
votes
0 answers

How to connect pgadmin 4 to an external server?

I just created a server (droplets) in digital ocean, install postgresql, up there well, it works on the console. My problem is when I try to connect through pgadmin. could not connect to server: Connection refused (0x0000274D/10061) Is the server…
Jean Luis Soto Robles
  • 47
  • 3
0
votes
1 answer

Why are some fields not editable in pgAdmin?

Although I am logged in as Administrator user in pgAdmin4, and with an admin role inside my database, the edition fields are always disabled, as in: So I can't make modifications with the interface. Is there some knob to turn on somewhere to allow…
Qortex
  • 7,087
  • 3
  • 42
  • 59
0
votes
0 answers

How to Fix Postgres Numeric Auto Become 6 Decimal Places When Using Insert Into OPENQUERY from SQL Server

I found an issue of Postgres decimal places auto become 6 places when try to insert data from SQL Server into Postgres using OPENQUERY. I have searched many references that suggested using CAST or Convert to limit decimal places from SQL Server,…
Robert Chen
  • 1
  • 1
0
votes
1 answer

pgAdmin: Casting null JSONB to JSON returns connection closed

I was testing out some basic operations while working on a query to perform operations on a JSON column. When I ran this query: SELECT NULL::jsonb::json I received the following error message: Not connected to the server or the connection to the…
Lucat
  • 2,242
  • 1
  • 30
  • 41
1 2 3
…
99 100