Login to SQL Management Studio, select Master database and click on New Query and paste the below code : CREATE TABLE #sp_who2 (SPID INT, Status VARCHAR(1000) NULL, Login SYSNAME NULL, HostName SYSNAME NULL, BlkBy SYSNAME NULL, DBName SYSNAME NULL, Command VARCHAR(1000) NULL, CPUTime INT NULL, DiskIO INT […]
Author: Sarath
A Techie from Kochi, India with 8+ years of experience in Linux and Windows server administration. I learn new things almost everyday and I enjoy the fun of learning and sharing my knowledge.
psql: FATAL: no pg_hba.conf entry for host “[local]”, user “root”, database “root”, SSL off
If you see the above error, open pg_hba.conf file (/var/lib/pgsql/data/pg_hba.conf) and uncomment or add the line :local all all trust Then restart postgresql# /etc/init.d/postgresql restart
phpPgAdmin Login Failed
If you are unable to login to phpPgAdmin using your Cpanel username and password and getting a “Login failed” message do the following :SSH to your server as root and open /var/lib/pgsql/data/pg_hba.confSearch for# “local” is for Unix domain socket connections onlylocal all all ident sameuserChange it to # “local” is for Unix domain socket connections […]