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.
560
questions
2
votes
0
answers
2k
views
How create new server connection in pgAdmin 4 by pasting PostgreSQL connection string (URI)
See https://stackoverflow.com/a/20722229/470749
It's very common for server connections to be specified in just one URI, which is more convenient than needing to type out a bunch of values into ...
- 1,976
3
votes
1
answer
7k
views
Why is my PostgreSQL startup service not working properly until I restart it manually after reboot?
I have PostgreSQL running on my Linux server.
PostgreSQL is enabled and is active after reboot.
In the config file from PostgreSQL I enabled remote access. But every time after I reboot my device, the ...
- 41
0
votes
1
answer
199
views
Is postgresql installed by default on MacOS?
The Uninstall app isn't working and it's been so long that I don't remember if MacOS had Postgres installed for anything before I started. If I delete /Library/PostgreSQL will it brick my system?
I ...
- 178
1
vote
2
answers
3k
views
Postgresql unix domain socket with password authentication
It looks like postgresql supports either of the below
Use tcp (i.e. localhost:5432) with password authentication
Use Unix domain scoket (i.e /var/run/postgresql/.s.PGSQL.5432 ) with peer/trust ...
- 127
0
votes
2
answers
1k
views
/usr/local/opt/postgresql/*.plist no match
i'm trying to install postgres on my macOS (Monterey 12.0.1).
i've ran brew install postgres and the next step is to run ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgents, but when i do,...
0
votes
1
answer
73
views
Cannot disinstall PostgreSql by Script Bash - Linux - Must not open dialog confirmation
My goal is to uninstall PostgreSql (installed on a Linux host- Ubuntu 18.04 LTS) using a bash script file.
I use the following command:
apt remove --purge -y postgresql-12 && apt autoremove -y
...
- 111
5
votes
1
answer
7k
views
Changing default user for PostgreSQL on Windows 10?
I just installed PostgreSQL 13 on Windows 10. In the command prompt I did:
C:\Users\Max>cd ../postgres
I then tried to do the createdb command and got this error message:
createdb: error: could ...
- 101
0
votes
1
answer
315
views
nslookup on azure postgres server - output explanation
I created a new postgres database in azure. Lets assume, this database has the server name URL mytestdatabase.postgres.database.azure.com
While doing a nslookup on this URL, i'll get the following ...
0
votes
0
answers
147
views
Port on remote server appears open from one server but no the other
So this one has been a bit odd. I have a server within my work VPN that has postgres setup on it. I can access the server in question from my local WSL instance (when connected to the vpn obv) and ...
- 101
0
votes
0
answers
401
views
Recover old PostgreSQL database after reinstalling Windows
My Windows hard drive died and I transferred the secondary hard drive (on which my PostgreSQL 9.4 database was installed) to my new PC.
Since all programs needed to be reinstalled, I then downloaded ...
- 577
2
votes
0
answers
784
views
Installing postgres on windows with locale
Disclaimer: as this should be a standard operation, i feel something on my side must have gone terribly wrong.
I am trying to use postgresql on windows 71. The installer from edb works fine, apart ...
- 121
0
votes
0
answers
3k
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 ...
1
vote
1
answer
2k
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 ...
darth_vader
0
votes
2
answers
2k
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
1
answer
454
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
