Re: [ADMIN] Pgsql crashes frequently

2003-10-11 Thread Anis W. Nugroho
If you're using Linus, change those settings (semaphores) with a root account. Edit /etc/sysctl.conf to add the setting below (adjust the value properly) kernel.shmmni = kernel.shmmax = Execute sysctl -p Good luck, Anis WN 15 Mbytes Free We

Re: [ADMIN] pg_dumps

2003-10-11 Thread Anis W. Nugroho
Hi Scott, You didn't need to use host and port argument since you are on the local system. So just type pg_dump admin > holt_admin_db.dump If insist to use TCP/IP connection, you must tweak the *.conf files in the directory /var/lib/pgsql/data. Use root account to do that. Good luck, Anis W

Re: [ADMIN] pg_dumps

2003-10-11 Thread Anis W. Nugroho
Hi Scott, You don't need to host and port argument because you are on the local system. Just type pg_dump admin > holt_admin_db.dump If you need to use TCP/IP connection, you must ever tweak .conf files in the directory /var/lib/pgsql/data to enable port 5432 for that purpose. To do that yo