Обсуждение: FATAL: the database system is starting up
Hi,
Many times after I start the db (/etc/init.d/postgresql), the second I access it I get
"FATAL: the database system is starting up"
Is there a natural way (any cli command or other) to check with the DB if it's still starting up or it is ready?
Thanks
VJ
Many times after I start the db (/etc/init.d/postgresql), the second I access it I get
"FATAL: the database system is starting up"
Is there a natural way (any cli command or other) to check with the DB if it's still starting up or it is ready?
Thanks
VJ
On Sun, Nov 1, 2009 at 4:31 PM, Victor Jason <vctrjsn@gmail.com> wrote:
you can check the status of the database using the pg_ctl utility.
cd /usr/local/pgsql/bin
pg_ctl -D <data directory path> status
Thanks & Regards
Raghu
Hi,
Many times after I start the db (/etc/init.d/postgresql), the second I access it I get
"FATAL: the database system is starting up"
Is there a natural way (any cli command or other) to check with the DB if it's still starting up or it is ready?
you can check the status of the database using the pg_ctl utility.
cd /usr/local/pgsql/bin
pg_ctl -D <data directory path> status
Thanks & Regards
Raghu
On Sun, 8 Nov 2009, raghu ram wrote: > On Sun, Nov 1, 2009 at 4:31 PM, Victor Jason <vctrjsn@gmail.com> wrote: >> Hi, >> Many times after I start the db (/etc/init.d/postgresql), the second I >> access it I get >> >> *"FATAL: the database system is starting up"* >> Is there a natural way (any cli command or other) to check with the DB if >> it's still starting up or it is ready? >> > you can check the status of the database using the pg_ctl utility. > > cd /usr/local/pgsql/bin > > pg_ctl -D <data directory path> status I have the same problem as Victor In my hands pg_ctl status just gives me "pg_ctl: server is running (PID: 26644)" The only way I know is to attempt to login to the database which generates that scary error :-} I'd also like to know if there was a better/nicer/proper way to determine if the database was starting up -- Michael ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Michael John Lush PhD Tel:44-1223 492626 Bioinformatician HUGO Gene Nomenclature Committee Email: hgnc@genenames.org European Bioinformatics Institute Hinxton, Cambridge URL: http://www.genenames.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~