First of all, Thanks for response, answers below.
On Mon, Jul 15, 2013 at 4:12 PM, Kevin Grittner wrote:
> Rafael Domiciano wrote:
>
> > PostgreSQL 9.2.2 on x86_64-unknown-linux-gnu, compiled by gcc
> > (GCC) 4.4.6 20120305 (Red Hat 4.4.6-4), 64-bit
>
> >
Hello all you guys,
I've sent the same problem in performance list. Some answered me, but
didn't resolved the situation.
Since 2 weeks I'm get stucked in a very strange situation: from time to
time (sometimes with intervals less than 10 minutes), the server get
"stucked"/"hang" (I dont know how t
CONCURRENTLY' as 9.2.2
Why don't you try to reindex the indexes in your database and see it
this helps?
regards,
- --
Rafael Martinez Guerrero
Center for Information Technology
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafae
Hello,
What i have to do to remove the following post:
http://archives.postgresql.org/pgsql-admin/2009-09/msg00141.php
Thnks,
Rafael
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- Original Message
Subject: Re: [ADMIN] psql error on postgresql-9.0 : psql: symbol lookup
error: psql: undefined symbol: PQconnectdbParams
Date: Wed, 28 Dec 2011 16:03:31 +0530
From: Suresh Hosur
To: Rafael Martinez
Hello
ql) and which libpq your executables are trying to use
(ldd /path_to_executable/psql).
You can either delete the libpq installed in your system and use the one
you have installed under /usr/pgsql-9.0/, or upgrade the libpq in your
system to a version compatible with what you have installed under
-06-15 23:36 pgstat.stat
> -rw-r--r-- 1 novell novell 0 2011-06-15 23:36 a
>
Hei
Are you running postgres with the user 'novell' or 'postgres'?
The user running postgres must own the directories with the data.
regards,
- --
Rafael Martinez Guerrero
Center for Inform
user permissions
but i can't find exactly what is causing this.
I'd like to replicate this behaviour for other database since my goal is to
use the root user for executing cron task (where a password prompts is
highly annoying)
Any help will be appreciated, thanks in advance!
Rafael
Rrtrtt
BlackBerry de movistar, allí donde estés está tu oficin@
-Original Message-
From: Alvaro Herrera
Sender: pgsql-admin-ow...@postgresql.org
Date: Wed, 23 Jun 2010 13:11:44
To: Senthil Kumar G
Cc: sivakumar krishnamurthy; Kevin
Grittner; pgsql-admin
Subject: Re: [ADMIN] Unable to st
Rtt
BlackBerry de movistar, allí donde estés está tu oficin@
-Original Message-
From: Alvaro Herrera
Sender: pgsql-admin-ow...@postgresql.org
Date: Wed, 23 Jun 2010 13:11:44
To: Senthil Kumar G
Cc: sivakumar krishnamurthy; Kevin
Grittner; pgsql-admin
Subject: Re: [ADMIN] Unable to start
Hello Luis:
Existen personas que estamos en este foro que hablemos Español, pero para
que te puedan contestar mejor y de forma más rápida deberías formular la
pregunta en ingles. Si tienes cualquier problema con la traducción puedo
ayudarte.
There are persons in this forum that can speak Spanish
Hello,
I Think you can this kind of information at pg_proc.prosrc
Best Regardas,
Rafael Domiciano
On Fri, Oct 2, 2009 at 3:57 AM, Julius Tuskenis wrote:
> Hello, everybody
>
> I tried to find where in pg_catalog stored functions are stored, but with
> no success. Are they
34"... googling a while I get
that this is a invalid DN syntax. But i thing the pg_hba.conf is ok.
Has anyone get the same trouble? Helps?
Best Regards,
Rafael Domiciano
Boa Tarde Venkat,
Acredito que o erro está na sua chamada da função dblink_exec:
SELECT * FROM dblink_exec('hostname=sys2ip dbname=testB user=postgres
password=postgres','INSERT INTO emp NEW.*');
Pelo fato de você estar passando o NEW dentro de aspas, o postgres está
entendendo que é uma string
Hello People,
I upgraded to a 64 bits System. Now, everything is OK. Thnk you guys.
On Sat, Jul 11, 2009 at 2:19 AM, Scott Marlowe wrote:
> On Fri, Jul 10, 2009 at 10:27 PM, wrote:
> >
> > 2G per process is plenty ...and useful if you have large data warehouse
> style queries which are long runn
Thnks for the replyies.
It's a slony slave db, for reporting.
So, what's a good value to set to effective_cache_size with 10 Gb RAM?
On Thu, Jul 9, 2009 at 9:05 PM, Scott Mead wrote:
>
> On Thu, Jul 9, 2009 at 6:18 PM, Rafael Domiciano <
> rafael.domici...@gmail.com>
ct version();
version
---
PostgreSQL 8.3.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.3.0
20080428 (Red Hat 4.3.0-8)
(1 row)
Thnks,
Rafael Domiciano
ously considered unsupported; and testing of the case found some
bugs that are now fixed."
I don't know what "some bugs that are now fixed" means, but I think I
read somewhere that killing a session with the command kill was not a
god idea.
regards
--
Rafael Martinez,
ot do this yet :(
It's an open item in the TODO list:
http://wiki.postgresql.org/wiki/Todo
And yes, it will be a good thing to have.
--
Rafael Martinez,
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
--
Sent via
On Thu, Apr 23, 2009 at 4:06 PM, Kevin Grittner wrote:
> Rafael Domiciano wrote:
>
> > Doing the alter table to add the new column was fast: ALTER TABLE
> > table1 ADD COLUMN new_column date;
>
> So far, so good.
>
> > The problem is that I have to do a update i
:
update table1
set new_column = (date)
where
new_column is null;
Postgres Version: 8.3.6
Os.: Fedora Core 9
4 Gb Ram
On Thu, Apr 23, 2009 at 2:29 PM, Kevin Grittner wrote:
> Rafael Domiciano wrote:
>
> > I have a large table to do update (in every tuple), the table
> > (t
hat I have a Design Problem level, but don't,
new_column have to belong to table1, in this especific case.
Thks for response,
Rafael Domiciano
On Tue, Mar 31, 2009 at 1:20 PM, Scott Marlowe wrote:
> On Tue, Mar 31, 2009 at 10:04 AM, Rafael Domiciano
> wrote:
> > Hello People,
> >
> > I have some doubts about Vacuum Full. There We go:
> > 1) The Only thing that Vacuum Full (Only Full, not Analyze) is to
al Bytes Done Total Bytes Remaining
Table011000 600 400
Or Something like that!
Thnks for responses,
Rafael Domiciano
11:01 AM, Rafael Domiciano
> wrote:
> > I used to run vacuum full in one of my bases, but now i'm not running
> > anymore vacuum full, just vacuum analyze in the past 1 month, but the
> number
> > of necessary pages is increasing every day, now it's in 311264... ther
ago, this number get not decreased.
I now that vacuum full reorders the relation, but it's the only thing that
it does?
Thnks,
Rafael Domiciano
On Thu, Feb 19, 2009 at 1:37 PM, Scott Marlowe wrote:
> On Thu, Feb 19, 2009 at 9:35 AM, Jessica Richard
> wrote:
> > I am running "
what i'm looking for. But pg_cluster seems that is no more
upgraded, and there is a lot of bugs and errors.
I'm trying now the CyberCluster from CyberTech, developed under pgcluster.
I hope that you could understand the scenario.
Thnks,
Rafael Domiciano
On Mon, Feb 16, 2009 at 5:01
very poor, and the installation
was unsuccesfull.
I would like to know from you what solution you uses for avoiding downtime,
so I could choose the solution that is best to my scenario and for others
that is begining in Postgres and is a little lost in replication.
Thnks for all,
Rafael Domician
the dirty_ratio = 30 and the dirty_background_ratio = 1.
I don't know what more to do to solve this slow down problem.
Somebody have any ideia?
Thnks,
Rafael Domiciano
2008/12/9 Rafael Domiciano
> Maybe Could be Check-Points? I have changed the parameters sometime ago.
> Foll
cott Marlowe <[EMAIL PROTECTED]>
> On Mon, Dec 8, 2008 at 10:17 AM, Rafael Domiciano
> <[EMAIL PROTECTED]> wrote:
> > Here's the output. While the process was running my database get sometime
> > without doing anything.
> > You said that I probably get low number
1 Drive Only. This server has no RAID.Do you think that the I/O is very high
and I'm needing a RAID?!
2008/12/8 Scott Marlowe <[EMAIL PROTECTED]>
> On Mon, Dec 8, 2008 at 9:11 AM, Rafael Domiciano
> <[EMAIL PROTECTED]> wrote:
> > How I do to see my I/O subsystem? vms
No, I'm gonna to try
2008/12/8 Scott Marlowe <[EMAIL PROTECTED]>
> On Mon, Dec 8, 2008 at 6:04 AM, Rafael Domiciano
> <[EMAIL PROTECTED]> wrote:
> > Hello guys,
> > I tried to modify my vacuum routine, and started to only run vacuum
> verbose
> >
Hard Drive is a SATA-II 150 Gb, dedicate to postgres service.
2008/12/8 Scott Marlowe <[EMAIL PROTECTED]>
> On Mon, Dec 8, 2008 at 6:04 AM, Rafael Domiciano
> <[EMAIL PROTECTED]> wrote:
> > Hello guys,
> > I tried to modify my vacuum routine, and started to only ru
The machine is a: 2 x Intel Xeon Dual-Core 2.3 GHz, 2 Gb RAM. The load on
machine is about at 1 transactions / m
Maybe I need more RAM memory?
2008/11/26 Scott Marlowe <[EMAIL PROTECTED]>
> On Wed, Nov 26, 2008 at 12:54 PM, Matthew T. O'Connor <[EMAIL PROTECTED]>
>
ED]>
> 2008/11/26 Rafael Domiciano <[EMAIL PROTECTED]>:
> > The database has around 40 Gb.
> > If I not use vacuum full everyday the database get very slow.
> >
> > There is no deadlock on the database.
>
> You didn't mention if you were using autovac
de índice foram removidas, 0 são reutilizáveis.
CPU 0.17s/2.12u sec elapsed 11.04 sec.
INFO: índice "caeindclf_10" agora contém 6906667 versões de registros em
20537 páginas
DETAIL: 63 versões de registros de índices foram apagadas.
1035 páginas de índice foram removidas, 1035 são
Rafael Domiciano wrote:
Hei
> I need some help or just some hints. I am having problems with vacuum
> full in one table only: "clifatura".
> That table has today around 7 million rows.
>
How big is the database?
> I scheduled on the server a cron job to run VACUUM F
ing
to do.
I hope anyone have some information.
Thanks,
Rafael Domiciano
chine.
For autovacuum settings you need to set and see if it's ok for you.
to see if the vacuum is running you can use the command "ps axf | grep
postgres" on the linux server. Sometimes autovacuum is so fast that you even
notice him.
I hope that I helped
Best Regards,
Rafael Domic
Hi there.
I increased the wal_buffers and no change made.
I'm beggining to think that my problem is not related to "checkpoint & cia"
as I said early.
I have decreased the checkpoint_timeout to 3 min and the slow down
continuin' ocorring after each 5 min.
In this "slowdown" the postgres does nothi
ttner <[EMAIL PROTECTED]>
> >>> "Rafael Domiciano" <[EMAIL PROTECTED]> wrote:
> > What Does wal_buffers do?
>
>
> http://www.postgresql.org/docs/8.2/interactive/runtime-config-wal.html#GUC-WAL-BUFFERS
>
> -Kevin
>
round
> #bgwriter_lru_maxpages = 5 # 0-1000 buffers max written/round
> #bgwriter_all_percent = 0.333 # 0-100% of all buffers
> scanned/round
> #bgwriter_all_maxpages = 5 # 0-1000 buffers max written/round
>
> I am trying now to increase the checkpoint_s
u_maxpages = 5 # 0-1000 buffers max written/round
> #bgwriter_all_percent = 0.333 # 0-100% of all buffers
> scanned/round
> #bgwriter_all_maxpages = 5 # 0-1000 buffers max written/round
>
> I am trying now to increase the checkpoint_segments to
ments to 40...
>
> 2008/10/8 Brad Nicholson <[EMAIL PROTECTED]>
>
> On Wed, 2008-10-08 at 10:31 -0200, Rafael Domiciano wrote:
> > The server is running Postgres 8.2.4
> > When the server is doing too much operations like I, U or D the
> > postgres stop a while
#bgwriter_all_percent = 0.333 # 0-100% of all buffers
scanned/round
#bgwriter_all_maxpages = 5 # 0-1000 buffers max written/round
I am trying now to increase the checkpoint_segments to 40...
2008/10/8 Brad Nicholson <[EMAIL PROTECTED]>
> On Wed, 2008-10-08 at 10:31 -020
Ok,
I'm trying this...
Thnks a lot!
2008/10/6 Scott Marlowe <[EMAIL PROTECTED]>
> On Mon, Oct 6, 2008 at 7:56 AM, Rafael Domiciano
> <[EMAIL PROTECTED]> wrote:
> > I'm using 8.3.3 version in this machine..!
> > So, the shared_buffers set to 100Mb is ok
read a several names to it like: gap, stall, slowdown... I don't know the
write expression for this situation.
I hope you can help me.
Thnks,
Rafael Domiciano
Postgres DBA
2008/10/7 <[EMAIL PROTECTED]>
> What version of postgres are you running ? and please also provide
this slowndown is occuring for 5 min...! So I'm suposing
that the problem is in the checkpoint_timeout.
What's the impact to chang it to:
checkpoint_timeout = 2min or
checkpoint_timeout = 5min
Tnhks,
Rafael Domiciano
M
300 GB HD
Postgres 8.3
Dual Core
2008/10/6 Scott Marlowe <[EMAIL PROTECTED]>
> On Mon, Oct 6, 2008 at 5:52 AM, Rafael Domiciano
> <[EMAIL PROTECTED]> wrote:
> > HI people,
> > I'm tuning a server that is a long time abandoned, and this server is a
> > li
t online at now)
My qustion is about shared_buffers, in postgresql.conf I have: min 128kB or
max_connections*16kB # (change requires restart)
So I did:
300 * (16Kb / 1024) = 4,69?
What this result means?
Thnks all,
Rafael Domiciano
tarted the vacuum daemon.
All machines I had problems are Slony-slaves.
Best Regards,
Rafael Domiciano
Postgres DBA
2008/9/30 Steve Crawford <[EMAIL PROTECTED]>
> Carol Walter wrote:
>
>> Ah-h-h, that's exactly my question. What part of Postgres "takes care of
>
Hello,
If you want to get the value of a autogenerated column it's better to use
"RETURNING"
insert into something returning primary key...
Best Regards,
Rafael Domiciano
Postgres DBA
2008/9/15 Scott Marlowe <[EMAIL PROTECTED]>
> On Mon, Sep 15, 2008 at 11:53 A
Did you verified if isn't the software that is doing this?
2008/8/12 subamathy <[EMAIL PROTECTED]>
> Hi,
> We are having problems resulting from users being able to create
> duplicate records
> in table.
>
> Below is the description of the table
> Column | Type | Modifiers
>
ng a little bit, I discovered that possibly my pg_hba.conf is
wrong.
I tried to change the "auth-method", but or I couldn't connect to the base
(if I pass the user and the passwd) or I connected without the passwd.
If someone get a ideia of what to do in this case, would be greatful.
Tnhks all,
Rafael
_TIME
I need to get a time to do a condition.
I couldn't do the SQL
2008/7/28 Kenneth Marshall <[EMAIL PROTECTED]>
> What exactly are you hoping for? I do not think that adding two
> times makes sense. Maybe you want one to be an interval?
>
> Ken
>
> On Mon, Jul
eed to add
explicit type casts.
Postgres version: 8.3.3
Anyone knows anything?
Regards,
Rafael Domiciano
before a long running query.
>
> Cheers,
> Kevin
>
> Alvaro Herrera wrote:
>
>> Rafael Domiciano escribió:
>>
>>
>>> The Postgres version is 8.3.3 and I am using Fedora Core 8.
>>> I have in the actual server around 70 connections the same
No, but is more common Insert and Update than delete.
While I have around 50.000 Insert and Update, in delete is 5.000
2008/6/30 Alvaro Herrera <[EMAIL PROTECTED]>:
> Rafael Domiciano escribió:
> > I have schedelus to run vacuum at the night, it starts at 01:00 AM
>
> D
I have schedelus to run vacuum at the night, it starts at 01:00 AM
2008/6/30 Alvaro Herrera <[EMAIL PROTECTED]>:
> Rafael Domiciano escribió:
> > No, i don't have autovacum.
> > We tried it sometime ago, and the applications began to take "time-out".
> &
ore Xeon 1.5 and 2 Gb RAM.
2008/6/30 Alvaro Herrera <[EMAIL PROTECTED]>:
> Rafael Domiciano escribió:
> > Yes, the server just does S, U, I and D.
> > The queries is pretty simples, don't have huge joins across tables...
> > In this server I have around 500 ta
ediatly".
Today, the monitoring of the server is done using the unix command:
loguptime
With the time we discovered that when loguptime is up than 1.0 the response
begin to late, and the applications begin to take "Time-out".
2008/6/30 Tino Schwarze <[EMAIL PROTECTED]>:
> On M
The Postgres version is 8.3.3 and I am using Fedora Core 8.
I have in the actual server around 70 connections the same time. I am
assigning for this 100.
2008/6/30 Tino Schwarze <[EMAIL PROTECTED]>:
> On Mon, Jun 30, 2008 at 02:52:05PM -0300, Rafael Domiciano wrote:
>
>
ed Buffers" parameter?
The default assigned now is 24 Mb.
Thanks
Rafael Domiciano
Hello,
There a some differences from MySQL to PostgreSQL. In PostgreSQL we use
Functions, what you called "Store Procedures", that do the same thing.
In Postgres you can combine the Functions with "Triggers".
Triggers are procedures that will be done when you do some U, I or D, you
have to specifi
ad already hear some about?
2008/6/13 Tom Lane <[EMAIL PROTECTED]>:
> "Milen A. Radev" <[EMAIL PROTECTED]> writes:
> > Rafael Domiciano написа:
> >> I need to create a role (Postgres user) that cannot drop or create
> table,
> >> but can create TEMP
exist.
Can someone give me a light?!
Thnks
Rafael Domiciano
Senffnet Ltda.
DBA Postgres
LV, we are talking about a few seconds downtime.
Just an idea :)
More information about LVM:
http://www.tldp.org/HOWTO/LVM-HOWTO/
http://www.tldp.org/HOWTO/LVM-HOWTO/snapshotintro.html
http://www.tldp.org/HOWTO/LVM-HOWTO/snapshots_backup.html
with regards
--
Rafael Martinez, <[EMAIL PRO
On Tue, 2006-03-28 at 17:17 -0600, Jim C. Nasby wrote:
> On Wed, Mar 29, 2006 at 01:05:59AM +0200, Rafael Martinez wrote:
> > I work with postgresql every day and I am very happy with it, but this
> > does not mean I can not see the issues that could be improve to have a
> &
t be in the new version (and this can be
a lot of data in a busy/large system)
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
---(end of broadcast)
On Tue, 2006-03-28 at 15:15 -0600, Scott Marlowe wrote:
> On Tue, 2006-03-28 at 13:51, Rafael Martinez wrote:
> > On Tue, 2006-03-28 at 12:09 -0600, Jim C. Nasby wrote:
> >
> > >
> > > Fortunately, you can use Slony to migrate between versions, greatly
> >
investment only
for the upgrade.
I am sure we can find another way of doing this that is easier and
faster.
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
---
a big minus I hear everywhere I explain/discuss
about postgres for 24/7 and big databases.
It would be wonderful to see a solution to these two 'problems' in the
future so postgres becomes an even better product than it is now.
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for
On Tue, 2005-11-08 at 18:23, Moises Alberto Lindo Gutarra wrote:
> you only need make postgres 8.1.0 run using another port, example 5438
>
Or another IP/address (listen_addresses) and the same port 5432. ;)
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technol
body knows when this functionality will be available with
prod-quality?
--
With regards
Rafael Martinez
USIT, University of Oslo
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hello.
We had a very serious trouble last week with our databases in Postgres and we
wanna know if maybe someone can help us to find the problem.
The trouble was that a day some databases in Postgres appear without any row
of information; some other, doesn't led us describe the tables (\d), o
Hello.
We had a very serious trouble last week with our databases in Postgres and we
wanna know if maybe someone can help us to find the problem.
The trouble was that a day some databases in Postgres appear without any row
of information; some other, doesn't led us describe the tables (\d),
anyone here know what's the hash
functions used in pgsql?
-- Rafael
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
77 matches
Mail list logo
