-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 02-Oct-2002/05:51 -0700, Nagib Abi Fadel <[EMAIL PROTECTED]> wrote: > >I'm using redhat 7.3 (kernel 2.4.18-3 on an i686). I launch a pg_dump >command on my postgres database version 7.2.1 every 1 hour. The system >has been freezing every 3 hours approximatly, at the same time of the >launching of pg_dump. > >When i stopped launching the pg_dump every 1 hour the system stopped >freezing .
I don't know why your system is freezing, but I have a suggestion. Try logging the queries and run a daily dump instead of an hourly dump. I recommend having your application log all queries. If that is not possible, then you can set the PostgreSQL debug level to 2 and specify a log file by editing the init script (/etc/rc.d/init.d/postgresql) so that the startup command looks like this: su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -o '-i -d2' \ -p /usr/bin/postmaster start >> /var/log/pgsql 2>&1" < /dev/null Tony - -- Anthony E. Greene <mailto:[EMAIL PROTECTED]> OpenPGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D AOL/Yahoo Chat: TonyG05 HomePage: <http://www.pobox.com/~agreene/> Linux: the choice of a GNU Generation. <http://www.linux.org/> -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: Anthony E. Greene 0x6C94239D <[EMAIL PROTECTED]> iD8DBQE9mwM9pCpg3WyUI50RAo9jAKCDJ+SBpXAgIFc/v+D2mqTvhr396gCgh/v3 gMhLsu6vSAtx8dyGVdu4Uw0= =ly3v -----END PGP SIGNATURE----- -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe https://listman.redhat.com/mailman/listinfo/redhat-list