X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1C13455119 for ; Sat, 19 Mar 2005 01:19:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 21334-10 for ; Sat, 19 Mar 2005 01:19:16 +0000 (GMT) Received: from polaris.pinpointresearch.com (66-7-238-130.cust.telepacific.net [66.7.238.130]) by svr1.postgresql.org (Postfix) with ESMTP id A115E52A7D for ; Sat, 19 Mar 2005 01:19:15 +0000 (GMT) Received: from betelgeuse.pinpointresearch.com (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 331811038D; Fri, 18 Mar 2005 17:19:19 -0800 (PST) From: Steve Crawford Organization: Pinpoint Research To: "Joel Fradkin" , Subject: Re: linux question might be bad forum for it. Date: Fri, 18 Mar 2005 17:19:18 -0800 User-Agent: KMail/1.5.1 References: <000001c52c16$914618c0$797ba8c0@jfradkin> In-Reply-To: <000001c52c16$914618c0$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200503181719.18822.scrawford@pinpointresearch.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.09 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/295 X-Sequence-Number: 16793 On Friday 18 March 2005 3:59 pm, Joel Fradkin wrote: > I have a Redhat AS4 server I set up just for postgres and it has > thus far been extremely excellent. > > I am getting to the final stages of my conversion from MSSQL and I > want to make sure I am doing things correctly. > > I wanted to be able to use VNC for remote admin (is this the best > tool?) ... For a dedicated PG server SSH is the best remote tool. It's a server - it doesn't need to run a GUI. Save the memory and CPU for its real purpose. VNC can place a heavy load on a machine (worse on a Windows server than *nix but still...). > The other concerns I have are making sure I have a good backup > (that I can restore) and a regular vacuum. I have been following > threads and have seen the mention of no need to do a Vacuum > verbose. What are the best tools for doing the auto vacuum and > backup. I have the Linux box and also will have local windows boxes > where I can set up programs to do automated SQL tasks. Read up on pg_autovacuum for vacuuming. Start with pg_dumpall for regular backups - filesystem backups are not sufficient. Then if you want, look into the new features in 8.x that allow you to do continuous on-line backups: http://www.postgresql.org/docs/current/static/backup-online.html Scheduled tasks are probably best handled from a *nix machine - perhaps the server itself. The cron+script+psql combo can go a long way. Cheers, Steve