Well - I know that my stored proc is segfaulting based on a strace of
postgresql. Don't know how that affects trac which isn't using that
stored proc... the mystery continues. Either way I didn't get a
corefile, and ulimit -a show I have unlimited core file size :(
Alex
On Fri, Mar 7, 2008 at 1
Well - I think it might be that some of my servlets weren't closing
their database connections properly.
I do have some new evidence though:
I did an strace of the tomcat processes, and I noticed something that
might be odd, but I'm not really qualified to say. I notice that
every time a socket
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 7 Mar 2008 14:30:18 -0800 (PST)
Lewis Cunningham <[EMAIL PROTECTED]> wrote:
> I have no problem with having a policy or following a policy. My
> problem is: Where is it? When was the last time someone's blog was
> booted from planetpostgre
SUPER Eric! Very explanatory!
Thank you!
Ralph Smith
=
On Mar 6, 2008, at 10:17 AM, Erik Jones wrote:
On Mar 6, 2008, at 11:52 AM, Ralph Smith wrote:
Ralph Smith wrote:
> And should be easier to find in the manual!
>
> I've looked in many related chapters of the 8.2
Hi,
On Fri, 2008-03-07 at 14:26 -0800, Devrim GÜNDÜZ wrote:
> > Nope, but it does cover us if you get sick or something.
>
> I'm not talking about the technical issues -- I'm talking about the
> policy stuff.
BTW: When someone wants to land Planet PostgreSQL, I forward this
request to planet in
Hi,
On Fri, 2008-03-07 at 14:24 -0800, Josh Berkus wrote:
> > Well, technically all community sysadmins has full access to that
> box,
> > but it does not mean that they are administrating Planet PostgreSQL.
>
> Nope, but it does cover us if you get sick or something.
I'm not talking about the t
Devrim,
> Well, technically all community sysadmins has full access to that box,
> but it does not mean that they are administrating Planet PostgreSQL.
Nope, but it does cover us if you get sick or something.
> Exactly. Like your blog, Joshua's blog, Hubert's blog, etc. If a blog
> software does
Hi,
On Fri, 2008-03-07 at 14:16 -0800, Josh Berkus wrote:
> > > He's also not the sole admin of planetpostgresql.org.
> >
> > I am.
>
> Really? I thought Robert had rights. Well, it's obviously never been
> an issue before.
Well, technically all community sysadmins has full access to that box
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 7 Mar 2008 14:16:19 -0800
Josh Berkus <[EMAIL PROTECTED]> wrote:
> Devrim,
>
> > > He's also not the sole admin of planetpostgresql.org.
> >
> > I am.
>
> Really? I thought Robert had rights. Well, it's obviously never
> been an issue befo
Devrim,
> > He's also not the sole admin of planetpostgresql.org.
>
> I am.
Really? I thought Robert had rights. Well, it's obviously never been an
issue before.
Lewis, from the sound of it, you just need to put less text in your
"excerpt" portion of your posts. Is that correct, Devrim?
--
Hi,
On Fri, 2008-03-07 at 13:42 -0800, Lewis Cunningham wrote:
> Of course, this comes just days after Devrim and I had a disagreement
> about being restricted to using OSS tools or not for presenting at an
> OSS conference. Coincidence?
I don't care about the rest of your post that much, but
Hi,
On Fri, 2008-03-07 at 13:56 -0800, Josh Berkus wrote:
> He's also not the sole admin of planetpostgresql.org.
I am.
Regards,
--
Devrim GÜNDÜZ , RHCE
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 7 Mar 2008 13:56:30 -0800
Josh Berkus <[EMAIL PROTECTED]> wrote:
> Lewis,
>
> > PlanetPostgrSQL.org is listed on the postgresql.org home page and
> > should be controlled by more than a single individual. If this is a
> > project that is pol
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 7 Mar 2008 13:42:51 -0800 (PST)
Lewis Cunningham <[EMAIL PROTECTED]> wrote:
> Apparently Command Prompt and Devrim GÜNDÜZ own planetpostgresql.org
> and can arbitrarily decide to remove your blog from planetpostgresql.
Lewis, as I politely ex
Lewis,
> PlanetPostgrSQL.org is listed on the postgresql.org home page and
> should be controlled by more than a single individual. If this is a
> project that is policed and controlled solely by Devrim (as intimated
> by Joshua Drake, to me, in an email), then it should be removed from
> the hom
Apparently Command Prompt and Devrim GÜNDÜZ own planetpostgresql.org
and can arbitrarily decide to remove your blog from planetpostgresql.
I, and several others, received an email telling us that we we were
not meeting the (unpublished) requirements for blog display length.
Try telling blogger ho
I've created a pg_foundry project for this.
Assuming the project gets approved, I'll post the link here.
Regards,
cf
Malinka Rellikwodahs wrote:
> i'm interested in both the xml extractor and the conversion, could you
> reply with a link or some such it would be greatly appreciated ;)
>
> On
i'm interested in both the xml extractor and the conversion, could you reply
with a link or some such it would be greatly appreciated ;)
On Fri, Mar 7, 2008 at 2:44 PM, Colin Fox <[EMAIL PROTECTED]> wrote:
> Conor McTernan wrote:
> > I was wondering if anyone knows of any good ER Diagram tools fo
On Mar 7, 2008, at 8:49 AM, Tonton Dede wrote:
Hi,
I have downloaded the bin postgresql)8.3 for solaris x86. Where can
I find the pg_standby binary. Or do I really need to compile it myself
pg_standby is a pg client program, i.e a separate program. So, unless
the place from which you do
On Fri, 07 Mar 2008 11:44:38 -0800
Colin Fox <[EMAIL PROTECTED]> wrote:
> I've created an XSL stylesheet that works with graphviz to reverse
> engineer an ERD from a postgres database.
>
> If anyone's interested, I can make this available. It works quite well.
> It uses a postgres-to-xml extracto
On Fri, Mar 07, 2008 at 11:44:38AM -0800, Colin Fox wrote:
> Conor McTernan wrote:
> > I was wondering if anyone knows of any good ER Diagram tools for
> > Postgres that run on Linux.
> >
> > I have been using DBDesigner by FabForce for a couple of years, but
> > development has stopped while MySQL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sat, 8 Mar 2008 09:06:22 +1300
"Andrej Ricnik-Bay" <[EMAIL PROTECTED]> wrote:
> > PDO::ATTR_PERSISTENT => true
> >
> > Then... yeah :). You really shouldn't use a language layer for
> > persistent connections though. Use pgbouncer or pgpool.
>
On 07/03/2008, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> > A bit of poking around with ps and lsof showed me that a PHP
> > application I closed days ago (no browser open) was still active
> > tying up backend sessions; the problem went away when I
> > restarted my apache. Is this "normal
Conor McTernan wrote on 06.03.2008 04:33:
I have been using DBDesigner by FabForce for a couple of years, but
development has stopped
It seems that someone picked up the source. There is a new project on
sourceforge that seems to continue the work on DbDesigner:
https://sourceforge.net/proj
Conor McTernan wrote:
> I was wondering if anyone knows of any good ER Diagram tools for
> Postgres that run on Linux.
>
> I have been using DBDesigner by FabForce for a couple of years, but
> development has stopped while MySQL workbench is being built (for
> windows only). Neither of these applic
On Fri, Mar 7, 2008 at 11:17 AM, Alex Turner <[EMAIL PROTECTED]> wrote:
> I didn't. And after the reboot, I still see 8 new sockets stuck in
> CLOSE_WAIT - I'm wondering if this is a hardware/kernel problem...
Having sockets in CLOSE_WAIT is actually pretty normal
--
Sent via pgsql-general mai
On Mar 7, 2008, at 9:28 AM, Achmad Nizar Hidayanto wrote:
Thank you for the comment,
I just wonder, how come i have two identic rows. I have set the
primary key and set it as a unique. That's why i take
a look at ctid (in real, i don't use this id. I just tried to trace
why i have two ident
On Fri, Mar 07, 2008 at 03:28:12PM +0700, Achmad Nizar Hidayanto wrote:
> Having this case, can i conclude that postgre cannot guarantee the
> uniqueness of primary key? or is it just a bug of old
> version of postgre?
There were some older versions that had some bugs in this area. Whether
this a
I didn't. And after the reboot, I still see 8 new sockets stuck in
CLOSE_WAIT - I'm wondering if this is a hardware/kernel problem...
Alex
On Fri, Mar 7, 2008 at 11:50 AM, Alex Turner <[EMAIL PROTECTED]> wrote:
> Nothin worth mentioning in /var/log/messages
>
> The wierd thing I do see is there
Nothin worth mentioning in /var/log/messages
The wierd thing I do see is there are a number of sockets in
CLOSE_WAIT when doing a netstat -an | grep 5432
I think maybe I'll just reboot and see if that fixes it.
Alex
On Fri, Mar 7, 2008 at 11:47 AM, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Al
Alex Turner wrote:
It was core dumping on the 5th of March, but it hasn't since. It's
just failing with the connection closed problem. It seems to happen
worst with queries that are going to do updates and with connections
that are persistent between http requests...
I downgraded to 8.2, but i
It was core dumping on the 5th of March, but it hasn't since. It's
just failing with the connection closed problem. It seems to happen
worst with queries that are going to do updates and with connections
that are persistent between http requests...
I downgraded to 8.2, but it hasn't made any dif
That's crystal. Thanks for your advice!
Cheers
Anton
On 07/03/2008, Greg Smith <[EMAIL PROTECTED]> wrote:
> On Fri, 7 Mar 2008, Anton Melser wrote:
>
>
> > There is actually quite a bit of write (at least the dump is increasing
> > far more than what is being added manually by content writers...
On Fri, 7 Mar 2008, Anton Melser wrote:
There is actually quite a bit of write (at least the dump is increasing
far more than what is being added manually by content writers... and I'm
not even certain where it is coming from but that is another story!)
If you look at pg_stat_user_tables regu
Hi,
I have downloaded the bin postgresql)8.3 for solaris x86. Where can I
find the pg_standby binary. Or do I really need to compile it myself
Kind regards,
TD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.or
> I understand that subtraction of timestamps will return an interval,
> but I cannot tell if it is in seconds or minutes.
Neither. Because an interval can represent things like '1 year' or '1 month'
which cannot be represented as a simple number of seconds or minutes. So
what you want is:
times
> With 6GB of RAM, after that you could merrily increase shared_buffers to
> 20 or so and possibly increase performance. Just watch your
> checkpoints--they'll have more activity as you increase the buffer size,
> and from your description you've still got checkpoint_segments at the tiny
>
Thank you for the comment,
I just wonder, how come i have two identic rows. I have set the primary
key and set it as a unique. That's why i take
a look at ctid (in real, i don't use this id. I just tried to trace why
i have two identic rows. After examining the physical
id using ctid, i found
Wow! thanks for being super helpful, I will try it all out. Though I
distinctly remember turning off SElinux because it was giving me such a
headache even in permissive mode.
Thanks again for the tips.
Regards,
-A
On Thu, Mar 6, 2008 at 10:17 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> newbiegalor
On Fri, 7 Mar 2008, Anton Melser wrote:
We have a web app that is using a 32 bit 8.1.4 (I know but upgrading
is not an option for another couple of months...)
You do know that upgrading takes a second if you do it right? You might
want to avoid VACUUM FULL until you can upgrade to >=8.1.9.
[EMAIL PROTECTED] writes:
> Sorry, I was wrong. It's a charachter(12) not a varchar and it's a
> domain.
> The isins in z_ul either start with 'DE000' or with 'CH003'. PG seems
> to compare only the first few charachters because when I set the
> reference to CASCADE all z_ul entries that start with
Hi all,
We have a web app that is using a 32 bit 8.1.4 (I know but upgrading
is not an option for another couple of months...) running on Suse 10.
We just increased from 3GO to 6GO of RAM, and I increased the various
memory related values...
First info - the server ONLY does one pg db (that is its
Why are there too many to fix with ALTER?
>
I mean that there are too many to fix with manually typed ALTER statements,
pure laziness, so I am looking at an automated method.
> Use SQL and the data dictionary to generate the DDL and pipe it into psql
> (or spool it to disk and use that file as a
Alex Turner wrote:
I had stored procs in C on 8.2 for months, and I moved them over to
8.3 when we upgraded.
And re-compiled them, yes?
> The thing is that it's happening on a database
that doesn't have the stored procs. It seems to be happening worst on
a system that keeps connections open
44 matches
Mail list logo
