pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Laura Vance <vancel@winfreeacademy.com>
To: pgsql-general@postgresql.org
Subject: Re: My admin left the job and I am stuck
Date: Thu, 12 Aug 2004 13:02:48 -0500
Message-ID: <411BB0C8.8040204@winfreeacademy.com> (raw)
In-Reply-To: <20040811184143.98784.qmail@web53901.mail.yahoo.com>
References: <20040811184143.98784.qmail@web53901.mail.yahoo.com>

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





view thread (2+ messages)

Message-ID: <411BB0C8.8040204@winfreeacademy.com>
Permalink:  ../411BB0C8.8040204@winfreeacademy.com/
Also on:    postgresql.org/message-id/411BB0C8.8040204@winfreeacademy.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: vancel@winfreeacademy.com, pgsql-general@postgresql.org
  Subject: Re: My admin left the job and I am stuck
  In-Reply-To: <411BB0C8.8040204@winfreeacademy.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox