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.

Filter by
Sorted by
Tagged with
-3
votes
0answers
27 views

Why do software authors seemingly pay little to no attention to the user's “maintenance experience”? [closed]

This could very easily turn into a "rant", so I'm just going to focus on a single piece of software: PostgreSQL on Windows. This database software is installed as a binary installer from a semi-third-...
0
votes
1answer
22 views

Getting correct PostgreSQL version on CentOS VM

I recently started a job as a PostgreSQL DBA and wanted to setup a virtual machine at home similar to what I'll be working with so I can start to play around with the system. I setup a CentOS 7 ...
0
votes
0answers
9 views

Creating a SQL trigger to update tables when entering data in a view [migrated]

If I have this setup: CREATE TABLE category( category_id serial PRIMARY KEY, category_name text UNIQUE NOT NULL -- must be UNIQUE ); CREATE TABLE parts ( part_id serial PRIMARY ...
0
votes
1answer
52 views

PostgreSQL Install Fail in Windows 10 (icacls error )

I am installing postgresql-12.2-4-windows-x64 on Windows 10 and get the following error. How to resolve?
0
votes
0answers
39 views

Will Windows 10 Proffessional allow to listen in more than 20 ports from internet

Windows 10 license allows no more than 20 connections for some ports: (iii) Device connections. You may allow up to 20 other devices to access the software installed on the licensed device for ...
0
votes
0answers
23 views

Power BI Google Cloud Postgresql 12 SQL SSL Connection Error

I'm trying to connect Microsoft's Power Bi to a Postgresql SSL database that I created on Google Cloud SQL (GCloud). As soon as you ask to generate the client cert it generates 3 .pem files: client-...
0
votes
1answer
32 views

How to connect to postgres server running on ec2 instance

I followed this guide to install postgres on an AL2 server and I have it running. On the server, I can run psql -d mydatabase and it works fine. But when I log off the instance and try to reach it ...
0
votes
0answers
35 views

How to shutdown pgAdmin 4 from the command line on Windows?

I already know how to do it in the GUI: you find the elephant icon in the Notification area, right-click it, and click "Shut down server". However, I have been unable to find any way to do the same ...
0
votes
1answer
991 views

how to setup scalelite load balanacer for bigbluebutton

Hello everyone i am just trying out bigbluebutton web conferencing system and would like to say it is amazing.So far i have set up a standalone bigbluebutton server with ssl and have configured ...
1
vote
2answers
16 views

How to backup and restore PostgreSQL instance, including role privileges?

I tried a bunch of different tutorials online, but they tend to omit the actual restore commands, or they reset role privileges back to nothing, or they use plain SQL backups in a way that errors (non-...
0
votes
0answers
18 views

Cannot add postgres container into pgadmin4 container

I'm fairly new to docker and I want to set up a PostgreSQL database and manage it with pgadmin4. Both in docker. Unfortunately, I cannot add the PostgreSQL database to pgadmin4 I created both ...
1
vote
0answers
24 views

postgresql: can't select DB from windows with a restricted access setup

I have a remote machine, that has to access a DB on my server. I explicitly granted access with: host dbname dbuser 192.168.1.0/24 md5 and when testing from another linux machine with the ...
0
votes
1answer
33 views

Windows new postgresql installation refusing every password

so I just installed Postgresql, sewt up PATH to use it with Powershell and entered my first psql command. The response: "Password for user *(my WINDOWS username). NO password works. Not the one for ...
1
vote
0answers
49 views

`sudo service postgresql status` shows postgresql is running, but there is no process for the given PID when running `ps aux`?

It looks like it's running when I check the service status: ubuntu@demos:/etc/postgresql/10/main$ sudo service postgresql status ● postgresql.service - PostgreSQL RDBMS Loaded: loaded (/lib/...
0
votes
0answers
10 views

Heroku postgresql deletes data after a while

I made a simple restful server and I host it on heroku. I use postgresql (hobby plan (the free one)) to save my data (a simple to do list to be specific). However my data get lost after some time of ...
0
votes
0answers
47 views

PostgreSQL data on separate disk in CentOS 8

I have a CentOS 8 server with PostgreSQL and want to store all data of PostgreSQL on a different (physical) disk. Whats the best way to do it? This is a brand new installation, therefore no data-...
0
votes
0answers
14 views

Why exactly is a “dump + restore” necessary when upgrading PostgreSQL between non-minor releases?

I have PostgreSQL 11-something installed. I can't just upgrade to PG 12 now and continue as normal. Instead, I have to dump the existing databases into file(s), perform the upgrade, then delete the ...
0
votes
0answers
44 views

PostgreSQL server prevents hibernation

I've configured my Synology DS918+ Diskstation so that it goes into HDD hibernation when the disks are not being used. I've had it configured like that for a year and it's worked pretty well so far. ...
1
vote
0answers
88 views

Can't connect to virtualbox postgreSQL from host using navicat

I am currently trying to set up some databases using PostgreSQL 9.4 on a guest VM using VirtualBox running centos 6.5. I'm trying to connect to the database using navicat from the host but all it's ...
0
votes
0answers
34 views

Where has PostgreSQL its datadir configured?

When I try to start my PostgreSQL install, it complains about an incorrect database version in its data dir (I have 11 installed, but the data dir it looks at is 9.4). ● postgresql.service - ...
0
votes
1answer
188 views

How to install ecpg (postgres embedded compiler) on centos8?

I'm trying to get pgsanity to work on CentOS8. I used to use sudo yum install postgresql-devel but it seems that does not provide the ecpg package anymore. What would the correct way be to get ...
0
votes
0answers
48 views

Cannot connect to guest machine postgresql database

I am using vagrant 2.2.6, virtual box 6.0.14 In my guest machine, i am running box version ubuntu/bionic64, and I installed postgresql for bionic. The service in the guest machine is started and ...
0
votes
0answers
85 views

Disable Linux Page Cache for Reads

Is there a way to turn-off page caching for reads in Linux? More specifically, I would like my processes to read directly from the disk. The setting of my problem: I am trying out new query ...
1
vote
0answers
82 views

UTF8 error message in postgresql

I installed postgresql on windows using the guide on this page: http://www.postgresqltutorial.com/ And I also loaded their dvdrental database from this site: http://www.postgresqltutorial.com/...
1
vote
0answers
147 views

How to improve postgresql query execution time

Problem Statement: we have a Enterprise product with Postgresql db as a backend. one of the tables has 5 columns and respective data type is (bigint time , bigint store_time , varchar category, ...
1
vote
1answer
469 views

Postgres SQL undefined symbol : pqsignal

Hi I am trying to install Postgres on my CentOS 7 server. Installation was successful, But when I type psql I get this error psql: symbol lookup error: psql: undefined symbol: pqsignal I am ...
1
vote
1answer
40 views

Why can't i open text editor when working with postgresql on terminal?

I know command "\e" when working with POSTGRESQL will open text editor so I can insert text and execute queries from there. But when I use "\e", the terminal just simply inserts a new line with ...
0
votes
1answer
67 views

Postgresql pg_dump not working with anacron (cron.daily) on Ubuntu 18.04

I have two files called lb and z-backup. z-backup is a sh script placed in cron.daily which calls the lb (sh) script as an anacron job. These are the files and their locations: ls -l ~/bin/lb -...
0
votes
2answers
60 views

Pg_dump and rsync backup script not working in anacron

I have two sh scripts called Z-backup and lb. Z-backup is a script that I have placed in cron.daily so it is run as an anacron job and calls the lb script. The content of the Z-backup script is: #!/...
1
vote
2answers
163 views

SSL certificate error when connecting to PostgreSQL database with Oracle SQL Developer on Fedora 30

I have a postgresql 9.3 database running in a RHEL 6.2 kvm virtual machine. It's part of the application I support for work, and I cannot make any configuration changes to the contents of the VM ...
0
votes
0answers
45 views

postgresql configuration for gitlab

Does anybody know how to configure an external postgresql db instance for gitlab by stopping existing postgresql db. I have configured and getting below error : There was an error running gitlab-ctl ...
1
vote
0answers
37 views

Why do I get error “/var/lib/pgsql/.role.sh: not found” from postgres in docker?

I have PostgreSQL running in Docker. The host system is Ubuntu 18.04.3. Every time I execute some SQL in PostgreSQL I get /var/lib/pgsql/.role.sh: not found Does anyone know why this is or at least ...
0
votes
1answer
197 views

Error installing Postgres on Mac

I'm trying to install Postgres on my Mac using brew but for some reason it's unable to finish the installation and is displaying the error below. "initdb: file "/usr/local/share/postgresql/postgres....
0
votes
1answer
96 views

pg_dump with -w flag does not read from .pgpass file

I am trying to backup my PostgreSQL database called crewdb on Ubuntu 18.04 LTS from a script with the following command in it: pg_dump -h localhost -p 5432 -U postgres -w -C -F p -b -v -f ~/Dropbox\/...
-2
votes
1answer
32 views

All my tables inserted with a .sql file are gone when I close a session in Postgres

So I'm new to psql so sorry for the noob question. Not sure if relevant but I'm using Ubuntu 19.04 installed on a USB stick with persistent memory (used mkdisk). Everything works fine but I have ...
1
vote
0answers
35 views

Can't add new System ODBC to PostgreSQL db

I am working on HP 64-bit machine on Windows 10. Already have a working System ODBC connection to a "Production" PosgreSQL db, it is postgreSQL ANSI(x64), using it for a while now. The problem is, ...
0
votes
0answers
52 views

Mulesoft calling PostgreSQL function

Has anyone successfully called a PostgreSQL function or stored procedure from Mulesoft 4? I am using .. and it does not seem to be working. I know it can be done via ... but is there an elegant ...
0
votes
0answers
26 views

Snapshot a database by creating a copy

As part of backup script I want to create a consistent backup of my application and database by stopping the service and then creating snapshots of database and file system. With PostgreSQL I can ...
0
votes
0answers
28 views

Web UI for SQL like ArangoDB

I recently came across ArangoDB and I really like the GUI. It is simple, intuitive and powerful. Now, I don't really need or have time to learn nosql but could use something like it. Is anyone aware ...
0
votes
0answers
16 views

PostrgreSQL not portforwarding

Im having an ubuntu server 16.04 that i have installed postgresql server onto with ufw but even after allowing the port 5432 and as well as checking the conf for postgresql. I even tried follow ...
0
votes
1answer
448 views

relation tableName does not exist - PostgreSQL

I have a database named mimic on my postgres DB . I'm trying to execute this command : select hadm_id from admission_ids where hadm_id in (select distinct on (subject_id) hadm_id from (select * from ...
0
votes
1answer
173 views

Failed to install pgaudit in default postgresql version

When I try to install pgaudit in postgresql that Discourse provides by default, I got a failure messages like below: <Error Messages> root@07f8d9674261:/pgaudit# make check USE_PGXS=1 Makefile:...
0
votes
0answers
110 views

Clustered Hashicorp Vault servers with postgres backend

I am having an issue setting up two vault servers (with postgres backends) in high availability mode. I am able to start the server and run the operator init command on both of them. I have set up my ...
0
votes
0answers
22 views

Postgressql repository-how to create db with collation case insensitive?

I am using Enterprise Architect client (sparxsystems). I am using DM I am force to use Postgress as DBMS repository. I am using MySQL for many years. I would like to use search with case insensitive ...
0
votes
0answers
120 views

How to restore a Bitbucket Server DIY backup restore work with a postgres database?

I am trying to make the Bitbucket Server DIY backup work. My work is based of the example DIY backup scripts given here. I am using the most recent version of bitbucket server on a Debian GNU/Linux 9 ...
0
votes
1answer
55 views

IPTables KVM NAT port forward goes to wrong VM

Good day, I have 2 VMs running with libvirt. Machine 1 : PostgreSQL on port 5432 Machine 2 : Attempting to use psql to connect to a PostgreSQL server on the internet. I forwarded port 5432 so that ...
1
vote
0answers
279 views

Postgresql 11 logical replication - stuck in `catchup` state

I'm running two postgresql 11 servers - master and slave (setup with logical replication). The problem I'm facing is that today after weeks of uninterrupted work slave got out of sync with this error ...
0
votes
1answer
192 views

Postgresql service not starting in services. windows2012

PostgreSQL service not starting in services.msc. It is showing below message while starting PostgreSQL service in Window server 2008 R2. The PostgreSQL-x64-11-PostgreSQL server11 service on local ...
0
votes
0answers
19 views

Want to download installation file of PostgreSQL 9.6 version which is capable to install on no internet access machine

Need to setup a postgresql database on internet disabled ubuntu server. For that, I need to download installation file and transfer this file to ubuntu server to install the database. I could see ...
0
votes
0answers
45 views

Upgrading PostgreSQL 9.5 to 10

I have application that uses PostgreSQL 9.5 with PostGIS 2.2.1 And I need to upgrade my PostgreSQL 9.5 to 10 and postgis from 2.2.1 to 2.4.4 When I try to upgrade it via pg_upgradecluster, I got ...

1
2 3 4 5
11