Re: [GENERAL] postgres 7.3.3 on redhat 7.2

2003-10-20 Thread Joshua D. Drake
Hello, Also you should really upgrade to 7.3.4. Sincerely, Joshua Drake Martin Marques wrote: El Lun 20 Oct 2003 10:19, Daniel E. Fisher escribió: I can't get a rest for a min guys. I go away for the weekend and my server is getting this error. Fatal error: Call to undefined function:

Re: [GENERAL] Help or Bug?

2003-10-20 Thread Richard Huxton
On Monday 20 October 2003 16:19, Cláudia Morgado wrote: Tom Lane, This problem was solved with the suggested permission. GRANT USAGE ON SCHEMA wlog_data TO wlog_uni; There is the possibility of us to consult the permission above in the database? SELECT * FROM pg_namespace ; For tables,

Re: [GENERAL] create triggers.

2003-10-20 Thread Oliver Elphick
On Sun, 2003-10-19 at 22:51, Ling Xiaoyu wrote: Hello there. Can anybody help me with Postgresql triggers? what I need is a trigger which update value of field tables_rows.total_rows to rows count of table zzz if I insert new row in table zzz... CREATE TABLE zzz ( ... ... );

Re: [GENERAL] restart and postgres.conf

2003-10-20 Thread CSN
--- CSN wrote: Feature request - add reload to /etc/init.d/postgres # /etc/init.d/postgresql Uso: /etc/init.d/postgresql {start|stop|status|restart|condrestart|reload|force-reload} You should tell us what OS you are using. Redhat 9. I just looked in

Re: [GENERAL] VACUUM degrades performance significantly. Database

2003-10-20 Thread Gaetano Mendola
Stephen wrote: Nope, I installed the RedHat 9 myself and no one else has access to this machine. It's either that Redhat uses a different elevator setting for SCSI drives than IDEs or the latest Redhat updates I applied brought it to my current numbers. Besides, I believe your values may indicate

Re: [GENERAL] Recomended FS

2003-10-20 Thread Steve Crawford
On Monday 20 October 2003 10:28 am, scott.marlowe wrote: On Mon, 20 Oct 2003, Peter Childs wrote: On Mon, 20 Oct 2003, Shridhar Daithankar wrote: A fast HD with a good RAID controller. Subject to budget, SCSI are beter buy than IDE. So does hardware SCSI RAID. I hate asking this

Re: [GENERAL] Recomended FS

2003-10-20 Thread Mike Benoit
This site: http://fsbench.netnation.com/ has some decent generic file system benchmarks that may help with your decision. On Mon, 2003-10-20 at 10:32, Murthy Kambhampaty wrote: You'd be well served if you could benchmark several filesystems and see which one gives the best performance (talk

Re: [GENERAL] Pgsql 7.3.3 on redhat 7.2

2003-10-20 Thread Alvaro Herrera
On Mon, Oct 20, 2003 at 03:23:39PM -0400, Daniel E. Fisher wrote: Ok...ran into problems backing database up. trying to run pg_dumpall backup102003 gives me Database version 7.3.3 compiled by gcc 2.96 Archiver DB ver 7.1.3 Aborting cause of version mismatch. Huh... apparently you

Re: [GENERAL] Recomended FS

2003-10-20 Thread Unihost Web Hosting
Hi Ben, You asked so here's my take on the subject, but I've gotta say that you can't go far wrong with reading Bruce Momjian's paper at: http://www.ca.postgresql.org/docs/momjian/hw_performance/ But with that aside. 1. Unless your doing major league DB stuff, the FS should make more than

Re: [GENERAL] Recomended FS

2003-10-20 Thread Peter Eisentraut
Ben-Nes Michael writes: 1. What is the preferred FS to go with ? EXT3, Reiseref, JFS, XFS ? ( speed, efficiency ) PostgreSQL might work better on simple file systems, so you avoid making the head run all over the place for writing its own log and the PostgreSQL log. Some have even suggested

[GENERAL] lastval(seq) ?

2003-10-20 Thread CSN
How do you get the last value of a sequence without having called nextval? phppgadmin displays last value for sequences (I haven't found out how yet rooting through the code). CSN __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search