-- Forwarded message --
From: Timon
Date: 2010/10/8
Subject: Re: [GENERAL] stuck spinlock detected at dynahash.c
To: Tom Lane
I have this (thanks abrtd):
---
Crash ID: 26:a6235a787c4e9c6c5ab4f6eadd2168371b4e0fe3
Last crash: Wed 06 Oc
Yep it works!
thanks.
t=> show application_name;
application_name
--
(1 row)
t=> SELECT application_name,current_query from pg_stat_activity
where application_name='myapp';
application_name | current_query
--+---
(0 rows)
t=> set application_nam
On Thu, Oct 7, 2010 at 9:33 PM, Rajesh Kumar Mallah
wrote:
> Dear List,
>
> Is it possible to set application name param after the connection is made?
Have you tried setting it:
set application_name = 'newappname';
?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To mak
On Thu, Oct 7, 2010 at 8:36 PM, Ralph Smith wrote:
> Yes, I'm using 7.4,12, I can't help it.
> Is there a way to get the count of parameters to avoid overloading?
Considering you can overload like this:
functioname(arg1 int, arg2 int)
functioname(arg1 text, arg2 bigint)
and so on, parameter cou
Dear List,
Is it possible to set application name param after the connection is made?
In our applications the DB connection is made at a top level and is
shared between
many sub-applications. We want to override the application name in
various sub-applicatons
without reconnecting to the database.
On 8/10/2010 12:35 AM, Frank Zhao wrote:
We are supposed to migrate PointBase to PostgreSQL.
Do you have any advice on how we should approach this, and how to do
estimation on the workload?
The current PointBase is running on Hub and Spoke by using UniSync for
backup and restore purposes. Is th
On 7/10/2010 10:28 PM, Juan Sueiro wrote:
Tom,
Files are located under /var/lib/pgsql:
4 files with filename: "?"
Where? They can't be in /var/lib/pgsql if there are four of them, so
they must be in subdirectories, right? Which ones?
1 file with filename: "??"
1 file with filename: "?defa
Yes, I'm using 7.4,12, I can't help it.
Is there a way to get the count of parameters to avoid overloading?
Thanks!
--
?* Ralph Smith*
Data Architech
On 7/10/2010 7:28 PM, quickinfo quickinfo wrote:
Dear Friends,
I have installed windows 7 on my system. Previous I used postgreSQL 8.0
on XP. I tried install postgres 8.3 on windows 7. but it is not
installing properly.
http://wiki.postgresql.org/wiki/Troubleshooting_Installation
--
Craig Ring
Hi all,
I noticed that granting a user column-level update privileges doesn't
allow that user to issue LOCK TABLE with any mode other than Access
Share.
The documentation page for LOCK TABLE claims: "All other forms of LOCK
require at least one of UPDATE, DELETE, or TRUNCATE privileges.", and
I d
On 07/10/2010 22:18, Chris Saunders wrote:
The link
http://www.slony.info/downloads/2.0/source/slony1-2.0.5.docs.tar.bz2 gives
me a 404, NOT FOUND error.
Works OK for me.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgre
The link
http://www.slony.info/downloads/2.0/source/slony1-2.0.5.docs.tar.bz2 gives
me a 404, NOT FOUND error.
Regards
Chris Saunders
--
From: "Steve Singer"
Sent: Thursday, October 07, 2010 12:58 PM
To: "slony1-general" ;
;
Subject: [ANNOUNC
On Thu, Oct 7, 2010 at 1:46 PM, Allan Kamau wrote:
> My wild guess is that Ubuntu may be to blame. Try restarting PG and
> chances are that it would not solve the problem, meaning that it is
> most likely an OS issue. I had similar experiences on PostgreSQL
> server hosted on Ubuntu. After a coup
On Thu, Oct 7, 2010 at 9:11 PM, Scott Marlowe wrote:
> Hardware:
> 48 core AMD Magny Cours (4x12)
> 128G 1333MHz memory
> 34 15k6 drives, 2 hot spares, rest in RAID-1 pairs, 1 set for OS, 4
> for pg_xlog, rest for /data/base
> LSI RAID controller
> OS:
> Ubuntu 10.04
>
> uname -a
> Linux biga
Hardware:
48 core AMD Magny Cours (4x12)
128G 1333MHz memory
34 15k6 drives, 2 hot spares, rest in RAID-1 pairs, 1 set for OS, 4
for pg_xlog, rest for /data/base
LSI RAID controller
OS:
Ubuntu 10.04
uname -a
Linux bigassdbserver 2.6.32-24-generic #38-Ubuntu SMP Mon Jul 5
09:20:59 UTC 2010 x86
On 10/07/2010 12:59 AM, Andy wrote:
Ah thanks for the explanation. I was hoping for an automated setup without the
need to get paged 24/7.
So HA is still as hard as I thought it would be. I was hoping that with 9.0
things would be easier.
My 0.02.
Whether you need 3 servers (or 2 or 5 o
> -Original Message-
> From: AI Rumman [mailto:rumman...@gmail.com]
> Sent: Thursday, October 07, 2010 7:07 AM
> To: pgsql-general General
> Subject: 8.1 Table partition and getting error
>
> I am using POstgreql 8.1.
>
> I create table partition as follows:
> alter table crm rename t
Gauthier, Dave wrote:
What are the pros/cons of using Slony vs the nre streaming replication in v9?
There was a good discussion of this recently on the list; the three most
relevant comments were:
http://archives.postgresql.org/pgsql-general/2010-09/msg00605.php
http://archives.postgresql
What are the pros/cons of using Slony vs the nre streaming replication in v9?
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Singer
Sent: Thursday, October 07, 2010 12:58 PM
To: slony1-general; pgsql-general@postg
1. get an ascii dump of the source database.
2. check if for consistency if you're ambitious or suspicion by nature
(or you've been through this a number of times before and discovered
that this is _always_ necessary)
3. create the target database/schema
4. convert source data to target as per
The Slony team is pleased to announce the release of version 2.0.5 of
the Slony-1 replication system.
The release is available at
http://www.slony.info/downloads/2.0/source/slony1-2.0.5.tar.bz2
http://www.slony.info/downloads/2.0/source/slony1-2.0.5.docs.tar.bz2
2.0.5 fixes more than 24 issu
We are supposed to migrate PointBase to PostgreSQL.
Do you have any advice on how we should approach this, and how to do estimation
on the workload?
The current PointBase is running on Hub and Spoke by using UniSync for backup
and restore purposes. Is there any similar technology of UniSync in
> One option would be to create a simple 2-node cluster and run your PgSQL
> server in a migrateable VM backed by a SAN or, if your budget is more
> modest, a simple DRBD device.
>
> Personally, I like to use RHCS (Red Hat Cluster Services) with a DRBD
> array becking clustered LVM with Xen VM
Greg Smith writes:
> Yeah, you're right that is the proper way to handle this. As the
> problem isn't that serious once you're aware of it, I don't see a large
> amount of motivation to work on that now though, if that's what it will
> take to fix. And Tomas seemed satisfied with a workaround
Juan Sueiro writes:
> I'm not sure about the unix mode/owner, the server is:
> Red Hat Enterprise Linux AS release 4 (Nahant Update 5)
> Linux linuxbox 2.6.9-55.ELsmp #1 SMP Fri Apr 20 17:03:35 EDT 2007 i686 i686
> i386 GNU/Linux
> Currently there are no other server applications/software runnin
On Oct 7, 2010, at 5:34 AM, Devrim GÜNDÜZ wrote:
> On Thu, 2010-10-07 at 12:23 +0300, Peter Eisentraut wrote:
>> This is really something that psycopg2 should work out for you. I
>> suggest you take up a discussion on this on their mailing list.
>
> ...which is down over the last 3 weeks or so:
On 10-10-07 02:27 AM, Andy wrote:
> Is there any tutorials or detailed instructions on how to set up HA
> postgresql & failover? The documentation
> (http://www.postgresql.org/docs/9.0/interactive/warm-standby-failover.html)
> on this topics is pretty scarce.
>
> The scenario I'm most intereste
Tom Lane wrote:
It strikes me that if we were willing to throw code at the problem,
we could make it work like this:
...
This would properly throw error for cases where you'd passed the wrong
catalog's OID column to pg_relation_size.
Yeah, you're right that is the proper way to handle this. As
Merlin,
I'm not sure about the unix mode/owner, the server is:
Red Hat Enterprise Linux AS release 4 (Nahant Update 5)
Linux linuxbox 2.6.9-55.ELsmp #1 SMP Fri Apr 20 17:03:35 EDT 2007 i686 i686
i386 GNU/Linux
Currently there are no other server applications/software running there. I
thought that
On Thu, Oct 7, 2010 at 9:45 AM, Juan Sueiro wrote:
> Hello all,
> I'm experiencing a weird issue where my postgresql is creating strange files
> (all with the same size ~200MB) under /var/lib/pgsql. The filenames are like
> "?" and "?default". Anyone knows if it's safe to remove those? because the
Tom,
Files are located under /var/lib/pgsql:
4 files with filename: "?"
1 file with filename: "??"
1 file with filename: "?default"
1 file with filename: "HELP?"
1 file with filename: "TNMP?"
Regards,
On Thu, Oct 7, 2010 at 11:17 AM, Tom Lane wrote:
> Juan Sueiro writes:
> > I'm experiencing
I wrote:
> Greg Smith writes:
>> I've struggled with scripts using pg_relation_size doing strange things
>> because of this more than once. How about a) return NULL and b) log at
>> NOTICE that you just asked for something undefined?
> I don't care for the NOTICE at all; it's just useless log
Leonardo Francalanci writes:
>> I also recommend reindexing any table that has been VACUUM FULLed.
> Mmmh, from the docs I get that in 9.0 a "vacuum full" rewrites the whole
> table,
> so I expect the indexes to be re-created anyway... so a reindexing would
> be totally useless.
Any discussio
Juan Sueiro writes:
> I'm experiencing a weird issue where my postgresql is creating strange files
> (all with the same size ~200MB) under /var/lib/pgsql. The filenames are like
> "?" and "?default".
Please be a little more explicit about what the filenames are, and where
they are. I presume the
Scott Ribe wrote:
The what's new in 9.0 document on the wiki is great. Is there anything similar for 8.4
& 8.3 & so on?
I keep my list of links to interesting articles on the features in each
version here: http://wiki.postgresql.org/wiki/Version_History
Haven't updated that yet to inclu
Greg Smith writes:
> Tom Lane wrote:
>> We could prevent your query from failing if we did something like having
>> pg_relation_size() return NULL, rather than throwing an error, if the
>> OID it's given doesn't turn out to correspond to a live table. I'm not
>> sure if that'd be a net improvemen
On 7 October 2010 14:45, Juan Sueiro wrote:
> Any advices would be really appreciated.
You should upgrade to a version of Postgres that is currently
supported right away.
--
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
> I also recommend reindexing any table that has been VACUUM FULLed.
Mmmh, from the docs I get that in 9.0 a "vacuum full" rewrites the whole table,
so I expect the indexes to be re-created anyway... so a reindexing would
be totally useless.
Am I wrong?
--
Sent via pgsql-general mailing
>> > The scenario I'm most interested in is this:
>> >
>> > 2 servers - a master and a hot standby. All writes are
>> sent to master, reads are split between master and hot
>> standby.
>> >
>> > 1) If the hot standby goes down, how do I redirect
>> reads to the master?
>>
>> pgpool-II 3.0 will t
Hello all,
I'm experiencing a weird issue where my postgresql is creating strange files
(all with the same size ~200MB) under /var/lib/pgsql. The filenames are like
"?" and "?default". Anyone knows if it's safe to remove those? because they
are eating my disk space on the /var partition.
Version:
Timon writes:
> 2010/10/6 Alvaro Herrera :
>>> WARNING: pgstat wait timeout
>>> WARNING: pgstat wait timeout
>>> PANIC: stuck spinlock (0x7fd877761af8) detected at dynahash.c:981
>>> PANIC: stuck spinlock (0x7fd877761af8) detected at dynahash.c:981
>>
>> What platform is this? Are you runnin
Tom Lane wrote:
We could prevent your query from failing if we did something like having
pg_relation_size() return NULL, rather than throwing an error, if the
OID it's given doesn't turn out to correspond to a live table. I'm not
sure if that'd be a net improvement or not --- it certainly seems
In response to Szymon Guz :
> 2010/10/7 Devrim GÜNDÜZ
>
> > On Thu, 2010-10-07 at 17:38 +0600, AI Rumman wrote:
> > > MayVACUUM FULL on a table improve perfromance of the system?
> >
> > No, it will make things worse.
>
> That's not true, I'd rather say that it depends. The whole performance is
2010/10/7 Devrim GÜNDÜZ
> On Thu, 2010-10-07 at 17:38 +0600, AI Rumman wrote:
> > MayVACUUM FULL on a table improve perfromance of the system?
>
> No, it will make things worse.
>
That's not true, I'd rather say that it depends. The whole performance is
not just about the vacuum full.
regards
S
> > MayVACUUM FULL on a table improve perfromance of the system?
>
> No, it will make things worse.
???
Why?
"The FULL option is not recommended for routine use, but might be useful
in special cases. An example is when you have deleted or updated most
of the rows in a table and would like th
Alan Hodgson wrote:
The default setup allows "trust" access which means it trusts local system
accounts to login as the same roles in Pg without specifying a password.
There's two small inaccuracies with how you're describing this part.
First, having "trust" be the default is the case for
On Thu, 2010-10-07 at 17:38 +0600, AI Rumman wrote:
> MayVACUUM FULL on a table improve perfromance of the system?
No, it will make things worse.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~Postgre
On 7 October 2010 12:38, AI Rumman wrote:
> MayVACUUM FULL on a table improve perfromance of the system?
>
Please treat VACUUM FULL as a last resort. Read this:
http://wiki.postgresql.org/wiki/VACUUM_FULL
A VACUUM ANALYZE will mark dead tuples as free and update the stats.
Also check your query
MayVACUUM FULL on a table improve perfromance of the system?
Dear Friends,
I have installed windows 7 on my system. Previous I used postgreSQL 8.0 on
XP. I tried install postgres 8.3 on windows 7. but it is not installing
properly. After installtion am not able to find out pg_hba.conf files.
pgadmin III is opening fine and am able to create new database als
I am using POstgreql 8.1.
I create table partition as follows:
alter table crm rename to crm_bak;
CREATE TABLE crm
(
crmid integer NOT NULL,
description text,
deleted integer NOT NULL DEFAULT 0
)
WITHOUT OIDS;
ALTER TABLE crm OWNER TO vcrm;
create table crm_deleted ( check ( deleted = 1 )
Hi ,
The 'problem' was remedied to certain extent by increasing
max_standby_streaming_delay=30 # values in milliseconds
I set it to 5 mins which is acceptable to our application.
regds
Rajesh Kumar Mallah.
On Thu, Oct 7, 2010 at 9:55 AM, Rajesh Kumar Mallah
wrote:
> Dear List ,
>
> We have
On Thu, Oct 7, 2010 at 3:56 AM, Tom Lane wrote:
> Mike Christensen writes:
>> On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane wrote:
>>> If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16
>>> to that instead of carrying a separate file.
>
>> So now what you're saying is if it's no
On Thu, 2010-10-07 at 12:23 +0300, Peter Eisentraut wrote:
> This is really something that psycopg2 should work out for you. I
> suggest you take up a discussion on this on their mailing list.
...which is down over the last 3 weeks or so:
http://www.initd.org/
--
Devrim GÜNDÜZ
PostgreSQL Danış
On tis, 2010-10-05 at 09:33 +0200, Massa, Harald Armin wrote:
> Now I would love to have an additional check "is the used psycopg2
> linked to an advanced-enough libpq", to be able to set bytea_output to
> 'escape' if the libpq is not worthy.
This is really something that psycopg2 should work out
On ons, 2010-10-06 at 18:18 -0700, Mike Christensen wrote:
> ERROR: could not load library
> "/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so": libuuid.so.16:
> cannot open shared object file: No such file or directory
> SQL state: 58P01
apt-get install libossp-uuid16
--
Sent via pgsql-general
On Thu, Oct 7, 2010 at 9:43 AM, Dr. Peter Voigt wrote:
> Although I have not yet received any feedback from the BitRock
> support,
I closed the ticket with them - we know what the problem was in your
case, and we have enough info to try to put some additional checks in
the installer to prevent it
Although I have not yet received any feedback from the BitRock
support, I have meanwhile done some further tests. Most important
result is that the installer finished flawlessly after I changed the
"TEMP" and "TMP" variables back to the default
"%USERPROFILE%\AppData\Local\Temp".
I am interested t
This years European PostgreSQL Conference is due to be held on the 6 -
8th December 2010 in Stuttgart Germany (http://2010.pgday.eu/).
Following on from last years extremely successful event in Paris, we
hope to make the show bigger and better than before, with:
* A 4 star hotel venue (with spa fa
Ah thanks for the explanation. I was hoping for an automated setup without the
need to get paged 24/7.
So HA is still as hard as I thought it would be. I was hoping that with 9.0
things would be easier.
--- On Thu, 10/7/10, Scott Marlowe wrote:
> From: Scott Marlowe
> Subject: Re: [GENERA
On 10/07/10 12:53 AM, Andy wrote:
If pgpool is still necessary why not also use it for replication? What would be
the advantages of using the 9.0's built-in replication as opposed to pgpool's
replication?
pgpool's replication works quite differently than the built in. pgpool
replicates que
--- On Thu, 10/7/10, Tatsuo Ishii wrote:
> > The scenario I'm most interested in is this:
> >
> > 2 servers - a master and a hot standby. All writes are
> sent to master, reads are split between master and hot
> standby.
> >
> > 1) If the hot standby goes down, how do I redirect
> reads to the
> Is there any tutorials or detailed instructions on how to set up HA
> postgresql & failover? The documentation
> (http://www.postgresql.org/docs/9.0/interactive/warm-standby-failover.html)
> on this topics is pretty scarce.
>
> The scenario I'm most interested in is this:
>
> 2 servers - a m
On Wed, Oct 6, 2010 at 10:47 PM, Magnus Hagander wrote:
> On Thu, Oct 7, 2010 at 05:09, Mike Christensen wrote:
>> On Wed, Oct 6, 2010 at 7:56 PM, Tom Lane wrote:
>>> Mike Christensen writes:
On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane wrote:
> If you have a libossp-uuid.so.16, you might
On Thu, Oct 7, 2010 at 12:27 AM, Andy wrote:
> Is there any tutorials or detailed instructions on how to set up HA
> postgresql & failover? The documentation
> (http://www.postgresql.org/docs/9.0/interactive/warm-standby-failover.html)
> on this topics is pretty scarce.
>
> The scenario I'm mos
65 matches
Mail list logo
