Error:
PG::ObjectInUse: ERROR: source database "template1" is being accessed by other users
DETAIL: There are 1 other session(s) using the database.
Solution:
PG::ObjectInUse: ERROR: source database "template1" is being accessed by other users
DETAIL: There are 1 other session(s) using the database.
Solution:
Database template1 exists only to use structure to create another empty database. You should never login to template1, otherwise you will have problems for login or create database.
Most likely easiest solution for you is to restart PostgreSQL server process, and logon again.
For restart PostgreSQL server use this command:
sudo service postgresql restart
If restarting is not working then you can use another template database: template0.
For this log in with username and password in postgresql with this command:
sudo -u postgres psql template1
Enter password if you used password for user "postgres"
Then change template with database_name
By default, database create for template1 with this statement and this statement:
CREATE DATABASE database_name;is equivalent to:
CREATE DATABASE database_name TEMPLATE template1;If template1 is not available or corrupted, you can use template0 as last resort:
CREATE DATABASE database_name TEMPLATE template0;You can read more about template databases here.
You have shared a lot of information in this article. I would like to express my gratitude to everyone who contributed to this useful article. Keep posting. Business IT Support in London
ReplyDeletemmorpg oyunlar
ReplyDeleteİNSTAGRAM TAKİPCİ SATIN AL
Tiktok Jeton Hilesi
TİKTOK JETON HİLESİ
Antalya saç ekimi
instagram takipçi satın al
Instagram Takipçi Satın Al
metin2 pvp serverlar
İNSTAGRAM TAKİPCİ
perde modelleri
ReplyDeletesms onay
mobil ödeme bozdurma
nft nasıl alınır
ankara evden eve nakliyat
trafik sigortası
dedektör
KURMA WEB SİTESİ
aşk kitapları
SMM PANEL
ReplyDeleteSMM PANEL
iş ilanları
instagram takipçi satın al
hirdavatci burada
beyazesyateknikservisi.com.tr
Servis
tiktok jeton hilesi