Create an account

Very important

  • To access the important data of the forums, you must be active in each forum and especially in the leaks and database leaks section, send data and after sending the data and activity, data and important content will be opened and visible for you.
  • You will only see chat messages from people who are at or below your level.
  • More than 500,000 database leaks and millions of account leaks are waiting for you, so access and view with more activity.
  • Many important data are inactive and inaccessible for you, so open them with activity. (This will be done automatically)


Thread Rating:
  • 523 Vote(s) - 3.51 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to restart PostgreSQL in Ubuntu 18.04

#1
How to restart PostgreSQL via ssh console?

When i search this thing on SO I only find:

[To see links please register here]

Reply

#2
sudo service postgresql restart
Reply

#3
My postgresql service is named postgresql-9.5; in case you get `"postgresql: unrecognized service"` you can find its name with

sudo service --status-all | grep postgresql

and then proceed as per the accepted answer.
Reply

#4
systemctl restart postgresql@<postgres_version>-<cluster_name>.service

By default cluster_name = 'main', run this command to list all the clusters you have :

```
ls /var/lib/postgresql/
```

if you want to know whether the postgresql is running try this command :

systemctl status postgresql@<postgres_version>-<cluster_version>.service

Reply

#5
**The problem is with your remote configuration**

sudo nano /etc/postgresql/13/main/postgresql.conf


Uncomment line 59 and change the Listen address to accept connections within your networks.
*

#Listen on all interfaces

> listen_addresses = '*'

#Listen on specified private IP address

> listen_addresses = '192.168.10.11`


Reply



Forum Jump:


Users browsing this thread:
1 Guest(s)

©0Day  2016 - 2023 | All Rights Reserved.  Made with    for the community. Connected through