You sure there are 5 HD ?
Raid 10 suppose to have 4 HD
Raid 0 suppose to have 2 HD
Total of 6 ??
Any way Raid 0 is fast but give no reability. i prefer raid 1 or 10.
Himanshu Baweja wrote:
Currently my server has two raid controllers both with
5 disks attached::
On raid1: i have the data
i just have one raid controller with 6 disks
attached... i see all of it as single drive with three
partitions create by me...
will creating tablespaces help me also is there a
way i can say this table to this disk???
thx for ur help...
Himanshu
__
Start->Control Panel->Scheduled Tasks
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Zlatko Matic
> Sent: Monday, 27 June 2005 9:21 AM
> To: Michael Fuhr
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] automating backup ?
>
>
> Thanks Fuh
If I have a table of items with latitude and longitude
coordinates, is it possible to find all other items
that are within, say, 50 miles of an item, using the
geometric functions
(http://www.postgresql.org/docs/8.0/interactive/functions-geometry.html)?
If so, how?
Thanks,
CSN
___
Thanks Fuhr.
Anybody can tell me how to do it on Windows XP ?
Thanks.
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc:
Sent: Sunday, June 26, 2005 2:59 PM
Subject: Re: [GENERAL] automating backup ?
On Sun, Jun 26, 2005 at 11:18
- Original Message -
From: "John DeSoi" <[EMAIL PROTECTED]>
To: "Teunis Peters" <[EMAIL PROTECTED]>
Cc: "PostgreSQL general"
Sent: Sunday, June 26, 2005 6:13 PM
Subject: Re: [GENERAL] MacOSX, fink, missing readline/readline.h
On Jun 26, 2005, at 4:29 PM, Teunis Peters wrote:
This
On Sun, Jun 26, 2005 at 03:42:25PM -0500, Peter Fein wrote:
> Hi-
>
> I've defined an XOR function as:
>
>
> CREATE OR REPLACE FUNCTION xor(bool, bool)
> RETURNS bool AS
> 'SELECT ($1 OR $2) AND NOT ($1 AND $2);'
> LANGUAGE 'sql' IMMUTABLE STRICT;
>
> Is there anyway to create an infix vers
On Jun 26, 2005, at 4:29 PM, Teunis Peters wrote:
This has to do with building postgresql-8.0.3
I'm installing on a MacOSX system (10.3) and configure's failing to
find the readline installation.
What does your configure command look like? I have not tried it in a
while, but this used t
Joe <[EMAIL PROTECTED]> writes:
> It's not a matter of learning, but of information. I know what a
> command line is, but I still think the PostgreSQL documentation should
> indicate what one should do to *use* the programs. I can easily
> figure out by inspection after the install, that all/mos
Martijn van Oosterhout wrote:
People who don't care about how it works should simply install PGAdmin
III and then they don't need to understand PATHs. People who don't know
what a command line does should stay away from it. They aren't required
to use it (in theory, windows is a new port so it mi
Hi-
I've defined an XOR function as:
CREATE OR REPLACE FUNCTION xor(bool, bool)
RETURNS bool AS
'SELECT ($1 OR $2) AND NOT ($1 AND $2);'
LANGUAGE 'sql' IMMUTABLE STRICT;
Is there anyway to create an infix version of this? I'd really like be
able to write (where a..d are some boolean condit
This has to do with building postgresql-8.0.3
I'm installing on a MacOSX system (10.3) and configure's failing to
find the readline installation.
output:
checking readline/readline.h usability... yes
checking readline/readline.h presence... no
configure: WARNING: readline/readline.h: accepted
On Sun, Jun 26, 2005 at 10:59:37AM -0700, Bob Pawley wrote:
> I'll date myself so you all may know from where I am coming. My first
> lesson in binary math took place in a classroom in 1958. Since then I have
> witnessed a lot that has since swept under the bridge.
> People want tools to do ta
Jeff Gold <[EMAIL PROTECTED]> writes:
> Excellent! Does index_create refer to something that is invoked as a
> consequence of CREATE INDEX? I'm looking through the code on our side
> and can't find any obvious places where we recreate indexes, but I might
> just be missing something.
TRUNCATE
Andreas wrote:
> On the other hand I'd guess, that people who NEED that detailed handholding
would not bother to install a full blown SQL server or at least would prefer to
play with PGAdmin3.
I'm sorry but I disagree. Stating that you need to may need to add the bin
directory to your path,
-cut-
It is correct that the installer does not put the PosgtgreSQL directory
in the system PATH. This is intended behaviour - but mainly because we
didn't have time to do a "proper fix" for the 8.0 release.
We hope to give a choice to the user on what to do (where to put the
shared DLLs, and wha
I'll date myself so you all may know from where I am coming. My first lesson
in binary math took place in a classroom in 1958. Since then I have
witnessed a lot that has since swept under the bridge.
This thread reminds me of the discussion that surrounded the complexity of
using the first s
Joe schrieb:
What I am surprised is that this is (apparently) not discussed in the
manual or the FAQ. The only indirect reference I found is in section
14.6.2 where it states --in a Unix context-- that "you should add [the
PostgreSQL bin directory] into your PATH".
Well, perhaps because the
Andreas wrote:
So dere's what I did.
1) Figure out where your Postgres binaries ended up.
Probaply in C:\Programs\PostgreSQL\8.0\bin
2) Right-click on the PC-icon on your desktop. It's called "my
workplace" or something. Sorry, I have no English version.
3) Click on settings
4)Ex
On Sun, Jun 26, 2005 at 06:59:14AM -0600, Michael Fuhr wrote:
> On Sun, Jun 26, 2005 at 11:18:31AM +0200, Zlatko Matic wrote:
> >
> > How to automate backup, so that Postgres automatically backups, for
> > example, once in a week ?
>
> Using the operating system's mechanism for scheduling jobs to
On Sun, Jun 26, 2005 at 11:18:31AM +0200, Zlatko Matic wrote:
>
> How to automate backup, so that Postgres automatically backups, for
> example, once in a week ?
Using the operating system's mechanism for scheduling jobs to run
periodically. For example, cron on Unix-like systems.
> The same qu
How to automate backup, so that Postgres automatically backups, for example,
once in a week ?
The same question about vacuum ?
Concerning backup, how to prevent that someone makes a copy (for example
pg_dumpall) of a database, then installs new instance of Postgres, create
the same user acount
22 matches
Mail list logo
