Re: [ADMIN] separating PG binaries into a ro mounted partition

2007-12-30 Thread Albretch Mueller
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

Re: [ADMIN] Apache Logging to PostgreSQL

2007-12-30 Thread H. Hall
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

Re: [ADMIN] separating PG binaries into a ro mounted partition

2007-12-30 Thread Usama Dar
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

Re: [ADMIN] Apache Logging to PostgreSQL

2007-12-30 Thread Matthew T. O'Connor
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

Re: [ADMIN] Apache Logging to PostgreSQL

2007-12-30 Thread H. Hall
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

Re: [ADMIN] Apache Logging to PostgreSQL

2007-12-30 Thread Søren Laursen
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 logtime ago

Re: [ADMIN] Restoring pg_dump Backup with psql Fails

2007-12-30 Thread Phillip Smith
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

Re: [ADMIN] Restoring pg_dump Backup with psql Fails

2007-12-30 Thread Tom Lane
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 (functions

Re: [ADMIN] Restoring pg_dump Backup with psql Fails

2007-12-30 Thread Phillip Smith
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 as

Re: [ADMIN] What's the XID?

2007-12-30 Thread ivan.hou
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 these clients have

Re: [ADMIN] What's the XID?

2007-12-30 Thread Joshua D. Drake
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?