process 6742.
2008-03-04 05:45:20 EST [6742]: [9-1] STATEMENT: VACUUM FULL
pg_catalog.pg_type
Sorry, been juggling too many things this morning!
On Wed, Mar 5, 2008 at 10:45 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Gavin M. Roy" <[EMAIL PROTECTED]> writes:
> > The
On Wed, Mar 5, 2008 at 10:31 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Gavin M. Roy" <[EMAIL PROTECTED]> writes:
> > 2008-03-04 05:45:47 EST [6698]: [1-1] LOG: process 6698 still waiting
> for
> > AccessShareLock on relation 1247 of database 16385 after
On Wed, Mar 5, 2008 at 10:31 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Gavin M. Roy" <[EMAIL PROTECTED]> writes:
> > 2008-03-04 05:45:47 EST [6698]: [1-1] LOG: process 6698 still waiting
> for
> > AccessShareLock on relation 1247 of database 16385 after
On Wed, Mar 5, 2008 at 10:13 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> I wrote:
> > In particular, if that's the problem, why has this not been seen before?
> > The fact that it's going through heap_page_prune doesn't seem very
> > relevant --- VACUUM FULL has certainly always had to invoke
> > Ca
]: [19-1] LOG: terminating any other active
server processes
2008-03-04 05:47:55 EST [6741]: [12-1] WARNING: terminating connection
because of crash of another server process
On Tue, Mar 4, 2008 at 9:56 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Gavin M. Roy" <[EMAIL PROTEC
0x005760c0 in ServerLoop ()
#19 0x0050 in PostmasterMain ()
#20 0x0052fd3e in main ()
On Tue, Mar 4, 2008 at 11:35 AM, Alvaro Herrera <[EMAIL PROTECTED]>
wrote:
> Gavin M. Roy wrote:
> > This morning I had a postgres 8.3 install core this morning while
> multiple
This morning I had a postgres 8.3 install core this morning while multiple
vacuum fulls were taking place. I saved the core file, would anyone be
interested in dissecting it? I've otherwise had no issues with this machine
or pgsql install.
Gavin
On 11/24/07, Gregory Stark <[EMAIL PROTECTED]> wrote:
>
> This is a conflict which will affect Postgres in the future as well.
> Generally
> I/O costs win over cpu costs in databases since only relatively small
> systems
> are cpu-bound. Large systems are typically I/O-bound.
>
That really depends
e clean up after themselves data usage wise after their
scheduled time?
Should people only be able to run PostgreSQL in the context of their
own user? Do we have experience with such setups in the past? What
has worked well and what hasn't?
Gavin
On 7/25/07, Gavin M. Roy <[EMAIL
Let us know when/if and we'll pay command prompt to install the base OS on
the system. All that we're waiting on at this point is the final on the OS.
Gavin
On 7/31/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>
> Josh Berkus <[EMAIL PROTECTED]> writes:
> > Hey, this is looking like a serious case of
It's actually in Texas, and we have no intention to put a time limit
on its availability. I think the availability will be there as long as
there is use and we're in the Texas data center, which I don't see
ending any time soon.
On 7/31/07, Josh Berkus <[EMAIL PROTECTED]> wrote:
> Gavin,
>
> I'm a
Let me look at what makes sense there, I am open to it.
On 7/26/07, Tom Lane <[EMAIL PROTECTED]> wrote:
Greg Smith <[EMAIL PROTECTED]> writes:
> But this is pushing forward PostgreSQL development you're doing here. If
> you've got a problem such that something works differently based on the
> o
If RH can sponsor a license of RHEL I'm inclined to go there. Not
that it was offered, but I think Dave's suggestion was Tom could field
that for the box if inclined. If I'm wrong, let me know. If that
can't happen, would people prefer CentOS or Ubuntu Server? The people
I'm most concerned wit
One thing to take into account is I dont have physical access to the
box (It is in TX, I am in PA). All installs but Gentoo will be
performed by a well trained NOC monkey. *cough*
On 7/25/07, Dave Page <[EMAIL PROTECTED]> wrote:
> --- Original Message ---
> From: Tom Lane <[EMAIL PROT
Ubuntu server? Slackware? Not a fan of Centos, RHEL or Fedora...
What about on the BSD side of things?
On 7/25/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Gavin M. Roy" <[EMAIL PROTECTED]> writes:
> If you're interested in using the box, name what you want insta
Note it's a 28 disk system, and I can allocate more if needed, but I
was going to use one MSA for internal use.
On 7/25/07, Mark Wong <[EMAIL PROTECTED]> wrote:
On 7/25/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Gavin M. Roy" <[EMAIL PROTECTED]> writes:
If you're interested in using the box, name what you want installed.
On 7/25/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Gavin M. Roy" <[EMAIL PROTECTED]> writes:
> I'm currently in the process of having Gentoo linux reinstalled on the
> box since that is wh
to see the community get direct benefit from it as
opposed to it being a play sandbox for people who want to tinker.
Please let me know thoughts, concerns or suggestions.
Gavin M. Roy
CTO
myYearbook.com
[EMAIL PROTECTED]
/proc/cpuinfo:
processor : 0
vendor_id : AuthenticAMD
cpu family
Recently I ran into an issue where restoring from pg_dump from one machine
to another with non-matching tablespaces. The primary issue is that index
creation will fail if the tablespace does not exist from the dump. I was
thinking to best solution for this would be a pg_dump option such as
--ign
been around the
project
for a few years will agree.
So, welcome Dave Page as the newest member of Core!
--
--Josh Berkus
Josh Berkus
PostgreSQL Project Core Team
www.postgresql.org
---(end of
broadcast)---
TIP 2: Don't 'kill -9' the
---(end of
broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Gavin M. Roy
800 Pound Gorilla
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Have you searched our lis
Joshua D. Drake wrote:
PgFoundry is coming along in its own right. I see three main problems
with it at current:
1. It looks like a separate project from PostgreSQL (website, name,
etc...)
I've been working on porting the site to use a derived theme from the
main PostgreSQL site. My main issue
PDO just went into beta, and can be downloaded from
http://pecl.php.net/package/pdo to be compiled into previous versions of
PHP. We really should get some PHP and PgSQL people onto making sure
the PgSQL driver is top notch (if it isn't already).
Gavin
On Mon, 2005-02-07 at 20:21 -0800, Joshua
, but if we're really interested, maybe we could hack up the
code to talk to a central pgsql database allowing multiple trackers on a
dns rr.
Gavin
Marc G. Fournier wrote:
On Wed, 24 Nov 2004, Joshua D. Drake wrote:
Marc G. Fournier wrote:
On Wed, 24 Nov 2004, Gavin M. Roy wrote:
No you can not
No you can not, but the tracker isn't very resource intesive from my
past experience. I can host it if needed.
Gavin
Marc G. Fournier wrote:
On Wed, 24 Nov 2004, Thomas Hallgren wrote:
Gaetano Mendola wrote:
...so the very first client is the real server
that must be run 24/24.
I don't think thi
It's all peer to peer client type stuff with the exception of the
tracker server.
Gavin
Marc G. Fournier wrote:
On Mon, 22 Nov 2004, Thomas Hallgren wrote:
Marc G. Fournier wrote:
What about the Java version that Gavin had mentioned? Aegus or
something like that?
http://azureus.sourceforge.net
The problem is it requires a box with X on it. (ie it's not console
Java, it's gui java) I don't have a server to run it on right now, but
will be readdressing server allocations shortly and may be able to set
something up with x/vnc and would be happy to use that as a primary bt
seeding site
Let me be one of the first to say thank you to all of you guys for yet
another awesome version of PgSQL, beta or not. My company and I
appreciate all the hard work and such that has gone into making this
version happen. Keep up the good work and let me know where I can help.
Sincerely,
Gavin
Yeah, I was talking about it on freenode yesterday. If the stats
collector doesn't start, the internal variable is set to off.
Gavin
Gaetano Mendola wrote:
Gavin M. Roy wrote:
I have no problem resolving localhost anywhere else on the box, do
you have any suggestions on finding out if i
I have no problem resolving localhost anywhere else on the box, do you
have any suggestions on finding out if it's a misconfiguration?
Gavin
Tom Lane wrote:
"Gavin M. Roy" <[EMAIL PROTECTED]> writes:
I've been having a problem with the pgstat.c localhost change sinc
I've been having a problem with the pgstat.c localhost change since 7.4,
in that statistics gathering stopped working on my gentoo boxes. I've
not traced it back beyond getaddrinfo called in getaddrinfo_all, and
decided the quick fix was to go back and change pgstat to use 127.0.0.1
instead of
I dont see a real need for slots, but I do question why the 7.4 branch
isnt marked as stable yet. :)
Gavin
Jyry Kuukkanen wrote:
Hello
Are there any Gentoo users here?
Yes, there are some :)
Do you wish the PostgreSQL ebuild made use of SLOTS?
- to allow installing of major version
32 matches
Mail list logo
