Re: [ADMIN] Opterons running on Postgres 7.3.6

2004-10-15 Thread Tomaž Borštnar
John Allgood wrote: After reading the thread about the Xeons and the context switching issue I have decided to go with the Opteron. Has anyone got any thoughts or input on running the system on PostgreSQL 7.3.6 and RHES 3.0. I realize 7.4 is probably better for the Opteron but right now that

[ADMIN] Compile Time Options

2004-10-15 Thread McCarthy, John
Reviewing data type docs, I found this note:  “When timestamps are stored as eight-byte integers (a compile-time option), microsecond precision is available over the full range of values.”  However, when I review the “ .configure “ options, I am unable to find the setting that controls this

Re: [ADMIN] Compile Time Options

2004-10-15 Thread Bruno Wolff III
On Fri, Oct 15, 2004 at 11:06:12 -0400, "McCarthy, John" <[EMAIL PROTECTED]> wrote: > Reviewing data type docs, I found this note: "When timestamps are > stored as eight-byte integers (a compile-time option), microsecond > precision is available over the full range of values." However, when I >

[ADMIN] How to store jpeg files in Postgres Database

2004-10-15 Thread macdickson
Can any one tell me how to store jpegh files in Postgres Database bye Macdickson -- Using Opera's revolutionary e-mail client: http://www.opera.com/m2/ ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your

Re: [ADMIN] How to store jpeg files in Postgres Database

2004-10-15 Thread Peter Eisentraut
Am Freitag, 15. Oktober 2004 08:37 schrieb macdickson: > Can any one tell me how to store jpegh files in Postgres Database Use the data type "bytea". -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: you

[ADMIN] perl Pg installation?

2004-10-15 Thread Geoffrey
I'm not sure I've got the right list, but pointers to a better one are certainly accepted. I'm trying to install Perl Pg module, but when 'make test' runs, Pg::conndefaults() is returning an empty dbname. I'm not sure where to go from here. Any suggestions would be greatly appreciated. -- Un

Re: [ADMIN] postgresql port change

2004-10-15 Thread Weiping
Edgars wrote: Hello, an someone tell me where in freeradius config/source files i can change subj.? http://www.postgresql.org/docs/7.4/static/runtime-config.html#RUNTIME-CONFIG-CONNECTION see 'port' setting. ---(end of broadcast)--- TIP 9: the plann