[ADMIN] Where are DB's?

2004-11-24 Thread Francisco Jose Bernabe Pellicer
What folder in Linux is used to store Postgres Databases? Cheers, -- ___ Francisco José Bernabé Pellicer Técnico de Sistemas Grid Departamento de Sistemas/Técnicos C.E.S.G.A Centro de Supercomputación de Galicia www.cesga.es Avda. de Vigo s/n (Cam

Re: [ADMIN] Where are DB's?

2004-11-24 Thread Moiz Kothari
Hi Francisco,       In linux when you install postgres, it is mainly stored in "/usr/local/pgsql/" . And the "data" directory inside this contains data.   Regards MoizFrancisco Jose Bernabe Pellicer <[EMAIL PROTECTED]> wrote: What folder in Linux is used to store Postgres Databases?Cheers,-- __

Re: [ADMIN] Where are DB's?

2004-11-24 Thread Francisco Jose Bernabe Pellicer
Thank you to everybody. Cheers, Francisco. Juan Miguel escribió: Francisco Jose Bernabe Pellicer wrote: What folder in Linux is used to store Postgres Databases? Cheers, It depends on your compilation or your Linux, Windows, e.t.c. distribution packages installed. For example, if you compile by yo

Re: [ADMIN] Where are DB's?

2004-11-24 Thread Juan Miguel
Francisco Jose Bernabe Pellicer wrote: What folder in Linux is used to store Postgres Databases? Cheers, It depends on your compilation or your Linux, Windows, e.t.c. distribution packages installed. For example, if you compile by yourself the source code, the default directory is usually /usr/lo

[ADMIN] pgdump in jsp

2004-11-24 Thread mariabreis
Hi! My question is how can I use pgdump command from my jsp page? If I can. Thank you! Maria ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [ADMIN] hardware to get best performance

2004-11-24 Thread Vincent Chen
>> Hi, all >> >> Does postgresql support thread? Or let me put it this way, will postgresql get >> better performance on multiple processor host than single processor? What's the >> best platform, freebsd? linux? > >If you have multiple connections to the database server making simultaneous >queri

Re: [ADMIN] hardware to get best performance

2004-11-24 Thread Jim C. Nasby
ext3 is just ext2 with journalling, and from what I've heard is rather slow. ext2 is fast because it's async. RFS is fast at losing your data. :) UFS is rock-solid and is still being developed. In the past couble years it's been changed to support some monsterous file and filesystem sizes and has