X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 13CC85E46C4 for ; Thu, 12 Aug 2004 14:58:54 -0300 (ADT) 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 73798-10 for ; Thu, 12 Aug 2004 17:58:49 +0000 (GMT) Received: from mail.winfreeacademy.com (unknown [12.45.130.164]) by svr1.postgresql.org (Postfix) with ESMTP id D3B665E46CC for ; Thu, 12 Aug 2004 14:58:48 -0300 (ADT) Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by mail.winfreeacademy.com (Postfix) with ESMTP id 33AE51C386 for ; Thu, 12 Aug 2004 13:08:20 -0500 (CDT) Received: from mail.winfreeacademy.com (localhost.localdomain [127.0.0.1]) by localhost.localdomain (VaMailArmor-2.0.1.16) id 02273-14FE1AA3; Thu, 12 Aug 2004 13:08:20 -0500 Received: from winfreeacademy.com (ns1.winfreeacademy.com [12.45.130.162]) by mail.winfreeacademy.com (Postfix) with ESMTP id 1BE441C385 for ; Thu, 12 Aug 2004 13:08:20 -0500 (CDT) Message-ID: <411BB0C8.8040204@winfreeacademy.com> Date: Thu, 12 Aug 2004 13:02:48 -0500 From: Laura Vance Reply-To: vancel@winfreeacademy.com Organization: WACS User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: Re: My admin left the job and I am stuck References: <20040811184143.98784.qmail@web53901.mail.yahoo.com> In-Reply-To: <20040811184143.98784.qmail@web53901.mail.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiVirus: checked by Vexira MailArmor (version: 2.0.1.16; VAE: 6.27.0.4; VDF: 6.27.0.9; host: mail.winfreeacademy.com) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/528 X-Sequence-Number: 64083 All of the resources you need are at http://www.posgresql.org/ But, a quick note on how to connect to the database, you don't need to really know where it's installed, just that it's running and accepting connections. Under Linux "netstat -tapn" will show you all of the open TCP ports and what's listening to each. For Postgres, the default port is 5432 and the process is called postmaster. You may need to be logged in as root to see this. First thing is that knowing SQL basics is pretty much required before you can really investigate what he had set up. Second thing is to connect by using the following command: psql Without any arguments, it will connect to the local machine and to a database named for the current user. Once in psql, type \d to see a list of the user-defined tables. To see a list of databases type \l and you will be shown a list of databases. From there, you can explore until your heart's content. Everything is SQL compliant, so if you know SQL, you shouldn't have any problems. As for Linux admin, the most important thing to remember is that everything is case sensitive. ls != LS If you're coming from the MS world, take some time to really learn Linux... I'm sure you'll like it and eventually you'll prefer it. I use Linux as my only OS at home, and I finally have a job where I use Linux at work (they adopted it after I submitted a proposal). hope this helps! Laura Karam Chand wrote: >Hello, > >My linux admin left the job. We had a PostgreSQL >installed under his username. He used to maintain it. >Now I am looking at the Linux box and I am just a >super duper newbie in Linux administration. > >The previosu admin had a database created under his >name coz PostgreSQL dosnt allow root database. > >Now I want to get the data back and use it? I dont >mind if I have to use a different DB? > >I dont even know where he isntalled the PostgreSQL >binaries and data? > >Where can I all this information? > >I am feeling really stupid but thank GOD we dont have >any live databases running? > >Regards, >Karam > > -- Thanks, Laura Vance Systems Engineer Winfree Academy Charter Schools 6221 Riverside Dr. Ste 110 Irving, Tx 75039 Web: www.winfreeacademy.com