Re: [ADMIN] using multiple partitions for a single table

2001-09-05 Thread Tom Lane
"Taher H. Haveliwala" <[EMAIL PROTECTED]> writes: > Is it possible in postgres 7.1.3 to have a single > table span multiple partitions? Or is using RAID the > only option? RAID or LVM are the best scenario. If you're really in a bind you could manually move table segments to different partition

Re: [ADMIN] using multiple partitions for a single table

2001-09-05 Thread Chad R. Larson
At 04:55 PM 9/4/2001 , David Stanaway wrote: >On Wednesday, September 5, 2001, at 06:58 AM, Taher H. Haveliwala wrote: > >>Is it possible in postgres 7.1.3 to have a single >>table span multiple partitions? Or is using RAID the >>only option? >> >>Thanks >>Taher Yes, you can move individual f

Re: [ADMIN] postgresql and samba II (or III?)

2001-09-05 Thread ecaillava
Dear friend Dong: No problem with your consult, but I'm not really a hacker, I'm almost a lammer |:-). The real hackers are here, into the list. So, you can keep mailing your questions, and I'm sure you'll get so much help as you eventually need. Any way, if it is posible to help you pers

[ADMIN] pg_dump & Win 9X/NT

2001-09-05 Thread pmiranda
Hi, Does anyone know how can I make a copy of a database to another machine (I'm using Postgres under Win95)? I tried to use pg_dump + pg_restore, but I don't know the correct usage of them under Win 9X/NT. I'd appreciate any tips in that matter. Thanks in advance. Paulo --

Re: [ADMIN] using multiple partitions for a single table

2001-09-05 Thread David Stanaway
On Wednesday, September 5, 2001, at 06:58 AM, Taher H. Haveliwala wrote: > Is it possible in postgres 7.1.3 to have a single > table span multiple partitions? Or is using RAID the > only option? > > Thanks > Taher Hi there, On Linux, you can use LVM (Logical Volume Manager) to do what you wan

[ADMIN] Vacuum and deadlock.

2001-09-05 Thread Sébastien HEITZMANN
Since some week I have some trouble with my database. I use postgres v 7.1.2 on redhat 7.0   The trouble is that the database lock when in the night some user left an application open ( which do some read on some table) and the night process of backup and vacuum happend. The database stay in