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
Finlandwhilst 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
theamount 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,
MicrosoftWindows (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,
orpurging of old records.
+It is good practice to build application logic into the database itself by using functions and views. This ensures
thatdifferent 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.conffile, 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
toit, and creating a view containing only the columns they should see for them to use instead. If your users need to
updatethe 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
simplifiedderivative product, EDB Studio.
