pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgresql error
3+ messages / 2 participants
[nested] [flat]
* postgresql error
@ 2001-10-29 15:34 sharmad@goatelecom.com
0 siblings, 1 reply; 3+ messages in thread
From: sharmad@goatelecom.com @ 2001-10-29 15:34 UTC (permalink / raw)
To: pgsql-sql
Is there anyway to increase the query time in postgresql
because if the query is long and so is the database then the pgRead
error occurs resulting in the break of connection with the database
and recently also giving me problems in taking backups.
If i m not wrong the command to take backup is
pg_dump [database_name] > [file_name]
Waiting for the reply,
TIA
-Sharmad
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgresql error
@ 2001-10-30 20:34 Tom Lane <tgl@sss.pgh.pa.us>
parent: sharmad@goatelecom.com
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2001-10-30 20:34 UTC (permalink / raw)
To: sharmad@goatelecom.com; +Cc: pgsql-sql
sharmad@goatelecom.com writes:
> Is there anyway to increase the query time in postgresql
> because if the query is long and so is the database then the pgRead
> error occurs resulting in the break of connection with the database
> and recently also giving me problems in taking backups.
There is no query timeout in Postgres. How about telling us exactly
what you're doing and what symptoms you see, instead of jumping to a
conclusion about the cause?
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgresql error
@ 2001-10-31 05:42 sharmad@goatelecom.com
0 siblings, 0 replies; 3+ messages in thread
From: sharmad@goatelecom.com @ 2001-10-31 05:42 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
Sir,
I m getting an error that say pg_ReadData and also after which then database
connection is lost/disconnected . Can anybody tell me more about this error
? My problem is that i have a databasee with huge no. of records but if i go
to take query/backup of the database the pg_Readdata error occurs and backup
is stopped always at the same point. I tried to shift the /data/base dir to
other distribution to restore my data but same error occured.(I have postgres
7.0.2 & suse distribution)
I m in such a position that if i make a fresh install of postgres in the mc
then my database will go resulting in hammering me.
pls tell me a way to go about it
I have posted the error with the earlier mail
TIA
Sharmad
>sharmad@goatelecom.com writes:
>> Is there anyway to increase the query time in postgresql
>> because if the query is long and so is the database then the pgRead
>> error occurs resulting in the break of connection with the database
>> and recently also giving me problems in taking backups.
>
>There is no query timeout in Postgres. How about telling us exactly
>what you're doing and what symptoms you see, instead of jumping to a
>conclusion about the cause?
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-10-31 05:42 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-10-29 15:34 postgresql error sharmad@goatelecom.com
2001-10-30 20:34 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-10-31 05:42 Re: postgresql error sharmad@goatelecom.com
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox