Re: [ADMIN] [GENERAL] Error Starting Back END

2006-06-10 Thread Tom Lane
"Rojas, Fernando \(CIAT\)" <[EMAIL PROTECTED]> writes: > But when I locale - a the result is: > ... > en_US.utf8 > ... You probably need to spell it exactly like that, not "en_US.UTF-8". No, I don't have any idea why it worked before, if you're using the exact same OS release ... maybe you're miss

Re: [ADMIN] How are ppl monitoring PostgreSQL ... ? What is being

2006-06-10 Thread Joshua D. Drake
SELECT count(1) FROM pg_connections; would be a good one to graph ... Well you should use pg_stat_databases for that :) We have complete graphing and monitoring service coming out at the end of this month. Joshua D. Drake Marc G. Fournier Hub.Org Networking Services (htt

Re: [ADMIN] How are ppl monitoring PostgreSQL ... ? What is being

2006-06-10 Thread Marc G. Fournier
On Sat, 10 Jun 2006, Joshua D. Drake wrote: Marc G. Fournier wrote: The subject kinda says it all ... I know there are SNMP patches available out there now, but without those ... ? We use Nagios to call shell scripts that perform specific requests to a PostgreSQL server. Usually over SSH v

Re: [ADMIN] How are ppl monitoring PostgreSQL ... ? What is being

2006-06-10 Thread Joshua D. Drake
Marc G. Fournier wrote: The subject kinda says it all ... I know there are SNMP patches available out there now, but without those ... ? We use Nagios to call shell scripts that perform specific requests to a PostgreSQL server. Usually over SSH via psql, but you could use anything. Joshua

Re: [ADMIN] How are ppl monitoring PostgreSQL ... ? What is being

2006-06-10 Thread Christopher Browne
[EMAIL PROTECTED] (Michael Fuhr) wrote: > On Sat, Jun 10, 2006 at 07:29:52PM +0100, Andy Shellam wrote: >> I'm using a great little Linux program called "monit" to check that >> there's something listening on the 5432 port. It also monitors >> individual process memory and CPU usage etc. Quite go

Re: [ADMIN] How are ppl monitoring PostgreSQL ... ? What is being

2006-06-10 Thread Michael Fuhr
On Sat, Jun 10, 2006 at 07:29:52PM +0100, Andy Shellam wrote: > I'm using a great little Linux program called "monit" to check that > there's something listening on the 5432 port. It also monitors > individual process memory and CPU usage etc. Quite good. A server can be quite broken yet still r

Re: [ADMIN] Number formatting

2006-06-10 Thread Andy Shellam
Perfect Thanks Michael :-) Andy Michael Fuhr wrote: > On Sat, Jun 10, 2006 at 07:15:02PM +0100, Andy Shellam wrote: >> So, what I'm trying to do is use a primary key to generate invoice >> numbers such as "INV001", "INV002" etc. Obviously a sequence >> generates the increments, but when

Re: [ADMIN] pg_dumpall 8.1.4 large objects error

2006-06-10 Thread Jeff Frost
On Fri, 9 Jun 2006, Jeff Frost wrote: On Fri, 9 Jun 2006, Tom Lane wrote: pg_dumpall calls pg_dump, so only one place to fix. I've already committed the fix in CVS, if you'd prefer to use a tested patch. http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.c.diff?r1=1.422.

Re: [ADMIN] How are ppl monitoring PostgreSQL ... ? What is being

2006-06-10 Thread Andy Shellam
I'm using a great little Linux program called "monit" to check that there's something listening on the 5432 port. It also monitors individual process memory and CPU usage etc. Quite good. http://www.tildeslash.com/monit/ Andy Marc G. Fournier wrote: > > The subject kinda says it all ... I kno

Re: [ADMIN] Number formatting

2006-06-10 Thread Michael Fuhr
On Sat, Jun 10, 2006 at 07:15:02PM +0100, Andy Shellam wrote: > So, what I'm trying to do is use a primary key to generate invoice > numbers such as "INV001", "INV002" etc. Obviously a sequence > generates the increments, but when I try formatting it, it adds a space > at the beginning of

[ADMIN] How are ppl monitoring PostgreSQL ... ? What is being monitored ... ?

2006-06-10 Thread Marc G. Fournier
The subject kinda says it all ... I know there are SNMP patches available out there now, but without those ... ? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . [EMAIL PROTECTED] MSN . [EMAIL PROTECTED] Yahoo . yscrappy

Re: [ADMIN] problem with installing postgresql

2006-06-10 Thread Tom Lane
Praveen Kumar N <[EMAIL PROTECTED]> writes: > i have some problem with installing postgresql. What platform are you on exactly, and which version of postgres is this? Did you compile it yourself --- if so, with what compiler and configure options? If not, where did you get the executables f

[ADMIN] Number formatting

2006-06-10 Thread Andy Shellam
Hi, Simple question, which is probably something obvious I'm missing. If anyone can tell me better how to do what I'm doing, go for it! This is for a billing system, and I want PostgreSQL to generate unique reference numbers for each invoice that is something more meaningful than 1, 2, 3 etc. S

Re: [ADMIN] problem with installing postgresql

2006-06-10 Thread Christopher Browne
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Praveen Kumar N) transmitted: > hai... > i have some problem with installing postgresql. > Following is the output of installation: > -- > > [EMAIL