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
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
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
[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
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.
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
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
> 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
>
> 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
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
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
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...
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
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
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
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
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
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 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
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
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
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
-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 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
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 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
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
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
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
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
-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
-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
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
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
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?
--
-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
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
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: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
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
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
-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
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
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
44 matches
Mail list logo
