Re: [ADMIN] fail-safe sql update triggers

2010-09-07 Thread Igor Neyman
-Original Message- From: Michael Monnerie [mailto:michael.monne...@is.it-management.at] Sent: Friday, September 03, 2010 9:03 AM To: pgsql-admin@postgresql.org Subject: fail-safe sql update triggers I want to log all activity from a table to a old_table. Creating an ON INSERT

[ADMIN] [NOVICE] - SAN\NAS\DAS - Need help

2010-09-07 Thread fel
Hi all, I am working on upgrading my hardware and wondering how Postgres could work with SAN, NAS and DAS . Can someone advise me or share experiences ? Regards, Fel

[ADMIN] can't drop an old tablespace

2010-09-07 Thread Marc Mamin
Hello, (Postgres 8.3, Linux) while trying to drop a tablespace, I get an error tablespace xxx is not empty. There are effectively a few files within the corresponding folder, but all of them are empty and a few months old. moreover, pg_class does not contain any references to

[ADMIN] [NOVICE] - SAN/NAS/DAS - Need advises

2010-09-07 Thread fel
Hi all, I am working on upgrading my hardware and wondering how Postgres could work with SAN, NAS and DAS . Can someone advise me or share experiences ? Regards, Fel

Re: [ADMIN] [NOVICE] - SAN/NAS/DAS - Need advises

2010-09-07 Thread Joshua D. Drake
On Tue, 7 Sep 2010 15:03:44 +0200, fel fell...@hotmail.com wrote: Hi all, I am working on upgrading my hardware and wondering how Postgres could work with SAN, NAS and DAS . Can someone advise me or share experiences ? Unless you want to spend *A LOT* of money, DAS is the way to go. You

Re: [ADMIN] [NOVICE] - SAN\NAS\DAS - Need help

2010-09-07 Thread Kevin Grittner
fel fell...@hotmail.com wrote: I am working on upgrading my hardware and wondering how Postgres could work with SAN, NAS and DAS . Can someone advise me or share experiences ? My experiences with SAN have been all bad. If you do consider SAN, here's my checklist: (1) Assume that every

Re: [ADMIN] [NOVICE] - SAN/NAS/DAS - Need advises

2010-09-07 Thread Scott Whitney
While I agree with JD, we ended up using a fiber solution through a fiber switch with multi-path drivers (IBM DS4300). It did end up costing a few thousand dollars with all of the drives, but the performance made it worth it. The big thing you want to remember to consider with any storage

Re: [ADMIN] [NOVICE] - SAN/NAS/DAS - Need advises

2010-09-07 Thread Scott Marlowe
On Tue, Sep 7, 2010 at 9:42 AM, Joshua D. Drake j...@commandprompt.com wrote: On Tue, 7 Sep 2010 15:03:44 +0200, fel fell...@hotmail.com wrote: Hi all, I am working on upgrading my hardware and wondering how Postgres could work with SAN, NAS and DAS . Can someone advise me or share

Re: [ADMIN] [NOVICE] - SAN/NAS/DAS - Need advises

2010-09-07 Thread Jesper Krogh
On 2010-09-07 20:42, Scott Marlowe wrote: With the right supplier, you can plug in literally 100 hard drives to a regular server with DAS and for a fraction of the cost of a SAN. Ok, recently I have compared prices a NexSan SASBeast with 42 15K SAS drives with a HP MDS600 with 15K SAS

Re: [ADMIN] [NOVICE] - SAN/NAS/DAS - Need advises

2010-09-07 Thread Craig James
On 9/7/10 12:06 PM, Jesper Krogh wrote: On 2010-09-07 20:42, Scott Marlowe wrote: With the right supplier, you can plug in literally 100 hard drives to a regular server with DAS and for a fraction of the cost of a SAN. Ok, recently I have compared prices a NexSan SASBeast with 42 15K SAS

Re: [ADMIN] [NOVICE] - SAN/NAS/DAS - Need advises

2010-09-07 Thread Scott Marlowe
On Tue, Sep 7, 2010 at 1:36 PM, Craig James craig_ja...@emolecules.com wrote: On 9/7/10 12:06 PM, Jesper Krogh wrote: On 2010-09-07 20:42, Scott Marlowe wrote: With the right supplier, you can plug in literally 100 hard drives to a regular server with DAS and for a fraction of the cost of a

Re: [ADMIN] [NOVICE] - SAN/NAS/DAS - Need advises

2010-09-07 Thread Tena Sakai
Hi everybody, I have been reading this thread and I got the idea that SANs to avoid, but would somebody please give a bit of Comparison/perspective on NAS? Regards, Tena Sakai tsa...@gallo.ucsf.edu On 9/7/10 12:36 PM, Craig James craig_ja...@emolecules.com wrote: On 9/7/10 12:06 PM, Jesper

[ADMIN] vacuumdb for schema only

2010-09-07 Thread Isabella Ghiurea
Hi List, I would like to know if there is an option to run full vacuumdb for a specific schema only, I see there is option for tables or whole db . Thank you Isabella -- --- Isabella A. Ghiurea isabella.ghiu...@nrc-cnrc.gc.ca

Re: [ADMIN] [NOVICE] - SAN/NAS/DAS - Need advises

2010-09-07 Thread Jesper Krogh
On 2010-09-07 22:47, Scott Marlowe wrote: Ok, recently I have compared prices a NexSan SASBeast with 42 15K SAS drives with a HP MDS600 with 15K SAS drives. The first is 8gbit Fibre Channel, the last is 3Gbit DAS SAS. The fibre channel version is about 20% more expensive pr TB. So of course