Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I cannot login into postgresql server using psql command (to create / update / delete table) because some sort of error like below.

the command :

[root@Server-Database pg_log]# su postgres
bash-4.1$ psql
psql: FATAL:  the database system is starting up
bash-4.1$ 

I am using postgresql 9.2 in CentOS 6.3

here is log file

[root@Server-Database pg_log]# tail -f postgresql-Mon.log
FATAL:  the database system is starting up
FATAL:  the database system is starting up
FATAL:  the database system is starting up
FATAL:  the database system is starting up
....

startup log :

[root@Server-Database data]# tail -f /var/lib/pgsql/9.2/pgstartup.log
could not write to log file: No space left on device
could not write to log file: No space left on device
could not write FATAL:  lock file "postmaster.pid" already exists
HINT:  Is another postmaster (PID 5872) running in data directory "/var/lib/pgsql/9.2/data"?

for information, this server have a crash one day ago, because empty hdd space, this is the space after crash solving :

Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_serverdatabas-lv_root
                      439G  408G  8.5G  98% /

server successfully restarted (look command below), but things still not resolved, I cannot enter psql command

[root@Server-Database data]# /etc/init.d/postgresql-9.2 restart
Stopping postgresql-9.2 service:                           [  OK  ]
Starting postgresql-9.2 service:                           [  OK  ]
share|improve this question

closed as off-topic by Jack Douglas Dec 10 at 10:21

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Jack Douglas
If this question can be reworded to fit the rules in the help center, please edit the question.

1  
Try to make a little extra space because if you only have 2% left, you're in for trouble. Have a look here on how to get rid of this pid: superuser.com/questions/553045/… –  KookieMonster Dec 2 '13 at 6:56

1 Answer 1

There is no more space on the device:

could not write to log file: No space left on device

Check it with df and make some space

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.