Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [postgresql]

PostgreSQL is a community developed, open source, relational database, made available under a BSD-like license. The PostgreSQL documentation is expansive and incredibly useful.

0
votes
0answers
7 views

Barman configuration does not work

I'm using barman in a virtual environment and i wanted to make barman use a specific configuration file I created before, ending with ".conf". The problem is, that the command "barman -c CONFIG" does ...
0
votes
0answers
3 views

Getting unfamiliar error when using terminal command to update database [migrated]

I'm a bit in over my head when it comes to using and managing large databases. I run a small startup that uses a PostGres SQL and PGAdmin to administer and query the database, which is housed on ...
0
votes
0answers
9 views

Rsync backup from PostgreSQL with Barman on same server?

I have at work only one server to disposal an i want to ask if it is possible to backup my PostgreSQL with the backup-program Barman, where both programs are located on the same server. Is it still ...
0
votes
0answers
38 views

The trustAnchors parameter must be non-empty in Windows Server

I have installed Java SE Runtime Environment 8 Update 65 (64 bit) on Windows Server 2012 r2 x64 (for specific requirements of web application) list of applications involved: apache-tomcat-8.0.30 ...
0
votes
1answer
10 views

How can I drop a PostgreSQL table with double quotes in its name?

I've inadvertedly created the following table, which I can't remove: db=> \dt List of relations Schema | Name | Type | Owner --------+-----------------...
0
votes
0answers
27 views

Port 5432 is already in use- mac os -?

yesterday I downloaded MySQL and deleted it. today I downloaded pgSQL and it gives me this error.
0
votes
0answers
9 views

Is AgensGraph applied with PostgreSQL 11.x?

I know the AgensGraph is based on PostgreSQL and saw the v2.1 release news. I'm wondering if PostgreSQL 11.x has been applied to AgensGrpah v2.1. Is AgensGraph going to be applied PostgreSQL's ...
0
votes
1answer
37 views

How to install postgresql-contrib-11 on CentOS 7?

So, I was trying to install extension citext on PostrgeSQL 11.1, but of course I've encountered an error: ERROR: could not open extension control file "/usr/pgsql-11/share/extension/citext.control": ...
1
vote
1answer
19 views

How to use a postgres base from an older version?

I've been sent a data folder for a postgres v8.4 server. I only have a v11 server and it does not let me start the base, printing that the database files are incompatible with the server because it ...
0
votes
0answers
39 views

pgAdmin 4 error with PostgreSQL binary installation

I have started PostgreSQL with binary installation. The server has been started successfully and I can access the server from outside. But if i wanted to run pg admin 4 with PostgreSQL zip file then i ...
0
votes
1answer
41 views

Unable to install Postgres extension pg_prometheus and prometheus-postgresql-adapter manually on CentOS

I am trying to setup Prometheus with PostgreSQL DB on a CentOS server. I am able to install Prometheus and PostgreSQL on the server but unable to install pg_prometheus extension and the prometheus-...
0
votes
2answers
41 views

Postgres Authentication Fails When Starting Dajngo

I am in the process of restoring my Django development server to another virtual machine. I have set up Django, Postgres, installed the GIS extensions and restored the database. When I run the server,...
0
votes
0answers
16 views

CentOs 7 Apache 2.4 PostGresql 9.2

I have a virtual machine with CentOS 7. I have installed Apache, postgresql and bugzilla. I Unfortunately apache can not connect to postgresql. the connection is denied. Coudl you help me please ? ...
1
vote
0answers
26 views

Connection to server fails after rebooting even though can log into it

I have been having problem with the electricity going off often for 3 hours and more at a time and the UPS i have is not enough. When the UPS runs out then the servers switch off. When the electricity ...
0
votes
1answer
84 views

Remote connection to PostgreSQL between Mac and Windows PC through router not working

I have 2 laptops: one is Mac that running PostgreSQL and another one that runs Windows 8.1. On my Windows box, I installed ODBC driver for PostgreSQL. Next I modified the postgresql.conf and pg_hba....
0
votes
0answers
25 views

Metasploit / postgresql / armitage problems

I've been trying to get armitage working for a while now and I cant seem to find the exact answer to the problem I'm having so here goes. When I open armitage it fails to connect to the database and ...
1
vote
2answers
448 views

Wildfly 14 Connect to Remote PostgreSQL “WFLYJCA0047: Connection is not valid”

I have installed a new WildFly instance on CentOS 7. I'm trying to create a connection to a remote PostgreSQL instance. The way I do it is by deploying the PostgreSQL JDBC jar to WildFly, and create ...
0
votes
0answers
38 views

DRBD - /dev/drbd0 is missing after reboot

I've found out that block file /dev/drbd0 was missing after reboot Please advice. lrwxrwxrwx 1 root root 10 Oct 24 15:20 pgsql -> /dev/drbd0 You have new mail in /var/spool/mail/root [root@...
0
votes
0answers
22 views

How to start a PostgreSQL server through pg_ctl and leave it running in the foreground/don't daemonize it?

I'm familiar with the postgres command and am sure that I understand how to run it through pg_ctl. I'd like to use the latter approach in order to have unified command structure and be able to wait ...
0
votes
1answer
208 views

Unmet dependencies for PostgreSQL 10 under Ubuntu 16.04.5 LTS (xenial)

Following official instructions in https://www.postgresql.org/download/linux/ubuntu/, I got following error: The following packages have unmet dependencies: postgresql-10 : Depends: postgresql-...
0
votes
0answers
11 views

Improve Linux Security by using specific groups for database and server

To improve security I want to create 2 groups, as following: database_group can start,restart,stop the Postgresql server can modify the Postgresql configuration files from /etc can't uninstall, ...
0
votes
1answer
36 views

Catching a bash command error in a variable

I'm using psql(PostgreSQL) command in a bash script: function create_database () { sudo -u postgres psql -c "CREATE DATABASE $1 WITH OWNER $2;" 2>ERROR if [[ $? -ne 0]; then ...
0
votes
0answers
567 views

Uninstall PostgreSQL BigSQL Distro 10.5.1

Have installed the BigSQL PostgreSQL distro version 10.5.1. Wanted to uninstall from a Windows 10 machine. Using Add/Remove programs; error message on remove => Unable to locate uninstall.dat I ...
1
vote
1answer
339 views

How to programmatically check if database and/or user exists in a PostgreSQL database using Bash?

I want to write a bash script that creates multiple users and a database. First I want to check if user exist, so I tried sudo -u postgres psql -c 'SELECT 1 FROM pg_roles WHERE rolename=${VAR_USER}' ...
1
vote
0answers
16 views

PostgreSQL Native Replication | Master - Master

I am configuring a high availability environment with Debian 9.4 machine, in which I have a Heartbeat working and need to include native PostgreSQL 9.6 replication, but by default this method of ...
0
votes
0answers
323 views

Unable to install PostgreSQL on Win10 due to getlocales.exe

I am unable to install multiple versions of PostgreSQL (ranging from 9.4.x and higher) on Windows 10, downloaded from here, each one reporting the same error: Any idea on how to get over this? I was ...
1
vote
1answer
53 views

How to create an odbc string connection in an excel spreadsheet to make it portable instead of setting up an odbc connection on every computer?

I'm setting up an excel reporting using Excel 2013 for that. The spreadsheet is retrieving data, through an odbc connection that I need to set on every computer in order to retrieve the data. I ...
0
votes
0answers
67 views

How to improve PostgreSQL database backup script - used with crontab

There are about 15 databases to backup on a daily basis. Password is set for the postgres user. pg_dumpall is executed at the beginning of the script for a complete backup. pg_dump is ran in the same ...
0
votes
0answers
45 views

Error launching pgadmin in ubuntu

I installed pgadmin4 on xenial as it was mentioned in the site. I did as instructed, and the installation was successful, but, the following two errors cycle around and I can't launch pgadmin at all: ...
0
votes
1answer
466 views

Upgrade postgresql 9.4 to 9.6 on debian stretch (9.0)

I want to upgrade my PostgreSQL 9.4 cluster to PostgreSQL 9.6 since upgrading debian to 9.0 (stretch) I lost PostgreSQL 9.4 however and it's also not in the repos anymore. Without PostgreSQL 9.4 I ...
-2
votes
1answer
44 views

How can I make a table_query.sql?

https://github.com/blobmon/simplechan I am going to the street on the above site. Now I am making databases and users. Come out of psql by pressing ctrl + D and also come out of postgres user by ...
1
vote
1answer
392 views

Fedora 28 cannot upgrade Postgres to 10

When starting the Postgres server on Fedora 28, I get this error: May 25 14:36:14 localhost.localdomain systemd[1]: Starting PostgreSQL database server... May 25 14:36:14 localhost.localdomain ...
0
votes
0answers
250 views

I get “rsProcessingAborted” and “rsErrorExecutingCommand” randomly in my SQL Server Report builder report

I have a report in which I get randomly the following error after pressing the "View Report" button (because in this report I need to select a parameter value from the dropdown field first): An error ...
1
vote
1answer
362 views

Connecting to a postgresql instance running on VirtualBox

I have a VirtualBox VM running locally that has postgresql 9.6 installed on Windows 10. I am able to connect to the instance with pgadmin on the virtual machine. I am trying to connect to that same ...
0
votes
0answers
151 views

How can I find out why the Nextcloud console installation does not generate tables in ProstgreSQL?

I have been trying to install Nextcloud on my Alpine-Linux-based server using the occ maintenance:install --database "pgsql" --database-name "dbname" ... command, but I am only greeted with exceptions....
2
votes
6answers
7k views

How to Fix the pgAdmin 4 v3.0+ Port Number

I just installed PostgreSQL 10.4, and noticed that the pgAdmin 4 v3.0 interface packaged with that version uses a local web server and browser interface. By default, the application appears to use an ...
1
vote
5answers
3k views

PostgreSQL 10 Does Not Start Under Ubuntu 18.04

In my fresh Ubuntu 18.04 -- $ lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 18.04 LTS Release: 18.04 Codename: bionic Installed PostgreSQL 10 -- ...
0
votes
0answers
39 views

PostGIS on Fedora27

I'm trying to get PostGIS installed on Fedora27 and Postgres 9.6. When doing this on Windows, I can just use the Stack Builder, but that doesn't appear to be a utility available on the Fedora ...
0
votes
1answer
45 views

summation of total hours of an attribute (timestamp without time zone) using postgreSQL

I wrote the following SQL query while I was trying to sum up the following column, but I had errors and it is not executing.. any ideas .. SELECT NUMTODSINTERVAL(SUM((TO_NUMBER(SUBSTR(sensor....
0
votes
1answer
1k views

Why can't I connect to PostgreSQL (localhost server) when my VPN is active?

I just wasted an hour of my life trying to figure out why pgAdminIII couldn't connect to the server on localhost. After trying config edits, starting/stopping the postgresql service, etc., I finally ...
0
votes
0answers
33 views

How can I add the pg-upgrade tool to gitlab-ctl? “gitlab-ctl status” works but “gitlab-ctl pg-upgrade” doesn't

I have to upgrade postgresql to upgrade git. To do so, people say "run gitlab-ctl pg-upgrade" but when I do so it tells me "I don't know that command." plus the list of options available for the ...
0
votes
0answers
121 views

Docker won't install on Ubuntu 14.04 due to Postgresql problems?

I'm running Ubuntu 14.04 LTS. When I try to install docker on it, I get the following errors. I've had these errors before. They started when I upgraded to PostgreSQL and somehow the 9.3 version is ...
0
votes
1answer
1k views

delete a row with pgadmin III

For something so obviously obvious I just can't do it at all. How can I just delete one row without doing the command manually.
0
votes
2answers
736 views

Restart Azure postgresql database

I have to change the max_prepared_transactions setting in azure what require a restart or reload config. Unfortunately I can not restart the postgresql database because Azure doesn't support it. ...
1
vote
0answers
29 views

Update database from PostgreSQL 8.3.8 + PostGIS 1.3.5 to PostgreSQL 10.1 + PostGIS 2.4

I inherited an old server (Ubuntu 12.04.5) with a database running on PostgreSQL 8.3.8 with the PostGIS 1.3.5 Extension. This server is going to be replaced by a new server (4.14.12-1-ARCH) where I ...
2
votes
0answers
134 views

Debian install of PostGIS extension is installing X packages

I'm trying to install PostGIS on a Debian server running Stretch. I installed PostgreSQL on it without any problems, but when I try to install the package postgresql-9.6-postgis-2.3, the latest ...
-2
votes
1answer
241 views

Logrotating postgres logs

My PostgreSQL log is writing as a single file. Its becoming bigger and bigger day by say as postgresql.log. I can see logging_collector is set as ON and log_rotation_age is also set to 1 day. Still ...
0
votes
0answers
159 views

Postgresql 10 can't start server ERROR: streaming fail

Basically I've shutdown the server, didn't make a dump before... Then start it again and it won't startup anymore. The problem seem to be a the replication, is there a way to remove this before ...
1
vote
0answers
437 views

Postgres won't start after blackout

My Postgres service was running when a blackout happened and now it won't start anymore. After starting the computer again, I noticed that the service was not up and running, so I tried to manually ...
1
vote
2answers
1k views

PostgreSQL on Windows: psql expects me to log in with my Windows account

I've just installed PostgreSQL 9.6 on Windows 7. I had to choose a password for the default user "postgres" during the install process. Running pgAdmin4 after the install, I typed in my password for "...