Ошибка postgresql template1

I need to create database.

First I run: sudo su - postgres, then: createdb test

And I keep getting this error:

createdb: could not connect to database template1: could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"

This is unexpected, I have never encountered any problems with psql, but this time I don’t get what is wrong. And there is no external server, I am connected locally.

I am running on Ubuntu.

The error message suggests:

Is the server running locally

and according to the result of ps -ef | grep "post" posted in the comments, the answer is a definitive No, the server processes are not there, the server is not running.

That fact that you write i have never encountered any problems with psql, suggests that it was installed and working before, in that case look at the most recent log file inside /var/log/postgresql to check for any fatal error message indicating why the server didn’t start.

answered May 7, 2015 at 10:31

In my case, I did the following to get rid of this error:

sudo apt remove --purge postgres*
sudo apt remove --purge pg*   #optional
sudo apt autoremove
sudo apt autoclean
sudo apt clean

Then…

sudo apt update
sudo apt upgrade
sudo apt install -y postgresql-10 postgresql-contrib postgresql-client
sudo apt install -y postgresql-server pgadmin4 ] -> this you may need for metasploit
sudo reboot

And finally, after checking if Postgresql has been installed, if its down, then do this:

List all the Postgres clusters running on your device:
pg_lsclusters

Restart the pg_ctlcluster:
sudo pg_ctlcluster 10 main start

Restart PostgreSQL service:
sudo service postgresql restart

answered Nov 29, 2021 at 16:48

I logged in to source database template1 and now I can’t create database.
When I try to create database, I get this error:

OperationalError: source database "template1" is being accessed by other users
DETAIL:  There are 5 other session(s) using the database.

Every time I login to template1, I use ‘exit’ command to logout, but as you can see it does not logout and number of sessions increases everytime I login. Is there a way to force disconnect every connection to template1 that logged in now?

asked Jan 17, 2013 at 8:18

To solve this, I have to disconnect the database connection from the
pgAdmin III.

I have a script that connects to a database and performs various operations on it, some requiring that no one else is logged in. I modified @Andrius’s answer not to terminate my script’s connection, but rather terminate everyone else’s:

SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid();

From the docs: pg_backend_pid() is the Process ID of the server process attached to the current session.

answered Mar 22, 2018 at 0:44

If you are using the PgAdminn, you can manually set the definitions provided in the image.

answered Jan 5, 2021 at 1:26

You need to kill all the connections to the template database and leave other connections uninterrupted, so use the following query to kill all the connections to templateDb

    SELECT 
    pg_terminate_backend(pid) 
FROM 
    pg_stat_activity 
WHERE 
    -- don't kill my own connection!
    pid <> pg_backend_pid()
    -- don't kill the connections to other databases
    AND datname = 'templateDb'
    ;

Then use the usual query to copy the templateDb

CREATE DATABASE dbname TEMPLATE templateDb ;

answered Aug 17, 2022 at 22:53

If you use pgadmin4 or similar tools, makes sure it is either doing the create database itself or that it’s shut off.

I had generated a create database with pgadmin4 then used its scripting functionality to export the script it used, which I then copied and altered to put it in my own automated scripts.

Problem was that the active webpage pgadmin somehow ended up on database template1.

Stopping and restarting the server itself didn’t fix anything, pgadmin was smart enough to reconnect to the server as soon as it came back up.

answered Oct 30, 2020 at 15:56

answered Feb 17, 2017 at 19:12

answered May 16, 2019 at 14:17

answered Dec 29, 2019 at 22:57

answered Jan 20, 2020 at 13:00

I had a same problem but after googling, I understood I have a connection to (postgis_30_sample) database (the template that I want to copy from). This connection was created by GeoServer when I created some stores in Geo Server application.

So I Stopped the service and the issue was fixed !

answered Feb 25, 2020 at 23:54

answered Aug 9, 2020 at 16:28

I have the same problem with:
ERROR: source database «template1» is being accessed by other users
DETAIL: There is 1 other session using the database.

And i Solved the problem in postgreSQL 13 by clicking in the left column on PostgreSQL 13 where the tables showing some graphs appeared. I was interested in the sever activity table, here I found a line that contained the word template1 and I turned it off with a cross, then restarted the application here and everything works.

error: template1-solved

answered Oct 26, 2020 at 13:09

If you are using Docker, have to set host to ‘0.0.0.0’ than ‘localhost’ in your sequelize config.