Re: [ADMIN] Postgres 8.3.x upgrade

2009-01-22 Thread ries van Twisk
On Jan 22, 2009, at 9:50 AM, Jessica Richard wrote: We are going to upgrade our Postgres servers (most 8.2.9 and some 8.2.4) to the 8.3.x version. From the postgres web site, I can see the 8.3.5 is the latest version. Question for people who have been on 8.3.5: Is 8.3.5 very safe to use (n

Re: [ADMIN] tsearch2 clock skew

2009-02-11 Thread ries van Twisk
On Feb 11, 2009, at 2:53 PM, dx k9 wrote: make: warning: Clock skew detected. Your build may be incomplete. google is your friend : http://www.google.com/search?client=safari&rls=en-us&q=make:+warning:++Clock+skew+detected.++Your+build+may+be+incomplete.&ie=UTF-8&oe=UTF-8

Re: [ADMIN] [SQL] Can we load all database objects in memory?

2009-03-25 Thread ries van Twisk
Deepak, please don't cross-post the same question to 3 different lists. The short answer is no, you cannot force PostgreSQL to load all objects into memory. However when you proper configure PostgreSQL most, if not all of your data will be cached by the OS and/or PostgreSQL shared memory

Re: [ADMIN] Deleting "parent" record

2009-04-24 Thread Ries van Twisk
On Apr 24, 2009, at 10:00 AM, Félix Sánchez Rodríguez wrote: Hi: I can't delete a "parent" record from a table. The relation has "ON UPDATE CASCADE ON DELETE CASCADE". As far as know, that causes that when you delete a record from the parent table, the related one from the child table wi

Re: [ADMIN] How to run PostgreSQL?

2009-05-07 Thread Ries van Twisk
On May 7, 2009, at 7:26 AM, Ray Stell wrote: On Thu, May 07, 2009 at 04:38:59AM -0700, Jan Muhammad wrote: Hi, I have just downloaded, installed/configured postgresql version 8.2.11 on Fedora Core 6. While reading through the installation manual have setup most of its parts; now while try

Re: [ADMIN] Primary key on existing table?

2009-08-25 Thread Ries van Twisk
mailpref/pgsql-admin regards, Ries van Twisk - tags: Freelance TYPO3 Glassfish JasperReports JasperETL Flex Blaze-DS WebORB PostgreSQL DB-Architect email: r...@vantwisk.n