Database Server in Recovery mode!
От | Rajesh Kumar Mallah |
---|---|
Тема | Database Server in Recovery mode! |
Дата | |
Msg-id | 3CC7A7AC.F995E2BB@trade-india.com обсуждение исходный текст |
Список | pgsql-sql |
Hi Friends <p>please help. <p>my database server has gone in recovery mode for some <br />reasons i donot know. <p>whatis the possible steps one shud take to bring the database <br />up to an usable state in minimum time. <br /><tt></tt> <tt></tt><p><tt>Belowis the message when i try to connect.</tt><tt></tt><p><tt>the the out put of ps in the databaseserver.</tt><br /><tt></tt> <tt></tt><p><tt>regds</tt><br /><tt>mallah.</tt><br /><tt></tt> <br /><tt></tt> <tt></tt><p><tt>[rmallah@system11rmallah]$ psql -h 130.94.22.209 -Utradein tradein_clients</tt><br /><tt>psql:The Data Base System is in recovery mode</tt><br /><tt>[rmallah@system11 rmallah]$</tt><br /><tt></tt> <br /><tt></tt> <br /><tt></tt> <tt></tt><p><tt>[root@linux10320 data]# ps auxwww | grep post</tt><br /><tt>postgres 1839 0.0 0.0 138992 856 ? S Apr12 2:43 /usr/bin/postmaster -D /var/lib/pgsql/data</tt><br /><tt>postgres 3901 6.0 1.4 141068 15248 ? D 12:05 1:29 postgres: tradein tradein_clients 130.94.20.27 COPY</tt><br /><tt>root 5862 0.0 0.0 1360 512 pts/3 S 12:29 0:00 grep post</tt><br /><tt>[root@linux10320 data]#</tt><br/>
В списке pgsql-sql по дате отправления: