Author: dpage
Date: 2005-10-30 16:33:52 +0000 (Sun, 30 Oct 2005)
New Revision: 4621
Modified:
trunk/pgadmin3/docs/en_US/tips.txt
Log:
More tips
Modified: trunk/pgadmin3/docs/en_US/tips.txt
===================================================================
--- trunk/pgadmin3/docs/en_US/tips.txt 2005-10-29 08:48:54 UTC (rev 4620)
+++ trunk/pgadmin3/docs/en_US/tips.txt 2005-10-30 16:33:52 UTC (rev 4621)
@@ -32,4 +32,15 @@
pgAdmin III supports SSL encrypted connections.
The new Win32 port PostgreSQL passed all it's regression tests for the first
time on 2004-10-24.
The Windows port of PostgreSQL was downloaded over 45,000 times in the five
days following its initial release!
-
+The bug "Don't enable the OK button when setting the ACL for as-yet-uncreated
objects" was fixed at 39,000 feet over Finland whilst Andreas, Magnus and Dave
returned from Slony-I and pgAdmin III presentation in Japan!
+Configuring PostgreSQL with too many shared buffers can have a detrimental
effect on performance because it reduces the amount of RAM available for the
operating system kernel to use as filesystem cache.
+Sitting on a plane for 12 hours is really mind numbingly boring which is why
I'm writing new tips right now!!
+The Japan PostgreSQL Users Group or JPUG has over 5000 members and is growing
all the time.
+pgAdmin 1.4 is supported on more platforms than any previous version,
including numerous Linux distributions, Microsoft Windows (tm), FreeBSD,
Solaris and Mac OS X.
+pgAdmin 1.4 includes a graphical EXPLAIN tool to allow you to more easily read
and understand query plans.
+pgAgent can be used to schedule regular batch and SQL jobs, such as the
re-creation of date-sensitive partial indexes, or purging of old records.
+It is good practice to build application logic into the database itself by
using functions and views. This ensures that different front-ends to your
products will always see the same views of data and update and modify data in
the same way. Better yet, you only have to write it all once for all front-ends!
+To help keep your databases secure, minimise the amount of access you allow to
remote hosts when creating your pg_hba.conf file, and always use encrypted
connections unless you have good reason not to.
+You can restrict access to individual columns of a table for a particular user
or group by denying them drect access to it, and creating a view containing
only the columns they should see for them to use instead. If your users need to
update the data, you can create rules to apply updates to the view to the base
table instead.
+PostgreSQL has been run on diverse platforms such as the Microsoft X Box, Sony
PlayStation II, and Sharp Zaurus PDAs!
+EnterpriseDB donated an Apple Powerbook to the pgAdmin project to help improve
the Mac OS X port of pgAdmin and their simplified derivative product, EDB
Studio.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
