some error messages in postgeslog - Mailing list pgsql-general

From surabhi.ahuja
Subject some error messages in postgeslog
Date
Msg-id 8626C1B7EB748940BCDD7596134632BE39867B@jal.iiitb.ac.in
Whole thread Raw
Responses Re: some error messages in postgeslog
List pgsql-general
I use PostgreSQL 8.0.0
 
it seems that the disk was close to full,
 
i executed a program (in C++) which opens a connection to Postgres using PQConnectdb.
 
and then it reads from a particluar table, and simply displays the values on the console.
 
after doing that it will close the connection using PQfinish
 
and thats when these error messages come....
 
<2006-04-05 17:10:47 CDT%idle>LOG:  disconnection: session time: 0:00:00.00 user=sdc database=dbexpress host=[local] port=
<2006-04-05 17:10:47 CDT%idle>LOG:  disconnection: session time: 7:41:26.70 user=sdc database=dbexpress host=[local] port=
<2006-04-05 17:10:47 CDT%>ERROR:  could not access status of transaction 0
<2006-04-05 17:10:47 CDT%>DETAIL:  could not write to file "/export/home1/sdc_image_pool/dbx/pg_clog/0001" at offset 40960:
No space left on device
<2006-04-05 17:10:48 CDT%>LOG:  could not close temporary statistics file "/export/home1/sdc_image_pool/dbx/global/pgstat.tm
p.24783": No space left on device
<2006-04-05 17:10:49 CDT%>ERROR:  could not access status of transaction 0
<2006-04-05 17:10:49 CDT%>DETAIL:  could not write to file "/export/home1/sdc_image_pool/dbx/pg_clog/0001" at offset 40960:
No space left on device
<2006-04-05 17:10:50 CDT%>ERROR:  could not access status of transaction 0
<2006-04-05 17:10:50 CDT%>DETAIL:  could not write to file "/export/home1/sdc_image_pool/dbx/pg_clog/0001" at offset 40960:
No space left on device
 
is it true that for starting a connection to postgres read a table and then closing connection disk space will be needed.
 
Is it because of this reason these error messages are coming?
 
 
 
i have another question i have also noticed this error message in the postgres log, what are its implications and what happened that this error message came
:
2006-04-05 09:22:08 CDT%>LOG:  received fast shutdown request
<2006-04-05 09:22:08 CDT%>LOG:  aborting any active transactions
<2006-04-05 09:22:08 CDT%>LOG:  checkpoints are occurring too frequently (16 seconds apart)
<2006-04-05 09:22:08 CDT%>HINT:  Consider increasing the configuration parameter "checkpoint_segments".
 
 
Thanks,
regards
Surabhi

pgsql-general by date:

Previous
From: Fernan Aguero
Date:
Subject: grant privileges across schemas
Next
From: "Kynn Jones"
Date:
Subject: Re: Bulk inserts within a Perl script?