Search Postgresql Archives

Re: FATAL: the database system is starting up

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



fluxh wrote
> I have the same problem. I have a log like patrick keshishian. I have not
> a backup.
> 
> I don't know that do.
> 
> Help me please!!!
> 
> Information:
> 
> - Server with RAID1 on SAS HD Hot-plug.
> - Ubuntu Server 12.04 x64.
> - Postgresql 9.1.
> 
> When I do "psql" PostgreSQL shows "psql: FATAL: the database system is
> starting up" and when I write pg_dump or I try connect with pgAdmin3.

You should supply your actual log file and also provide some narrative of
what exactly you were doing prior to this condition occurring.  Some context
as to architecture wouldn't hurt - such as how many and what kinds of
applications are connecting to the database, especially those that maintain
persistent connections.

System commad output like top and ps may also be of value though after you
provide the background a more directed Q&A can follow.

In short it sounds like you need to force PostgreSQL to shutdown and then
start it back up again.  If you are using the apt package you'd do this via
some invocation of pg_ctlcluster for which there is ample documentation of
both it and the underlying pg_ctl command.

David J.




--
View this message in context: http://postgresql.1045698.n5.nabble.com/FATAL-the-database-system-is-starting-up-tp4941646p5795847.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux