scheu_postgresql wrote:
> In my Postgresql 8.4.0 server, since this morning some tables are
unavailable, see example below :
>
> --> pg_dump MY_DB > bkp_MY_DB.dmp
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR: invalid memory alloc
request size 18446744073709551613
> pg
Le mercredi 29 février 2012 à 11:31 -0500, Gary Chambers a écrit :
> > Note that Ubuntu also comes in a GUI free server edition as well. I can
> > definitely state that Ubuntu 10.04 LTS Server edition is rock solid stable
>
> +1
>
> I've been running 10.04 LTS Server for over three years (on a D
On 28/02/2012 18:17, Rich Shepard wrote:
> On Tue, 28 Feb 2012, mgo...@isstrucksoftware.net wrote:
>
>> If we move to Linux, what is the preferred Linux for running Postgres
>> on. This machine would be dedicated to the database only.
>
> Michael,
>
> There is no 'preferred' linux distribution
On 28/02/2012 17:57, mgo...@isstrucksoftware.net wrote:
> Our application runs on Windows, however we have been told that we can
> pick any OS to run our server on. I'm thinking Linux because from
> everything I've read, it appears to be a better on performance and there
> are other features like
Hi!
I'm getting ready to build a reporting server, one where long-running queries
and backups will be taken from. This new server will be a slave from the master
where all changes are done. Some reports are better expressed with extracting a
subset of the data and leaving it in a table to be
Hello,
I've a table with 1 primary key and 1 unique index.
I would like to handle differently the duplicate key violations
depending on which constraints are affected.
(Within a plpgsql CATCH block, using SQLERRM).
It seems, that when both constraints would be violated, the exception is
always a
On Wednesday 29 February 2012 14:14:19 Tom Lane wrote:
> "David Johnston" writes:
> > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Vincent de Phily
> >
> >> [ this doesn't do anything: ]
> >> db_foo=# REVOKE CREATE ON SCHEMA public FROM foouser;
> >
> > "foouser" is obtaining its per
I have a behaviour of Postgres which I do not understand (and thus can
not fix...). When inserting into a log-like table, I get the error
message "compressed data is corrupt" for certain (rare) combination of
values. When I re-create the same table structure from scratch and
insert the same data in
On Thu, 2012-03-01 at 08:24 -0500, François Beausoleil wrote:
> Hi!
>
> I'm getting ready to build a reporting server, one where long-running queries
> and backups will be taken from. This new server will be a slave from the
> master where all changes are done. Some reports are better expresse
On Thu, Mar 1, 2012 at 5:25 AM, Ivan Voras wrote:
>
> One interesting thing I've discovered recently is that there is a HUGE
> difference in performance between CentOS 6.0 and Ubuntu Server 10.04
> (LTS) in at least the memory allocator and possibly also multithreading
> libraries (in favour of Ce
Hi List,
we are currently running a rather large postgresql-installation with
approximately 4k Transactions and 50k index scans per second.
In the last days on some times of the day (irregular - 3-4 times a day), some
of the postmaster processes are running with 100% cpu usage. That leads to a
On 01/03/12 16:41, Paul Dunkler wrote:
Hi List,
we are currently running a rather large postgresql-installation with
approximately 4k Transactions and 50k index scans per second.
In the last days on some times of the day (irregular - 3-4 times a day), some
of the postmaster processes are runn
;pg_hba.conf"
(restarting postmaster) without success:
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all ident
# IPv4 local connections:
#20120301 rbz [1291-1292]
#h
After doing some more work with Process Monitor I found the leaks to be
stemming from a driver associated with a License Manager from SafeNet Inc.
which runs on the machine.
Adam Bruss
Senior Development Engineer
AWR Corporation
11520 N. Port Washington Rd., Suite 201
Mequon, WI 53092 USA
P:
On 03/01/12 9:02 AM, Ruben Blanco wrote:
I cannot connect to my Postgres database from my PHP scripts. I get the error:
PHP Warning: pg_connect(): Unable to connect to PostgreSQL server:
FATAL: Ident authentication failed for user "postgres" in ...
I have tried many combinations for "hos
Thank for the good input.
I found my problem. I compiled initially *with* the --disable-rpath
option. When I realised my mistake, I did a make uninstall,
reconfigured, rebuilt, and reinstalled. My post was made when I had
done this and thought I had the settings as stated. However, the
uninstall d
Hi John. Thanks a lot for your reply:
El día 1 de marzo de 2012 17:25, John R Pierce escribió:
> On 03/01/12 9:02 AM, Ruben Blanco wrote:
> specify host=localhost, otherwise its using the first 'local' line, which
> specifies 'ident' authentication, as the error implies.
Where should I specify
On 03/01/12 10:03 AM, Ruben Blanco wrote:
El día 1 de marzo de 2012 17:25, John R Pierce escribió:
> On 03/01/12 9:02 AM, Ruben Blanco wrote:
> specify host=localhost, otherwise its using the first 'local' line, which
> specifies 'ident' authentication, as the error implies.
Where should I
I did that now - and analyzed the situation a bit. There are only queries running which will process very fast under high load (only index scans, very low rates of sequential scans). I found a remarkable number of Insert statements...And sometimes when that happens, the CPU Utilization is going up
On 01/03/12 19:41, Paul Dunkler wrote:
I did that now - and analyzed the situation a bit. There are only queries
running which will process very fast under high load (only index scans, very low
rates of sequential scans). I found a remarkable number of Insert statements...
And sometimes when tha
Hi,You're running on a box larger than I'm used to, so this is only speculation. I'm wondering whether you're hitting problems with lock contention or some such. It looks like you've got 48 cores there all at about 100% possibly none of them getting much chance to do any work.Yes. That is what i se
On Thu, Mar 1, 2012 at 1:52 PM, Paul Dunkler wrote:
>
> Hi,
>
> You're running on a box larger than I'm used to, so this is only speculation.
> I'm wondering whether you're hitting problems with lock contention or some
> such. It looks like you've got 48 cores there all at about 100% possibly no
"Marc Mamin" writes:
> I've a table with 1 primary key and 1 unique index.
> I would like to handle differently the duplicate key violations
> depending on which constraints are affected.
> (Within a plpgsql CATCH block, using SQLERRM).
> It seems, that when both constraints would be violated, t
Matthias Leisi writes:
> I have a behaviour of Postgres which I do not understand (and thus can
> not fix...). When inserting into a log-like table, I get the error
> message "compressed data is corrupt" for certain (rare) combination of
> values. When I re-create the same table structure from scr
I've got a 3 node cluster (1 master/2 slaves) running 9.0.x with
streaming replication. I'm in the planning stages of upgrading to
9.1.x, and am looking into the most efficient way to do the upgrade
with the goal of minimizing downtime & risk. After googling, the only
discussion that I've found o
Hi,
I am trying pgpool2 to split read and write queries, where reads
should go to the slave server (streaming replication) and writes to
the master server.
Anybody has a config file that works for pgpool2?
Best,
--
Benjamin Henrion
FFII Brussels - +32-484-566109 - +32-2-3500762
"In July 2005,
On Thu, Mar 1, 2012 at 5:06 PM, Benjamin Henrion wrote:
> Hi,
>
> I am trying pgpool2 to split read and write queries, where reads
> should go to the slave server (streaming replication) and writes to
> the master server.
>
> Anybody has a config file that works for pgpool2?
>
> Best,
>
> --
> Be
27 matches
Mail list logo
