Re: [ADMIN] increasing of the shared memory does not solve the problem of "OUT of shared memory"

2007-05-12 Thread Jim C. Nasby
On Fri, May 11, 2007 at 04:58:28PM +0300, Sorin N. Ciolofan wrote: > I increased significantly the number of shared buffers from 3000 to 100 000 > (80Mb) BTW, 100,000 shared buffers is actually 800MB, not 80. -- Jim Nasby[EMAIL PROTECTED] EnterpriseDB

Re: [ADMIN] User rights

2007-05-12 Thread Jim C. Nasby
On Wed, May 09, 2007 at 12:43:55PM -0700, ebmb wrote: > Hello all, > I'm a MySQL user and trying to migrate some applications to > PostgreSQL 8.1.9. My first question is about Postgre administration... > > I would like to know if is possible to revoke users access to > commands like "\l, \du, \

Re: [ADMIN] Moving data directory

2007-05-12 Thread Linux Geeks
Hi Srinivas, Is it permanently change it ? Do I have to change some entry in configuration file ? Regards, Dino On 5/12/07, Srinivas Kotapally <[EMAIL PROTECTED]> wrote: You can do an initdb -d /var/lib/postgresql to initialize the data directory in the /var/lib/postgresql directory. If you

Re: [ADMIN] Moving data directory

2007-05-12 Thread Srinivas Kotapally
You can do an initdb -d /var/lib/postgresql to initialize the data directory in the /var/lib/postgresql directory. If you also have data in the /usr/lib/postgresql - make sure you back it up and restore it in the new directory. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PR

[ADMIN] Moving data directory

2007-05-12 Thread Linux Geeks
Hi All, I'm very new to postgresql and would like to move my data directory to another partition in Ubuntu. The standard installation is in /usr/lib/postgresql. How do I move it into /var/lib/postgresql. Regards, Dino -- To Analyze Is To Know Batte Field, Differ from Battle Itself ---