Questions tagged [postgresql]

PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) available for many platforms including Linux, FreeBSD, Solaris, Microsoft Windows and Mac OS X.

Filter by
Sorted by
Tagged with
3
votes
3answers
8k views

How to solve the problem of PostgreSQL service doesn't start?

This is about Metasploit Framework. root@kali:~# service postgresql start [....] Starting PostgreSQL 9.1 database server: main[....] The PostgreSQL server failed to start. Please check the log ...
0
votes
2answers
893 views

Why can't I change directory to the current directory with permission denied?

I am trying to restore a database with the following command: $ sudo -u postgres pg_restore -C -d dvdrental dvdrental.tar [sudo] password for t: However, I am receiving the following error message:...
14
votes
3answers
30k views

Systemd postgresql start script

I'm in the process of installing postgresql onto a second server Previously I installed postgresql and then used the supplied script ./contrib/start-scripts/linux Placed into the correct dir # cp ....
6
votes
4answers
37k views

“psql: could not connect to server: No such file or directory”

Actually, I installed PostgreSQL 9.4 (with postGIS extension), and when installed, everything used to work fine. As said on many tuts, I've set the /data folder, checked configuration files, and so ...
2
votes
2answers
474 views

Installing Postgres App on Linux Mint

I've been put on a web app project that is built using Ruby on Rails and uses PostgreSQL for the database. All the other developers on the team have Macs so they just installed Postgres app to set up ...
1
vote
1answer
2k views

Adding Postgres bins to PATH: should I `export`? [duplicate]

I'm on a Mac, but this seems like a UNIX/Linux question. I just installed Postgres.app, and the documentation says to add the /bin directory that ships with Postgres.app to your PATH by adding the ...
1
vote
1answer
158 views

PostgreSQL Accessible to Web Application

I have a server with PostgreSQL installed and there are scripts that are constantly modifying data in the database. PostgreSQL is running on it's default port 5432. I would like to be able to connect ...
1
vote
1answer
46 views

Why is mysql server accepting nonlocal request, while postgresql server is not?

By default configurations, why is mysql server accepting nonlocal request, while postgresql server is not? $ nmap -p0-65535 192.168.1.97 Starting Nmap 7.60 ( https://nmap.org ) at 2019-03-20 14:34 ...
0
votes
1answer
527 views

PostgreSql port open on NAS Synology DiskStation (DS216j)

How is possible to check if the port 5432 of my NAS synology DiskStation (DS216j) (IP address 192.168.0.16 ) is open? I have (in the control panel of the NAS), enabled the firewall and created a rule ...