> Date: Fri, 8 Jun 2012 13:56:38 +0800
> From: ring...@ringerc.id.au
> To: pgsql-admin@postgresql.org; fabrix...@hotmail.com
> Subject: [ADMIN] (new thread) could not rename temporary statistics file
> "pg_stat_tmp/pgstat.tmp" to "pg_stat_tmp/pgstat.stat": No such file or
> directory
>
> >
Hi.
I have this problem:
I have PostgreSQL 9.1.3 and the last night crash it.
This was the first error after an autovacuum (the night before last):
<2012-06-06 00:59:07 MDT814 4fceffbb.32e
>LOG: autovacuum: found orphan temp table
"(null)"."tmpmuestadistica" in database
"dbRX"
<2012-06
pt in memory) there should'nt be a problem. Next
> time postmaster is started (and hopefully does start :-) ) the new
> libraries will be used.
>
> Gerhard
>
> On Tue, Feb 15, 2011 at 6:34 AM, Fabricio wrote:
> > Any comment about this?
> >
> > Regards...
Any comment about this?
Regards...
From: fabrix...@hotmail.com
To: pgsql-admin@postgresql.org
Subject: [ADMIN] mapping libraries
Date: Thu, 10 Feb 2011 18:19:33 -0700
Hi...
If i can't upgrade a server with postgres 8.1 and at this time i can't delete a
super user, Is there any way to avoid
Hi...
If i can't upgrade a server with postgres 8.1 and at this time i can't delete a
super user, Is there any way to avoid that the super user mapping libraries in
C code? like system y libc.so ?
regards...
9.0.2. This is a Bug?
> Date: Fri, 14 Jan 2011 17:41:31 -0500
> From: t...@sss.pgh.pa.us
>
> Fabricio writes:
> > A developer is writing a function in C code and when he makes some change
> > and replace the old library with the new one and if run CREATE OR REPLACE
This is a bug?
A developer is writing a function in C code and when he makes some change and
replace the old library with the new one and if run CREATE OR REPLACE FUNCTION
Postgre crash and restart. After restart CREATE OR REPLACE FUNCTION does not
crash postgres, only the first time. He
o: fabrix...@hotmail.com
CC: pgsql-admin@postgresql.org; alvhe...@commandprompt.com
On Sat, Aug 1, 2009 at 1:20 AM, Fabricio wrote:
Hi
Some one know why this is happening?
I change the OS to 64 bits and now the oom-killer not hapend but Postgres is
still showing out of memory
Linux SERVER
eetings
From: fabrix...@hotmail.com
To: alvhe...@commandprompt.com
CC: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] out of memory
Date: Fri, 20 Mar 2009 09:15:05 -0700
Thanks for answer Alvaro
Already i have memory overcommit disabled.
I've always had with the value 2
vm
Thanks for answer Alvaro
Already i have memory overcommit disabled.
I've always had with the value 2
vm.overcommit_memory = 2
Fabricio
> Date: Wed, 18 Mar 2009 20:28:02 -0400
> From: alvhe...@commandprompt.com
> To: fabrix...@hotmail.com
> CC: pgsql-admin@postgresql.
Hi
there's no comments?
Fabricio
From: fabrix...@hotmail.com
To: pgsql-admin@postgresql.org
Subject: [ADMIN] out of memory
Date: Thu, 12 Mar 2009 11:17:52 -0700
Hi
I have a dedicated database server with 16 GB of RAM.
Linux 2.6.27.6 #7 SMP Sun Nov 16 00:48:35 MST 2008 i686 i686
@postgresql.org
On Thu, Mar 12, 2009 at 9:17 PM, Fabricio wrote:
Hi
I have a dedicated database server with 16 GB of RAM.
and the oom-killer is killing my database
What kernel and architecture are you running? Show your `uname -a` please.
--
Vladimir Rusinov
http://greenmice.info
Hi
I have a dedicated database server with 16 GB of RAM.
and the oom-killer is killing my database
this is the output kernel:
postmaster invoked oom-killer: gfp_mask=0xd0, order=1, oomkilladj=0
Pid: 16667, comm: postmaster Tainted: GW 2.6.27.6 #7
[] oom_kill_process+0x103/0x1d5
[] s
In postgresql.conf you can enable connections logs. log_connections = on
> From: [EMAIL PROTECTED]> To: pgsql-admin@postgresql.org> Subject: [ADMIN]
> User info?> Date: Wed, 3 Dec 2008 10:30:22 -0500> > Is there a way to tell
> when the last time a database in a cluster was > accessed? I have a
Hi Marko, thanks for your help...
> There is a bit higher level concept of cpusets too:
>
> http://www.kernel.org/doc/man-pages/online/pages/man7/cpuset.7.html
>
> In both cases, you can either patch Postgres or write a launcher
> that configures CPUs before executing postgres.
This paragr
> I suppose this has nothing to do with PostgreSQL but needs some> operating
> system level tuning. Maybe there is a way to bind the postgres> processes to
> one node's CPUs... What operating system are you using?
I am using Red Hat Enterprise 5.2, kernel 2.6.18-92.el5 x86_64
> I know that
Hi...
I have an IBM server with NUMA architecture, two nodes with 4 CPU quad core and
64 GB of RAM each, and PostgrSQL 8.3.5. Is there any way to avoid the
performance degradation when the load goes up and used the two nodes? I
understand this performance degradation is due to the higher la
hi people
I can set an entry with regular expressions in the file pg_hba.conf?
For example if I have two databases called foo.1 and foo.2.
I can put in the file pg_hba.conf the next entry ?
host myUser foo.? 192.168.0.0/24 md5
or
host myUser foo.[0-9]+ 192.168.0.0/24 md5
greetings
The help of reindex say:
Also, for B-tree indexes a freshly-constructed index is somewhat faster to
access than one that has been updated many times, because logically adjacent
pages are usually also physically adjacent in a newly built index. (This
consideration does not currently apply to
the command dmesg show some message about memory or hard disc?
Do you have vm.overcommit_memory=2 in sysctl.conf?
> Date: Wed, 13 Feb 2008 15:41:10 -0600> From: [EMAIL PROTECTED]> To: [EMAIL
> PROTECTED]> Subject: Re: [ADMIN] terminating connection because of crash of
> another server proc
his credentials and root.crl?
thank you very much by your help.
From: Andreas <[EMAIL PROTECTED]>
To: Fabricio Peñuelas <[EMAIL PROTECTED]>
CC: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] ssl and odbc standar driver
Date: Wed, 08 Aug 2007 20:00:34 +0200
Fabricio Peñuelas
ent?
sorry for my bad english... :)
From: Andreas <[EMAIL PROTECTED]>
To: Fabricio Peñuelas <[EMAIL PROTECTED]>
CC: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] ssl and odbc standar driver
Date: Wed, 08 Aug 2007 02:47:54 +0200
In deed it is possible.
You'll need a ssl certifi
Hi!!
It is possible to connect to postgres with odbc standar driver and ssl
enabled ??
Es posible conectarme a postgresql con odbc standar driver y ssl activado?
thanks!!!
_
El mejor destino, con los mejores contenidos http://w
He estado leyendo sobre la configuracion de postgresql, pero tengo un
servidor que no me da el rendimiento que deveria de dar, lo monitoreo con
top, ps y pg_stat_activity y para lo que esta haciendo no deberia de ponerse
tan lento a como se pone, las tablas estan bien indexadas y se realizan
Title: iColony - Departamento de Projetos
Paulo Fabrício Puga
MirandaDesenvolvimento de TIfabricio
@icolony.com.br(31) 9691-3494
Title: iColony - Departamento de Projetos
Paulo Fabrício Puga
MirandaDesenvolvimento de TIfabricio
@icolony.com.br(31) 9691-3494
26 matches
Mail list logo
