Tom, Peter,
I'm wondering if this could be an artifact of the WAL-replay bug fixed in
>> 9.1.6. I'd suggest updating and then reindexing the index ...
>>
>>
> We are running 9.1.2 it seems
>
>
We did a file system check and it all appeared green, at least as far as
OSX is concerned. We then upgra
Hi all,
A customer's database has started whining about a busted block:
postgresql-8.4-main.log:2012-10-02 18:51:33 EST ERROR: invalid page header in
block 8429809 of relation base/807305056/950827614
postgresql-8.4-main.log:2012-10-02 18:56:52 EST ERROR: invalid page header in
block 8429809
On Wed, Oct 3, 2012 at 10:09 AM, Jeff Janes wrote:
> On Tue, Oct 2, 2012 at 10:38 AM, Hugo wrote:
>>> That might be the problem. I think with 32 bits, you only 2GB of
>>> address space available to any given process, and you just allowed
>>> shared_buffers to grab all of it.
>>
>> The address s
On Tue, Oct 2, 2012 at 10:38 AM, Hugo wrote:
>> That might be the problem. I think with 32 bits, you only 2GB of
>> address space available to any given process, and you just allowed
>> shared_buffers to grab all of it.
>
> The address space for 32 bits is 4Gb.
I had thought the highest bit was
On Tue, Oct 02, 2012 at 10:19:18AM +0800, Craig Ringer wrote:
> Hi all
>
> While examining a reported issue with the JDBC driver I'm finding
> myself wanting SQL-level functions to get the scale and precision of
> a numeric result from an operation like:
>
> select NUMERIC(8,4) '1.'
> uni
> If I had a single table targ to insert into I would do an
>
> INSERT INTO targ SELECT thiscol, thatcol, theothercol FROM FOO.
>
> The problem is that I have tables targ1, targ2, targn to insert things
into and a
> nice stored procedure myproc which does the insertion into all 3 tables -
> pro
On Tue, Oct 02, 2012 at 10:38:38AM -0700, Hugo wrote:
> > That might be the problem. I think with 32 bits, you only 2GB of
> > address space available to any given process, and you just allowed
> > shared_buffers to grab all of it.
>
> The address space for 32 bits is 4Gb. We just tried to reach
my apologies - forgot to say I am on postgresql 8.4.9 on Fedora Linux x86_64
c
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Oct 01, 2012 at 11:02:39PM -, Greg Sabino Mullane wrote:
> > Has anyone come up with a good solution for distributing a .pgpass file
> > that doesn't expose it to anyone who has access to the distribution
> > mechanism?
>
> No, you cannot easily keep it in version control/puppet secu
Hi,
If I had a single table targ to insert into I would do an
INSERT INTO targ SELECT thiscol, thatcol, theothercol FROM FOO.
The problem is that I have tables targ1, targ2, targn to insert things into and
a nice stored procedure myproc which does the insertion into all 3 tables -
problem i
Thank you David,
unnest is the secret to this problem.
I appreciate your help.
-Choon Park
On Mon, Oct 1, 2012 at 6:56 PM, David Johnston wrote:
> *From:* pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] *On Behalf Of *ChoonSoo Park
> *Sent:* Monday, October 01
> Why 32 bits? Is that what your hardware is?
The business started in 2005 and we have been using 32 bits since then. We
have several machines, each with a remote replica databases (WAL shipping)
configured and changing this to 64 bits is going to be a lot of work, let
alone the down time of each
On Oct 2, 2012, at 12:01, Etienne Rouxel wrote:
> Hi
> I have the same "problem" as Tanmay Patel.
>
> SELECT * FROM version();
> returns :
> "PostgreSQL 8.4.12 on i386-apple-darwin, compiled by GCC
> i686-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc. build 5370),
> 32-bit"
>
> Here
Hi
I have the same "problem" as Tanmay Patel.
SELECT * FROM version();
returns :
"PostgreSQL 8.4.12 on i386-apple-darwin, compiled by GCC
i686-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc. build 5370),
32-bit"
Here is my simplified code :
CREATE TABLE public.mytable (
refno int NOT
Hello,
On PG 9.0.8, we just observed a long-running query executing on a replica (~1
hour), which was effectively blocking replication. I say effectively, as checks
on streaming replication appeared as if everything was up-to-date (using SELECT
pg_current_xlog_location() on the primary and SELE
On Thu, Sep 27, 2012 at 7:49 PM, Maxim Boguk wrote:
> Hi,
>
> One of my project extensively uses ip4r addon (
> http://pgfoundry.org/projects/ip4r/ ).
>
> However, after migration of test environment to 9.2 that addon doesn't
> install anymore without manual fixes.
> Trouble very simple:
> addon u
On 2 October 2012 15:02, Arvind Singh wrote:
> we are all aware of the popular trend of MMO games. where players face each
> other live.
> My questions are focussed on reducing load on Game database or Sql queries
>
> a) How to control the surge of records into the GameProgress table. so that
> pl
On 10/02/2012 10:02 PM, Arvind Singh wrote:
we are all aware of the popular trend of MMO games. where players face
each other live.
My questions are focussed on reducing load on Game database or Sql queries
In most cases the answer is the same as for any other bursty
application: Cache aggress
we are all aware of the popular trend of MMO games. where players face each
other live.
My questions are focussed on reducing load on Game database or Sql queries
a) How to control the surge of records into the GameProgress table. so that
players get response quicker. The Server starts to lag
Mr Dash Four writes:
>> if you broke the permissions on the pg_catalog so badly that the SQL
>> planner can't look up the data types of the fields of your own tables,
>> well, thats just wrong.
> What's the alternative?
Perhaps more careful thought about your threat model?
> I am not willing
cool, thanks
On Tue, Oct 2, 2012 at 3:13 PM, Cédric Villemain wrote:
> **
>
> Le mardi 2 octobre 2012 15:01:08, Willy-Bas Loos a écrit :
>
> > Hi,
>
> > (postgres 9.1)
>
> > I was doing something like this in a plpgsql function, but i got a Syntax
>
> > Error.
>
> >
>
> > t_var:=(insert into tabl
On Mon, Oct 1, 2012 at 3:58 PM, Moshe Jacobson wrote:
> On Mon, Oct 1, 2012 at 12:22 PM, Merlin Moncure wrote:
>>
>> >> *) Functions without exception blocks are faster than those with.
>> >> *) Therefore, CREATE/IF NOT EXISTS is probably faster (test to be sure)
>> >
>> > I don't think that can
Le mardi 2 octobre 2012 15:01:08, Willy-Bas Loos a écrit :
> Hi,
> (postgres 9.1)
> I was doing something like this in a plpgsql function, but i got a Syntax
> Error.
>
> t_var:=(insert into table1(field2) values ('x') returning field1);
>
> Is there no support for using RETURNING in insert, upda
Tirsdag 2. oktober 2012 15.01.08 skrev Willy-Bas Loos :
> Hi,
> (postgres 9.1)
> I was doing something like this in a plpgsql function, but i got a Syntax
> Error.
>
> t_var:=(insert into table1(field2) values ('x') returning field1);
>
> Is there no support for using RETURNING in insert, update
Hi,
(postgres 9.1)
I was doing something like this in a plpgsql function, but i got a Syntax
Error.
t_var:=(insert into table1(field2) values ('x') returning field1);
Is there no support for using RETURNING in insert, update, delete queries
to fill a variable in plpgsql?
Here's some code. Retur
'user: ' *is* text by default.I didn't notice you displaying
your table definitions, but assuming u_name is TExT or VARCHAR(...)
it should have worked without any explicit casts
u_name is a custom-defined type, consisting of user name (text/varchar),
a number (longint), host name (text
On 2012-10-01, Shaun Thomas wrote:
> On 10/01/2012 12:19 PM, Darren Duncan wrote:
>
>> You should never put your passwords (or private keys) in source control;
>> it would be better to use the puppet/bcfg option.
>
> That was kind of my point. Puppet / Bcfg2 have the same problem. About a
> dozen
On Tue, Oct 2, 2012 at 11:29 AM, Phoenix Kiula wrote:
> On Tue, Oct 2, 2012 at 12:59 AM, Phoenix Kiula
> wrote:
>>> Could you please check permission of /var/run/pgbouncer/ directory. If
>>> pgbouncer directory does not have "postgres" user permissions,please assign
>>> it and then start the pgb
Boriss Redkins, 02.10.2012 10:42:
I've got postgreSQL 8.4 and 91. installed on my Windows 7 machine. 9.1 version
starts just fine. But when trying to start 8.4 with:
Services
Microsoft Corporation
Version: 6.1.7600.16385
it does not start and no logs are produced.
When starting in console:
C
Hello,
I encountered a problem when trying to start postqreSQL 8.4.
I've got postgreSQL 8.4 and 91. installed on my Windows 7 machine. 9.1 version
starts just fine. But when trying to start 8.4 with:
Services
Microsoft Corporation
Version: 6.1.7600.16385
it does not start and no logs are produ
30 matches
Mail list logo