Re: [ADMIN] dump from 9.0 to 8.3

2011-06-21 Thread CaT
On Tue, Jun 21, 2011 at 09:10:50AM +0300, Achilleas Mantzios wrote: > Στις Monday 20 June 2011 18:46:33 ο/η Kevin Grittner έγραψε: > > Achilleas Mantzios wrote: > > > > > is there any quick and dirty (or otherwise easy way) to have a > > > smooth procedure to load into a 8.3 server data dumped b

Re: [ADMIN] Time Zone in Postgres

2008-03-06 Thread cat
th its own timezone info. Check if the stuff it has has the right timezone information. Personally I get it to use the system timezone definitions so that I can keep things upto-date easier. -- CaT -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] pgpool question?

2007-09-20 Thread CaT
On Wed, Sep 19, 2007 at 09:59:22PM -0700, Charles.Hou wrote: > i have installed the pgpool in the server and start it. but how can i > know it's working? i means that the clients connected to the > database > by the pgpool. The latest versions of pgpool2 (I don't use pgpool) have connection loggi

Re: [ADMIN] Priviliges and Roles

2006-02-27 Thread CaT
On Mon, Feb 27, 2006 at 12:09:48PM +, Dayo Johnson wrote: > Hello, > > Is it possible to do the following: > Disallow permission to write to a table (either by UPDATE or INSERT) but > allow EXECUTE permission on a Function that writes to the table ? > > The reason I want to do this is so tha

Re: [ADMIN] Is this a "Stupid Question" ?

2004-06-20 Thread CaT
On Sun, Jun 20, 2004 at 07:50:53PM -0700, Adam Smith wrote: > I am attempting an install of 7.4.3 on FreeBSD O/S 4.9, apparently > remnants of 7.3.x are scattered around on the disk from (a) previous > ports installation, causing mutex_lock/unlock, libpq.so and other > installation problems. I w