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
0
votes
0answers
12 views

I can't start PostgreSQL Server 13 from Services.msc

I'm trying to set up a PostgreSQL server on my PC, but I keep getting this error message when I try to start it from services.msc: The postgresql-x64-13 - PostgreSQL Server 13 service on Local ...
0
votes
1answer
10 views

How to install pgBench on Mac Os Big Sur?

How can I install pgBench on mac os Big Sur . I have postgres 12.5 already installed and stack builder does not have the option to install pgbench . And once installed how to connect pgbench to a ...
0
votes
1answer
28 views

How can I connect to PostgreSQL database on a server through an SSH Tunnel using R?

I am trying to connect an RStudio Session to a PostgreSQL database which is on a server (Digital Ocean) through a SSH Tunnel. I am new to the SSH Connections, specially using R. Systems Information: ...
0
votes
1answer
7 views

Can not connect to pgAdmin server in windows 10

Sorry for the same repeated question but pgAdmin failed to connect to the pgAdmin application server. it will save much time from others
0
votes
1answer
9 views

psql command not taking password from .pgpass file

psql -U postgres -h 127.0.0.1 postgres I am using the above command to connect to the postgres running on my system. It asks for password Whereas I have setup .pgpass file in the current directory ...
1
vote
0answers
26 views

Bash: read from socket file descriptor returns always the same data instead of blocking

I have a postgres started like this: exec 3< <(su -l postgres -c "/usr/local/pgsql/bin/postmaster -p '$port' -d 3 -D '$backupDir' 2>&1 & echo \$!") This redirects all logs ...
0
votes
1answer
341 views

Importing large volume of dummy data into pgAdmin 4 by csv - Failed (exit code:1)

I am trying to upload a large amount of dummy data into my pgadmin tables. I was able to use a csv for the smaller tables however I have a larger spreadsheet of data that includes descriptions (with ...
0
votes
0answers
20 views

Source of strange message in Terminal on mac: 'not valid in this context' followed by deleted programs

When I go into terminal on mac, I get a strage message, that looks like the following: Last login: Mon Mar 8 19:22:38 on ttys000 /Users/myname/.zshrc:export:2: not valid in this context: point:/usr/...
0
votes
0answers
70 views

How to connect Etherpad with Odoo on Docker without Cross-Origin Resource Sharing (CORS) error?

Setup Installing Docker version 20.10.5, build 55c4c88 on Ubuntu 20.04.2 LTS following How To Install and Use Docker on Ubuntu 20.04 | DigitalOcean Pulling Odoo with PostgreSQL based on How to Setup ...
0
votes
0answers
12 views

What is the correct way to apply patches (minor versions) of PostgreSQL on Windows?

There used to be this "BigSQL" distribution of PostgreSQL on Windows, but it was removed due to them not maintaining it or something. Now there is only the "EnterpriseDB" one left: ...
0
votes
2answers
39 views

cannot start postgres - not able to create lockfile

I have installed postgres from pacman repo on Manjaro but am running into trouble trying to get it to start. I have followed the instructions from the arch wiki and have created my db. initdb -D /var/...
0
votes
1answer
63 views

Solve Error without installing PostgreSQL on Mac? dyld: Library not loaded: libpq.5.dylib

I am using a Mac OS X software called TablePlus which throws an error when trying to perform a backup of a PostgreSQL 13 database that is running inside a Docker container. dyld: Library not loaded: ...
0
votes
1answer
11 views

How do I tell Postgres to convert existing values to new values?

Problem I have a table that has parent_id and child_id, and they are mutually exclusive, so naturally they should be just one value, not two. I need to replace them with external_id. So any child id's ...
0
votes
0answers
12 views

PostgreSQL table coumns look horrible in terminal ! How to fix it?

Table columns not formated well although I have more wide space, column size is narrow and i can't see well
1
vote
1answer
52 views

disable (or trim) logging of bytea requests in postgres

Our application store some big blob (bytea) in a separate database every 30 minutes. It's fine and we want to keep it like, this, but it's causing crazy logging: 2021-01-25 11:11:00 UTC postgres109432 ...
0
votes
0answers
126 views

pentaho-server 9.0 - User/Role List could not be obtained

I have been updating my Pentaho 7.1 installation to Pentaho 9.0 in November 2020. My pentaho 9.0 was working since, with quartz, jackrabbit and hibernate databases running in PostgresSQL. I have had ...
0
votes
0answers
8 views

File deleted automatically on abrupt shutdown of windows

After an abrupt shutdown of Windows, we are seeing the pg_ctl.exe file getting deleted automatically. The file is used to start and stop Postgres as a Windows service. Due to this Postgres service ...
1
vote
0answers
17 views

Issue with Computer Clock (or perhaps LAN)?

I am experiencing a very strange behavior for which I struggle to identify the source, but assume it's the computer clock. Here is the setup and synopsis: I have two computers on my home network ...
0
votes
1answer
137 views

Cache configuration for PostgreSQL/TimescaleDB VM on ZFS with proxmox

I have a proxmox cluster of a single node and I want to start a new VM with a PostgreSQL and TimescaleDB and after a lot of reading about how to tune ZFS volumes for this purpose I still have some ...
0
votes
1answer
32 views

How to learn what is trying to use my DB?

I'm having a working postgre 11.5 in a docker container, they're just fine! In the the logs I see lots of: FATAL: password authentication failed for user "myuser" DETAIL: Password does not ...
0
votes
0answers
27 views

Connecting with SSL to a PostgreSQL database

I have PostgreSQL on my Raspberry Pi that I can access using a domain I own. I recently added SSL protection to this domain, for safety reasons, using Cloudflare. Since then this made all my ...
0
votes
1answer
87 views

Postgres Column with Multiple Values

I recently took over a database as admin and am unfamiliar with the columns structure in one of the tables. I would really like to know how to select one of the values in the column, as of now I can ...
0
votes
1answer
7k views

pgAdmin not working on mac OS Big Sur

I updated my Mac to macOS Big Sur a few days ago and tried to run pgAdmin to work on some projects of mine. However, it seems there is a problem with pgAdmin 4 and Big Sur. I just cannot run it ...
-1
votes
1answer
1k views

100% CPU usage in Linux server and Postgres database

I'm using a Linux server (Ubunto 18.04) that hosts the Postgres database. PostgreSQL makes CPU Usage up-to 100% and sometimes the related web site is down and after server restarting the site turns to ...
0
votes
0answers
18 views

Connecting to PostgreSQL through a SSH tunnel, I get data for a while and stops, but SSH connection is still alive

Im getting data from a PostgreSQL DB through an SSH tunnel: autossh -M 0 -o "ServerAliveInterval 30" -o "ServerAliveCountMax 3" -L 9999:localhost:5432 root@mypostgresip The data ...
0
votes
0answers
69 views

Can't connect to postgres database

Im trying to connect to a DB with Postgres JDBC, both machines are linux the firewall, selinux, iptables are down on both machines I can connect to the DB, (on my personal windows computer) with ...
0
votes
0answers
25 views

PSQL Console Error No entry for terminal type “xterm-256color”;

I've installed postgres 9.4.26 on ubuntu 20.04, The db starts as expected but when I try to access the pqsl console I get the below error psql.bin (9.4.26) Type "help" for help. No entry ...
0
votes
0answers
22 views

Administrator user not having full control over folders created by Postgres installer

We want to understand the behavior of permissions assigned to folders installed by an application (for example take postgres). Note: Both installations are done by "admin" user who is part ...
1
vote
0answers
28 views

How can I allow postgresql connections from specific ip address?

I have a postgres database. I would like to allow connections to this database from a specific machine. I have installed postgresql-12 and have started the postgresql service on both machines. I have ...
0
votes
1answer
56 views

R “RPostgrSQL” package fails to install on Centos 8 (as `lib` is unspecified)

I want to install the R package RPostgresql to connect to my PostgreSQL database called "crex" on Centos 8. When I run > install.packages("RPostgreSQL") in the terminal I get ...
0
votes
0answers
232 views

DBweaver cannot connect to postgres WSL2 ubuntu

Hello I am successfully using postgresql DB in my WSL2 ubuntu and its working fine, but i need to see data in DBWeaver but unfortunately I cannot connect as it shows no connection available, but if I ...
0
votes
0answers
32 views

Mattermost docker install with existing postgres

Mattermost docker documentation is really confusing. There's an existing docker compose file they say to just download and use, but upon inspection it doesn't fit my need, and they are just assuming ...
0
votes
1answer
40 views

Is it possible to create a single EXE of my system?

I have made an advanced and complex library/framework in PHP. Currently, if I wanted to put this on a new computer, I would have to perform (in broad terms) these manual steps: Install PHP CLI. ...
0
votes
0answers
76 views

How can I access a postgreSQL database from an android device?

I am designing a database in pgAdmin4 and postgreSQL. I am new in it, and I would like to know if there is a way to access and modify this same database from my mobile phone. I am trying with RemoDb ...
0
votes
0answers
75 views

pg_restore fails with unresolved library libpq.so.5

I have a binary distribution of PostgreSQL 9.3.9 copied to CentOS 7.8. All commands were failing with missing libpq.so.5, so I exported LD_LIBRARY_PATH=/opt/app/postgresql/default/lib Then I succeed ...
1
vote
1answer
376 views

How can I run postgres with data dir on /tmp?

I'm running automated integration tests using data stored in a postgres database. I need to start every test run with the same database contents. Instead of always clearing the database and importing ...
0
votes
0answers
49 views

How to recover postgres root user name?

Is there any way to recover a list of users from the command line? I can probably remember the password once I figure out the user name. Specifically, I can't execute psql to use \du because psql: ...
0
votes
0answers
41 views

Putty and Ctrl Arrows moves by the Word at Linux prompt, but only by the character in PostgreSQL — definitely a PuTTY setting

Everything had been working for me to use Ctrl-Left and Ctrl-Right to skip a word at a time when connecting to a Linux box via PuTTY and then launching a PostgreSQL session (all within the same PuTTY ...
1
vote
2answers
31 views

How to get ONLY the variable output of a PSQL statement

If have a variable: var=$(psql -U chh1 -d crewdb -c '\t' -c "SELECT MAX(date_linkid) + 1 FROM date_link;") When I run: echo "$var" I get: Tuples only is on. 284 How can I ...
0
votes
0answers
618 views

Cannot connect docker to AWS RDS instance

I have an AWS RDS instance setup with the engine as Postgres. I have stored url of the database in an .env file. Now I am using Docker to run my project and access the RDS database from inside the ...
0
votes
1answer
36 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
1answer
560 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
1answer
150 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
1answer
3k 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
7k views

How to setup Scalelite load balanacer for BigBlueButton

I am trying out the 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 Greenlight to work ...
1
vote
2answers
38 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-...
1
vote
0answers
28 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
300 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
556 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
59 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
2 3 4 5
11