Any Tips or Tricks?

[Joseph A. Nagy, Jr.]

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.

TIA

[Chris]

Post by Joseph A. Nagy, Jr.
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.

Have a look at these:

phppgadmin: http://phppgadmin.sourceforge.net/
pgadmin3: http://www.pgadmin.org/pgadmin3/index.php

Bye, Chris.



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[scott.marlowe]

Post by Joseph A. Nagy, Jr.
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. :-)




---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings