Skip site navigation (1) Skip section navigation (2)

Re: Any Tips or Tricks?

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: "Joseph A(dot) Nagy, Jr(dot)" <jnagyjr(at)joseph-a-nagy-jr(dot)homelinux(dot)org>
Cc: PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Any Tips or Tricks?
Date: 2004-04-19 15:55:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Sat, 17 Apr 2004, Joseph A. Nagy, Jr. wrote:

> I'm new to PostgreSQL and I was wondering if there were any tips or tricks
> to admining a postgre db and if there are any tools like phpmyadmin for
> postgre.

My biggest tips would be:

Get to know psql.  The postgresql monitor, with history, tab completion, 
and syntax diagrams built right in is often the most overlooked tool in 
the box because it isn't a GUI.  It might not be point and click but it is 
rich in capability, and pretty easy to use.

The second would be to search the archives of the mailing lists, as the pg 
community is one of the best online mailing list communities I've ever 
dealt with.  most questions are already answered somewhere in here, if you 
just use the right keywords to find it.

The last tip would be "don't be afraid to ask questions."   People here 
hardly ever bite.  :-)

In response to

pgsql-admin by date

Next:From: scott.marloweDate: 2004-04-19 15:58:37
Subject: Re: PGfs Codebase? even old version????bb at wv dot com
Previous:From: Bojan BelovicDate: 2004-04-19 06:53:28
Subject: Extremely high context switching

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group