VDS Sphera Knowledge Base

Main / Browse Categories / PostgreSQL / How do I restart PostgreSQL if it crashes?

Print article Print Article    Email article Email Article

How do I restart PostgreSQL if it crashes?
View the file:
/tmp/postgre.log
This log usually tells you exactly what to do. For example,
If you're sure there are no old backends still running,
remove the shared memory block with ipcrm(1), or just
delete "/usr/local/pgsql/data/postmaster.pid".
You can then run the command:
/etc/rc.d/init.d/pg_ctl start

User Comments
How do I restart PostgreSQL if it crashes?  
There are no user comments for this topic.
 

Attachments
No attachments.

Related Articles
 Does PostgreSQL have a graphical user interface?
 How can I connect to PostgreSQL using PHP?
 What version of PostgreSQL are you running?
 Where can I find answers to frequently asked questions on PostgreSQL?
 Where can I find Technical Documentation on PostgreSQL?

Why Choose Our Hosting?

  • Unmatched Customer Support!
  • Virtual Private Server technology provides a rich, dedicated-like environment for every account.
  • We are known for our superb quality, performance and flexible hosting environment. We manage the server, software, and network you do the rest.
Continue reading »

Featured Hosting Plan


Learn more about our VPS Extreme

What is Included?

  • PHP 5/MySQL 5
  • Parallels® Plesk Panel 10
  • Unique IP Address
  • Daily VPS Backups (Off Server)
  • SAS Hardware Raid diskspace
  • CentOS 5 x86_64 bit
  • Multi-homed Tier 1 Bandwidth
  • Full Upgrade capabilities
Continue reading »