I started using CLUSTER a few weeks ago and it worked
(no errors) and the performance of the database
improved. However, When I ran CLUSTER again, I got the
following error:
ERROR: cannot create pg_temp_2558977013: File exists
Here is more information that may or may not be
relevant:
1. I am ru
Yes , my command is
pg_dump -Ft -b test > test.tar
And the result is test.tar which is 5.5 Gb. .
Sorry for my miss typing. What's wrong with my database?
Thanks
Amrit
Thailand
--
http://www.chaiyo.com äªâÂàÁÅì
Hi Folks!
What are the tasks of the postmaster process in 8.x? Is it only
responsible to make the connections?
And what about concurrent access and transaction management?
Thanks.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
"ÍÁÄ·¸Ôì ÍѧÈØÊÔ§Ëì" <[EMAIL PROTECTED]> writes:
> The database "test" after restoration has the same data but no blob found .
> What's wrong with my command?
Did you use -b in the original pg_dump command?
regards, tom lane
---(end of broadcast)-
I have postgresql data [7.4.3] which has the size of more than 5 Gb. and also
contains blob for reporting. I use the command
pg_restore -d test test.tar
test.tar = 5.5 Gb.
after I try to restore it in another server which has the same environment and
use the command
pg_restore -d test test.ta
