Tom Lane a écrit :
Nicolas Michel writes:
- I have 16Go of RAM on that server (but 32bits OS with bigmem kernel ;
so I set shared buffer to 35 (~2,7GB) for a shmmax of 40
(~3,8GB)
On a 32-bit machine that's just insane. You've got something like 300MB
left over in t
electronic newsletter, send an e-mail to newsletter-...@setonhome.org
---
Nicolas Michel wrote:
Tom Lane a écrit :
Nicolas Michel writes:
I have a problem with a database. The last full vacuum analyse was made
long time ago... So I tried to start l
Tom Lane a écrit :
Nicolas Michel writes:
I have a problem with a database. The last full vacuum analyse was made
long time ago... So I tried to start launching a vacuum analyse and I
get this error :
$ vacuumdb -az
vacuumdb: vacuuming database "postgres"
VACUUM
vacuumdb: vacuumin
I have a problem with a database. The last full vacuum analyse was made
long time ago... So I tried to start launching a vacuum analyse and I
get this error :
$ vacuumdb -az
vacuumdb: vacuuming database "postgres"
VACUUM
vacuumdb: vacuuming database "mexi"
vacuumdb: vacuuming of database "mexi" f
Hello,
I made a mistake an got a character set in SQL_ASCII as the defaut
encoding type :
$ psql -l
List of databases
Name | Owner | Encoding
--+--+---
cmp_crm | openerp | SQL_ASCII
cmp_crm_demo | openerp | SQL_ASCII
cmp_testcrm | op
There was indeed a blank after the line (after the password)... ^^
To Scott : yes, I set the file with 0600 permissions ;)
Thank you very much for your help.
Le lundi 18 mai 2009 à 11:59 -0400, Tom Lane a écrit :
> Nicolas Michel writes:
> > I tried to put my password in a .pgpass
Hi here,
I'm trying to make my dump script working but it is not.
I tried to put my password in a .pgpass file into the home directory of
the root user (so /root/.pgpass). Here is a cat of that file :
*:*:*:*:test
(I tried only with stars to be sure my rule was not too strict).
So, il I try thi
Message transféré
> De: Flavio Henrique Araque Gurgel
> À: pgsql-admin
> Cc: Nicolas Michel
> Sujet: Re: Memory Problem
> Date: Sat, 4 Apr 2009 10:58:45 -0300 (BRT)
>
>
> Hello!
>
> > Thank you very much. I didn't know that. I set m
> side effect your value 4294967296 in a binary 32bit representation is
> exactly 0. look for previous threads about shmmax. and use a 64bit system :)
>
> regards
> thomas
>
> Nicolas Michel schrieb:
> > Hi here,
> >
> > Our server had 2GB of RAM. We added
Hi here,
Our server had 2GB of RAM. We added some memory to have 16GB. We are on
a debian etch. I installed the "bigmem" kernel to use the all memory :
~# cat /proc/meminfo
MemTotal: 16573232 kB
MemFree: 15448836 kB
Buffers:133772 kB
Cache
I knew that but thank you to for your advices ;)
Le mercredi 25 mars 2009 à 09:33 -0600, Scott Marlowe a écrit :
> On Wed, Mar 25, 2009 at 9:25 AM, Nicolas Michel
> wrote:
> > Ok. Thank you.
> >
> >
> > Le mercredi 25 mars 2009 à 15:32 +0100, Guillaume Lelarge a
Ok. Thank you.
Le mercredi 25 mars 2009 à 15:32 +0100, Guillaume Lelarge a écrit :
> Le mercredi 25 mars 2009 à 14:35:36, Nicolas Michel a écrit :
> > [...]
> > I already have an instance with a database. I want to move the WAL files
> > to an other hard disk to have a bet
Hi here,
I already have an instance with a database. I want to move the WAL files
to an other hard disk to have a better speed.
I read that I had to create a symbolic link to do that. Is there another
"cleaner" way : an option in the postgres config file??
Thank you,
13 matches
Mail list logo
