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

pg_restore: [directory archiver] could not open input file. Error while trying to restore DB

Error when trying to restore a backup file(.nb3). I did a database backups in Navicat, one backup for each schema. They are .nb3 files. I tried to restore my DB on a local server using pgAdmin. I got an error like this after choosing backup file…
Guga Todua
  • 462
  • 2
  • 11
  • 27
0
votes
1 answer

What does `-Fp` mean for pg_dump option?

When i look up Moving a database with pg_dump and psql -U postgres db_name < ... results in "ERROR: relation "table_name" does not exist" and found -Fp option from @John P 's answer I have look up for documentation…
Peera
  • 99
  • 1
  • 1
  • 9
0
votes
0 answers

Unable to connect server despite deleting all instances and doing a fresh install of both postgresql and pgadmin 4

I have been getting this error recurrently when my server refuses connections. I usually did a fresh installation of postgres to delete all configuration files and restart the server but now its not working. Here is a screenshot of the terminal…
Aneek Roy
  • 43
  • 2
  • 9
0
votes
0 answers

Error importing CSV file with data in mm:ss.0 format when used timestamp without timezone

Received a CSV file which I am trying to import into PostgreSQL. One column called "created_date" has a mm:ss.0 format when viewed in Excel. I was asked to import this column with a "timestamp without timezone" datatype. But on doing so get the…
dhu
  • 11
  • 3
0
votes
0 answers

View data on PostgreSQL database in Ubuntu

I am running a Django based website on a Digital Ocean Ubuntu droplet, using PostgreSQL. The site is running and data is being stored in the database successfully. How do I view the data in the database? I was able to do this easily using PGadmin on…
MattG
  • 1,682
  • 5
  • 25
  • 45
0
votes
1 answer

Problem with postgresql and pgadmin docker containers

I'm trying to connect postgresql and pgadmin4 work together. pgadmin4 works fine but when I try to create a new server I have 2 problems: if the postgres container is at other port that is not 5432 it dont recognize that port. It show this error:…
Schwarz54
  • 964
  • 1
  • 9
  • 18
0
votes
0 answers

Is there a COPY command equivalent for unselecting columns in pgAdmin whose values are meant to be default?

Several of my tables have fields with default values, including this one: CREATE TABLE IF NOT EXISTS checks ( shipmentid INT NOT NULL, status VARCHAR(10) DEFAULT 'COUNTED' NOT NULL, date DATE NOT…
Kevin Palembas
  • 13
  • 4
0
votes
0 answers

can not connect a DB instance Running the PostgreSQL Database Engine to pgadmin4

I want to configure Postgres with pgadmin on centos7. but unable to create a server on pgadmin. I edited file /var/lib/pgsql/data/pg_hba.conf as this : local all all md5 # IPv4 local…
hossein hayati
  • 1,088
  • 2
  • 15
  • 34
0
votes
1 answer

502 Bad Gateway with pgadmin4 behind nginx?

I have an api running in docker with: nginx nodejs api postgresql pgadmin4 certbot When I try to add an endpoint for pgadmin so I can work with the database, I get a 502 bad gateway regardless how I'm setting up the ports for proxy_pass or in…
SudoGaron
  • 339
  • 6
  • 22
0
votes
0 answers

How do I point two urls to different docker container locations in Nginx?

I can only seem to get the root(/) location to work in my nginx configuration. I get a error regardless of the location block I specify. webserver | 2019/04/25 14:20:48 [emerg] 1#1: unknown "url" variable webserver |…
SudoGaron
  • 339
  • 6
  • 22
0
votes
0 answers

Automatic running of SQL script when a new database is created

I need to run some SQL scripts (which are basically SELECT queries) every time some new data enters the database. When I say enters the database, I do not mean INSERT/UPDATE queries executed on an existing database/table(s), but rather every time a…
sujaypatil
  • 60
  • 1
  • 10
0
votes
1 answer

Access column array and store it in a new table

I have a table like this: | id | cars | owner | |----|--------------------------|----------------| | 1 | {tesla, bmw, mercedes} | Chris Houghton | | 2 | {toyota, bmw, fiat} | Matt Quinn | Is there a way to…
vkatsou
  • 73
  • 6
0
votes
1 answer

Sequelize association exists in pgAdmin but it keeps looking for unknown column during queries

I've been having trouble for a while trying to properly get my associations working. I have an Auctions model and a Bids model, the Auctions model has many Bids. There is the foreign Key "BidId" on Auctions that is linked to "bid_id" on Bids.…
Amon
  • 2,725
  • 5
  • 30
  • 52
0
votes
1 answer

Incorrect insert of bigint into JSONB column when using pgAdmin 4

I am observing weird behavior while inserting jsonb values that has bigint field. According to doc jsonb supports numeric data type so it should not be an issue. Table: CREATE TABLE document_wrapper ( id integer NOT NULL, document jsonb NOT…
iwek
  • 348
  • 4
  • 14
0
votes
0 answers

How do I make a php login page actually work?

I am having some trouble making my php login page, you know, actually login. I have created a database using sql with some login info and I am trying to display the information grabbed once the user logs in. For example once the user logs in I want…
user11234804
1 2 3
…
99 100