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 v3.0 and v3.1 doesn't load (crashes) on Windows 10

I tried to google issue, but I couldn't really find any help or solution that would work. It is trying to load - loading box appear, but app doesn't appear after that. There is no log in "%APPDATA%\pgAdmin\pgadmin4.log" file or any error. There is…
RaV
  • 1,029
  • 1
  • 9
  • 25
0
votes
1 answer

Postgresql Error - Function return type mismatch

I'm looking for some help with a SQL function I am defining under pgAdmin3 for PostGreSQL. It is a simple function supposed to calculate a ratio given a certain id but when I try to add the function, I get an error message. Here is the code for the…
Frost
  • 25
  • 10
0
votes
1 answer

Postgresql: Querying Varchar Requires Curly Braces?

EDIT: This was an issue of pgAdmin4 displaying I could change my previously declared column data type of character varying [] to character varying (when the user could never do that), leading me to believe I was querying for a varchar, when in…
Dylan Landry
  • 1,150
  • 11
  • 27
0
votes
0 answers

PG ADMIN aquires a lock on a table on execution of a select query

A select query was run on a table using PGAdmin and then after few hours we see that the application doesn't respond to any request to be processed. Found a lock attained on the same table the select query was executed when checked the db. we had to…
Sreeja Nair
  • 1
  • 1
0
votes
0 answers

Python 2.7, PgAdmin III & BASH 4.3.48: Error Invalid Provider when running py script inside bash script

This is my bash script; # Binarize raster for later polygon creation path=/home/rose/Desktop/test/DSM_BM24_2017_1000_4735.tif pathdir=$(echo $path | cut -d "/" -f 1,2,3,4,5) gdal_calc.py -A $path --outfile=$pathdir/binary.tif --NoDataValue=-9999…
Rose
  • 205
  • 3
  • 12
0
votes
1 answer

Create a pgagent job with pgAdmin

Why pgAdmin creates a new pgAgent job only on the Postgres db even though I specify the setting on another db?
teosantoro
  • 15
  • 1
  • 4
0
votes
0 answers

PostgreSQL, SELECT keeps adding Rows to Dataoutput

I have a Track-geometry table with a bunch of rows. My primary Key is the ID of the single track. Its Datatype is bigint. I got 4177 Rows in the table. Now when i do: Select * from mytable; it shows me the dataoutput with 4177 rows with the…
Tom Weber
  • 1
  • 1
0
votes
0 answers

Postgres update Query works in pgAdmin but fails from Java

Below is my query which works fine in pgAdmin UPDATE data SET data = data - 'dateAdded' || '{"dateAdded":1481500800000}' WHERE dtype='Customer' and data->>'id' = '00784591' The same query throws an error from my Spring Boot application.Below is…
T Anna
  • 874
  • 5
  • 21
  • 52
0
votes
0 answers

Exciting Data from live site add to pgAdmin

I would like to add existing database from our live site into pgAdmin. I have downloaded the file from our live site. I have pgAdmin set up with the databases (development and test) how do I add the existing database data to pgAdmin?
Stephanie
  • 105
  • 1
  • 10
0
votes
1 answer

selecting a specific number from a column in a table into another table

I have a table called processtime id | task1id | task1occ | task1time | task2id | task2occ | task2time | task3id | task3occ | task3time | task4id | task4occ | task4time | task5id | task5occ | task5time…
David B Jones
  • 119
  • 1
  • 1
  • 10
0
votes
1 answer

Update a table (Database1) from the same table (Database2) in Postgresql

I have two databases with similar data but what I want to do is to update the changes of sample_table from Database2 to sample_table of Database1. Example: Database1 [sample_table] ID Reference Name 0001 Ref0001 Test1 0002 …
7Eleven
  • 1
  • 6
0
votes
1 answer

Error backup PostgreSql DB's using PGAdmin in AWS

I am getting this error when trying to backup the data bases in the PGAdmin of PostGreSql to my computer: pg_dump: [archiver (db)] query failed: ERROR: permission denied to set role "xxx" pg_dump: [archiver (db)] query was: SET ROLE xxx I can read…
asaf
  • 958
  • 1
  • 16
  • 38
0
votes
0 answers

EC2 Security Rule for Connecting to DB from PgAdmin?

I can connect to my AWS EC2 database from SSH. Now I'm trying to connect to it from pgAdmin. I've watched YouTube videos about it and read SO posts as well, but evidently I'm still missing something, as I am still getting: Here's my rule: I got…
VikR
  • 4,818
  • 8
  • 51
  • 96
0
votes
0 answers

Server doesn't listen (PosgreSQL)

I'm getting Server doesn't listen (Img1) every time a try to connect to db server in pgAdmin III. It started after a network adjustment related to local machines IP number in our company. I'm also receiving Error connecting to the server.…
Thiago Resende
  • 177
  • 1
  • 1
  • 8
0
votes
0 answers

Duplicate the Database of Sage Server on PgAdmin

Have you any idea about how to duplicate the Database of Sage Server on PgAdmin? I did this with SSMS and it works but i want to get it with PgAdmin. Otherwise, can we add a microsoft database to pgadmin?
Khouloud LenGliz
  • 11
  • 5
1 2 3
…
99
100