ivan.hou wrote:
the read xacts.
Why aren't you using the pgstats xact counters for that?
regards, tom lane
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.or
Tom Lane-2 wrote:
>
> Jeff Frost <[EMAIL PROTECTED]> writes:
>> On Thu, 27 Dec 2007, Tom Lane wrote:
>>> There's no global counter. There's a backend-local "virtual transaction
>>> id" counter.
>
>> That's a drag as I have quite a few clients who graph the xacts/sec with
>> MRTG.
>> Most of t
> Yeah, but what other user-created stuff (functions for instance) might
> be in there?
> You might want to drop template1 and recreate it from template0.
> (There's a blow-by-blow article about doing that on techdocs, IIRC.)
I think I'll do that :)
Thanks Tom & Joshua - you've been most helpful a
"Phillip Smith" <[EMAIL PROTECTED]> writes:
> I think I've found my problem:
> I don't know how or when those tables were created in template1 - they're
> certainly not supposed to be there or needed. Is it safe to just DROP the
> tables from template1?
Yeah, but what other user-created stuff (fun
> You have several problems in this dump. One it appears that some of the
> releations already exist. Did you by chance accidently create stuff
> within template1 at some point?
I think I've found my problem:
[EMAIL PROTECTED] backups]$ psql template1
Welcome to psql 8.2.4, the PostgreSQL interact
Hi,
I got pglogd running on postgresql 8.1.4 a debian sarge installation. I had
to compile it myself and my apache2 configuration look like this.
LogFormat "%t %D %>s %b %m %v %h \"%U\" \"%{Referer}i\" \"%{User-agent}i\"
\"%r\" %l %u" pglogd
CustomLog "/var/log/apache2/pglogd_fifo" pglogd
For a
Matthew T. O'Connor wrote:
Hello, I've been looking into having apache log to postgresql, and
it isn't clear to me what the best way to set this up is. The
options that I see so far are:
1) Apache Pipe Logging: This seems simple enough, but I'm not sure
what tool I would as the logging pr
Hello, I've been looking into having apache log to postgresql, and it
isn't clear to me what the best way to set this up is. The options
that I see so far are:
1) Apache Pipe Logging: This seems simple enough, but I'm not sure
what tool I would as the logging process?
2) pgLOGd: This isn
>
>
> So, what are the installation options to acheive what I specified in the
> OP?
>
Did you go through this?
http://www.postgresql.org/docs/8.2/static/install-procedure.html
--
Usama Munir Dar http://www.linkedin.com/in/usamadar
Consultant Architect
Cell:+92 321 5020666
Skype: usamadar
Matthew T. O'Connor wrote:
Hello, I've been looking into having apache log to postgresql, and it
isn't clear to me what the best way to set this up is. The options
that I see so far are:
1) Apache Pipe Logging: This seems simple enough, but I'm not sure
what tool I would as the logging proc
> Phillip Smith <[EMAIL PROTECTED]> wrote:
> What are you trying to acheive by making the binaries read-only?
~
* convinience: If I have PG on a baseline Linux distro running from a
USB stick or CD (or a mini-DVD) and I go around with my micro drive, I
could just sit anywhere they have a PC with a
11 matches
Mail list logo
