X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 5F0A29FA508 for ; Sun, 23 Jul 2006 21:37:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 46062-07 for ; Sun, 23 Jul 2006 21:37:55 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.178]) by postgresql.org (Postfix) with ESMTP id C24219FA48B for ; Sun, 23 Jul 2006 21:37:54 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id b36so1817280pyb for ; Sun, 23 Jul 2006 17:37:53 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=tnktzcBYLLUtElHh5q4gg4BwYgUACXPFAf/UhK+yPpjfgJtpbf48Y5zqSVO5IM7KXc6ldmm9ChWtG7YGyyUkOLIDthCwlHmSoxL00dWNwQ7DhT774tWXlFQzjxDY6+QLDSguVBEDLdlTHh/jlU06wEFvoYNhzFOX4AhOPLpDt6o= Received: by 10.35.76.5 with SMTP id d5mr6450443pyl; Sun, 23 Jul 2006 17:37:53 -0700 (PDT) Received: by 10.35.58.13 with HTTP; Sun, 23 Jul 2006 17:37:53 -0700 (PDT) Message-ID: <16023b030607231737k27e7cd4ar9fd0a3fbad2c54c7@mail.gmail.com> Date: Sun, 23 Jul 2006 21:37:53 -0300 From: "Nabil Sawaya" To: "Mark Matthews" Subject: Re: DBA tasks Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.199 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200607/185 X-Sequence-Number: 22431 Hello friend, Well, I have not a tutorial at hand now, but i can say to you some tasks i remember, and these can make you spent a long time learning about how to do. I think that the tasks essentially you must to know are: - Install database - Configure the two most important files (pg_hba.conf and postgresql.conf) - Install an know how to use psql - Install an IDE Tool - originally, PgAdmin - You can get a plus using PgAgent, to do jobs, etc... - Create a Database, set encoding char, etc... - Install a Procedural Language as PL/pgSQL - Create Tablespaces (8.0 or higher) (It=B4s more important know why use tablespaces before create them) - Database Roles and Privileges - Managing Databases - Client Authentication - Backup and restore - Monitoring Database activity - Monitoring disk usage three tips: 1) do not use vacuum all the time. schedule daily and weekly it. 2) learn about re-index 3) sometimes is better make a dump than vacuum and re-index. that=B4s all if you wish more, send another questions to my e-mail Hugs Nabil Sawaya