Postgresql starting failed

Question

I was connected with remote postgres-9.3 by pgAdmin III. After close pgAdmin i try to connect on another day with the same db.

 /etc/init.d/postgresql-9.3 status
 dead but pid file exists

service postgresql-9.3 start     FAIL

In pgstartup.log file i have:

This account is currently not available

pg_hba.conf:

# "local" is for Unix domain socket connections only
local   all             all                                     peer
host    all             all             127.0.0.1/32            trust
host    all             all             89.70.224.82/32         md5

Operating system on server is CentOS. I don't know unfortunately how postgres was installed on the server because someone else done that. What i can do with this?

The error message suggests that the postgres user doesn't have a valid shell. Which leads to the question of what is the operating system and how you installed postgres on it. — Daniel Vérité
I have edited post by add information about Operating system — Michal M.
See the contents of /etc/init.d/postgresql-9.3. Find out as which user postgresql is being started (probably postgres). Check if that user exists in /etc/passwd. — Jayadevan
I have found this line in /etc/passwd: postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/sbin/nologin — Michal M.

Nanda Thota Nanda Thota · Accepted Answer · 2014-12-26T05:45:16

The solution is reset your PostgreSQL logs

[root@user /]#/usr/pgsql-9.3/bin/pg_resetxlog -f /usr/pgsql-9.3/data/

after executing above command display "Transaction log reset"

and then restart PostgreSQL server

[root@user /]# /etc/init.d/postgresql-9.3 restart

Stopping postgresql-9.3 service:                           [FAILED]

Starting postgresql-9.3 service:                           [  OK  ]

[root@qa /]# /etc/init.d/postgresql-9.3 status
 (pid  3003) is running...

after checking your pgadmin

Postgresql starting failed

2 Answers