Hello,
I am running Postgresql 8.1.5 on a Win Server 2003 machine, and am
1) running a pg_dump every day at 2am (during lowest usage time - practically
idle time)here is a script i use (this is in turn run from Scheduled Tasks in
control panel):----------...@echo OFF
ECHO.
ECHO This is a batch file
@For /F "tokens=3 delims=/ " %%A in ('Date /t') do set dd=%%A
@For /F "tokens=2 delims=/ " %%B in ('Date /t') do set mm=%%B
@For /F "tokens=4 delims=/ " %%C in ('Date /t') do set yyyy=%%C
@For /F "tokens=1 delims=:" %%A in ('Time /t') do set hh=%%A
@For /F "tokens=2 delims=: " %%B in ('Time /t') do set min=%%B
@For /F "tokens=3 delims=: " %%C in ('Time /t') do set ampm=%%C
set tmp=%yyyy%%mm%%dd%%hh%%min%%ampm%
echo Current time is: %yyyy%-%mm%-%dd% %hh%:%min% %ampm%
echo File name will be: testdump2_%tmp%.txt
cd C:\Program Files\PostgreSQL\8.1\bin
pg_dump -U postgres --inserts athenav3DB>c:\BKP\PENELOPE-v3-dump2_%tmp%.txt
echo The pg_dump is complete
ECHO
CLOSE
EXIT-----------------when i check out the pg_locks view the next morning, i end
up with 600+ locks. These locks all have the same pid, and I have verified that
it is the exact time when the pg_dump was run by querying pg_stat_activity for
that procpid. These in turn cause the # of connections in pg_stat_activity to
grow, and eventually crashes a web server that is connected to it. From the
script, can you see if i'm doing something wrong?
2) I also have auto - vacuuming on. Sometimes (can't seem to trace the exact
cause of this one) the command "vacuum" ends up in pg_stat_activity in the
current_query column, and does not get released unless i bring postgres itself
down. Instead of ending, the vacuum ties up a process. These accumulate and
also cause system failures. Is there a way to run/configure auto-vacuum to exit
instead of hanging and tying up the said process?
Thank you in advance!
_________________________________________________________________
New! Open Messenger faster on the MSN homepage
http://go.microsoft.com/?linkid=9677405
