2b- LARGE UPS because HDs are the components that have the higher power
consomption (a 700VA UPS gives me about 10-12 minutes on a machine
with a XP2200+, 1GB RAM and a 40GB HD, however this fall to..
less than 25 secondes with seven HDs ! all ATA),
I got my hands on a (free)
Steve Atkins <[EMAIL PROTECTED]> writes:
> On May 9, 2006, at 2:16 AM, Hannes Dorbath wrote:
>
> > Hi,
> >
> > I've just had some discussion with colleagues regarding the usage of
> > hardware or software raid 1/10 for our linux based database servers.
> >
> > I myself can't see much reason to
Douglas McNaught <[EMAIL PROTECTED]> writes:
> Vivek Khera <[EMAIL PROTECTED]> writes:
>
> > On May 9, 2006, at 11:51 AM, Joshua D. Drake wrote:
> >
> >> And dollar for dollar, SCSI will NOT be faster nor have the hard
> >> drive capacity that you will get with SATA.
> >
> > Does this hold true s
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> On 9 May 2006 17:04:31 -0700, Karen Hill <[EMAIL PROTECTED]> wrote:
>> Is my understanding correct that the following is vulnerable to SQL
>> injection in psql:
> ...
> no, IMO this is the safest and best option.
Neither of the options that Karen show
On May 10, 2006, at 12:06 AM, Adam wrote:
CREATE TABLE "users" ("user_ID" SERIAL(12), "first_name" character
varying(40) NOT NULL, "last_name" character varying(40) NOT NULL,
"password" character varying(16) NOT NULL, "email" character varying
(100) NOT NULL, "privilege" integer(2) NOT NULL
Adam wrote:
I'm trying to create a table and I'm getting this error:
SQL error:
ERROR: syntax error at or near "(" at character 39
In statement:
CREATE TABLE "users" ("user_ID" SERIAL(12), "first_name" character
varying(40) NOT NULL, "last_name" character varying(40) NOT NULL,
"Adam" <[EMAIL PROTECTED]> writes:
> I'm trying to create a table and I'm getting this error:
> ERROR: syntax error at or near "(" at character 39
> In statement:
> CREATE TABLE "users" ("user_ID" SERIAL(12),
SERIAL doesn't take a parameter.
regards, tom lane
If you count over 39 characters, you will see the parser is barking at
this:
"user_ID" SERIAL(12)
^
See:
http://www.postgresql.org/docs/8.1/static/datatype.html#DATATYPE-SERIAL
to find out why your definition is confusing Mr. SQL-parser.
> -Original Message-
> From: [EMA
I'm trying to create a table and I'm getting this error:
SQL error:
ERROR: syntax error at or near "(" at character 39
In statement:
CREATE TABLE "users" ("user_ID" SERIAL(12), "first_name" character
varying(40) NOT NULL, "last_name" character varying(40) NOT NULL, "password"
On May 9, 2006, at 11:26 AM, Joshua D. Drake wrote:
Of course not, but which drives lie about sync that are SATA? Or
more specifically SATA-II?
I don't know the answer to this question, but have you seen this tool?
http://brad.livejournal.com/2116715.html
It attempts to experimentally de
beer schreef:
Hello All
So I have an old database that is ASCII_SQL encoded. For a variety of reasons
I need to convert the database to UNICODE. I did some googling on this but
have yet to find anything that looked like a viable option, so i thought I'd
post to the group and see what sort o
On May 8, 2006, at 12:14 PM, Thomas Sondag wrote:
I tried various things with the --set option of psql without
success, like
--set client_encoding=win1252 or --set CLIENT_ENCODING=win1252 or --
set encoding=win1252.
The variables are case sensitive, so it looks like you left out the
righ
Scott Marlowe wrote:
> Actually, in the case of the Escalades at least, the answer is yes.
> Last year (maybe a bit more) someone was testing an IDE escalade
> controller with drives that were known to lie, and it passed the power
> plug pull test repeatedly. Apparently, the escalades tell the dr
Joshua D. Drake wrote:
> Vivek Khera wrote:
> >
> > On May 9, 2006, at 11:51 AM, Joshua D. Drake wrote:
> >
> >> Sorry that is an extremely misleading statement. SATA RAID is
> >> perfectly acceptable if you have a hardware raid controller with a
> >> battery backup controller.
> >>
> >> And do
On 9 May 2006 17:04:31 -0700, Karen Hill <[EMAIL PROTECTED]> wrote:
Is my understanding correct that the following is vulnerable to SQL
injection in psql:
CREATE OR REPLACE FUNCTION fx ( my_var bchar)
RETURNS void AS
$$
BEGIN
INSERT INTO fx VALUES ( my_var ) ;
END;
$$
LANGUAGE 'plpgsql' VOLATILE
Is my understanding correct that the following is vulnerable to SQL
injection in psql:
CREATE OR REPLACE FUNCTION fx ( my_var bchar)
RETURNS void AS
$$
BEGIN
INSERT INTO fx VALUES ( my_var ) ;
END;
$$
LANGUAGE 'plpgsql' VOLATILE
Where this is NOT subject to SQL injection:
CREATE OR REPLACE FUNCT
On Tuesday May 9 2006 3:07 pm, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> >from /opt/pgsql/installs/postgresql-7.3.4/bin/postmaster
> > (gdb) bt
> > #0 0x12d288 in InitBufferPoolAccess ()
> >from /opt/pgsql/installs/postgresql-7.3.4/bin/postmaster
> > Error accessing memory ad
Tom Lane wrote:
David Link <[EMAIL PROTECTED]> writes:
The following large EXPLAIN SELECT Statement fails to return, but
continues to take up processing time until it is killed.
[ 52-way join... ]
Am I right in guessing that all the sales_xxx tables are the same size
and have similar
On Tue, 9 May 2006 17:10:21 -0400
"Rodrigo Cortés" <[EMAIL PROTECTED]> wrote:
> > A) "Possible" is a BIG word. So is "anywhere". If you could narrow
> > these two down a bit it might help answer your question.
> >
> possible mean "how to do it"
> anywhere mean "a pc with a windows os"
>
> -
On Tue, 9 May 2006 17:06:53 -0400
"Rodrigo Cortés" <[EMAIL PROTECTED]> wrote:
> On 5/9/06, John Purser <[EMAIL PROTECTED]> wrote:
> > On Tue, 9 May 2006 16:54:37 -0400
> > "Rodrigo Cortés" <[EMAIL PROTECTED]> wrote:
> >
> > > It is possible to install postgres on usb driver to run it
> > > anywher
A) "Possible" is a BIG word. So is "anywhere". If you could narrow
these two down a bit it might help answer your question.
possible mean "how to do it"
anywhere mean "a pc with a windows os"
---(end of broadcast)---
TIP 6: explain analyze is yo
"Ed L." <[EMAIL PROTECTED]> writes:
>from /opt/pgsql/installs/postgresql-7.3.4/bin/postmaster
> (gdb) bt
> #0 0x12d288 in InitBufferPoolAccess ()
>from /opt/pgsql/installs/postgresql-7.3.4/bin/postmaster
> Error accessing memory address 0x0: Invalid argument.
Right offhand I'd imagine tha
On 5/9/06, John Purser <[EMAIL PROTECTED]> wrote:
On Tue, 9 May 2006 16:54:37 -0400
"Rodrigo Cortés" <[EMAIL PROTECTED]> wrote:
> It is possible to install postgres on usb driver to run it anywhere???
>
> ---(end of
> broadcast)--- TIP 4: Have you
On 05/09/2006 03:47:20 PM, Tom Lane wrote:
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> I'm wondering if there's a problem with pg_dump --create,
> or if I'm just missing something.
> It does not seem to restore things like:
> ALTER DATABASE foo SET "DateStyle" TO European;
> Shouldn't the datab
On Tue, 9 May 2006 16:54:37 -0400
"Rodrigo Cortés" <[EMAIL PROTECTED]> wrote:
> It is possible to install postgres on usb driver to run it anywhere???
>
> ---(end of
> broadcast)--- TIP 4: Have you searched our
> list archives?
>
>h
It is possible to install postgres on usb driver to run it anywhere???
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> I'm wondering if there's a problem with pg_dump --create,
> or if I'm just missing something.
> It does not seem to restore things like:
> ALTER DATABASE foo SET "DateStyle" TO European;
> Shouldn't the database that is re-created be like
> the database
On May 9, 2006 01:03 pm, jef peeraer <[EMAIL PROTECTED]> wrote:
> well i recently struggled with the same problem. After a lot of trial
> and error and reading, it seems that an ascii encoded database can't use
> its client encoding capabilities ( set client_encoding to utf8 ).
> i think the easist
beer schreef:
> Hello All
>
> So I have an old database that is ASCII_SQL encoded. For a variety
of reasons I need to convert the database to UNICODE. I did some
googling on this but have yet to find anything that looked like a viable
option, so i thought I'd post to the group and see what so
The schema can change, but I rather not.
The use case is a web app where you can tag items with tags
(many-2-many). There are multiple items you can tag: contacts,
schedules, lists, etc... And then you can search and categorize by
tags. The standard for this if you look aroung the web is to retri
Postgresql 8.1.3
Hi,
I'm wondering if there's a problem with pg_dump --create,
or if I'm just missing something.
It does not seem to restore things like:
ALTER DATABASE foo SET "DateStyle" TO European;
Shouldn't the database that is re-created be like
the database that is being dumped?
For ou
Currently the documentation says:
A database that is marked datallowconn = false in pg_database is
assumed to be properly frozen; the automatic warnings and wraparound
protection shutdown do not take such databases into account. Therefore
it's up to you to ensure you've correctly frozen a databas
On 5/9/06, Marko Kreen <[EMAIL PROTECTED]> wrote:
On 5/9/06, Joe Kramer <[EMAIL PROTECTED]> wrote:> On 5/9/06, Marko Kreen <[EMAIL PROTECTED]> wrote:> > The fact that Fedora pgcrypto is linked with OpenSSL that does not
> > support SHA256 is not a bug, just a fact.>> It's not Fedora only, same prob
On Mon, May 08, 2006 at 02:10:02PM -0700, robert wrote:
> 1) Isn't the user 'postgres' pre-configured? Running this seems to
> imply so: 'select datname from pg_database;'
> datname
> ---
> postgres
This demonstrates a *database* named postgres. Users are in the pg_user
table.
>
On Tue, May 09, 2006 at 10:52:32AM -0600, Blair Lowe wrote:
> In my test I do not see stuff2 either. The problem here is that I have
> sensitive production data, so my tests are hard to read, and not able to
> submit here.
You don't need to show any data, just the schema will be enough. An
example
On Tue, 2006-05-09 at 12:52, Steve Atkins wrote:
> On May 9, 2006, at 8:51 AM, Joshua D. Drake wrote:
>
> ("Using SATA drives is always a bit of risk, as some drives are lying
> about whether they are caching or not.")
>
> >> Don't buy those drives. That's unrelated to whether you use hardware
On Mon, May 08, 2006 at 18:37:31 -0700,
leo camalig <[EMAIL PROTECTED]> wrote:
> Good Day
>
>
> I Just want to ask on how to allow a non-local in PostgreSQL without adding
> it in
> pg-hba.conf
That isn't possible. You need to grant the access using that file.
> I just want
> tagged_type int -- points to the table this tag is tagging
My head exploded right about here. Is the schema written in stone, or
can it change?
What is the use case for this schema? What's it for? What is a "tag"
about?
Best Regards,
Wayne Conrad
---(end of
leo camalig wrote:
Good Day
I Just want to ask on how to allow a non-local in PostgreSQL
without adding it in
pg-hba.conf
You don't. pg_hba.conf is the place where you can specify who
can connect from where to which database using what authentication
method. Your only alternative to us
Douglas McNaught wrote:
Vivek Khera <[EMAIL PROTECTED]> writes:
On May 9, 2006, at 11:51 AM, Joshua D. Drake wrote:
And dollar for dollar, SCSI will NOT be faster nor have the hard
drive capacity that you will get with SATA.
Does this hold true still under heavy concurrent-write loads? I'm
On May 9, 2006, at 11:26 AM, Joshua D. Drake wrote:
You're not suggesting that a hardware RAID controller will protect
you against drives that lie about sync, are you?
Of course not, but which drives lie about sync that are SATA? Or
more specifically SATA-II?
SATA-II, none that I'm awar
You're not suggesting that a hardware RAID controller will protect
you against drives that lie about sync, are you?
Of course not, but which drives lie about sync that are SATA? Or more
specifically SATA-II?
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command P
I'm trying to generate a query that will handle tags matching in a database.
The simplified structure is
create table contacts (
id serial primary key,
name varchar
);
create table books (
id serial primary key,
name varchar
);
create table tags (
id serial primary key,
name varchar
);
Vivek Khera wrote:
On May 9, 2006, at 11:51 AM, Joshua D. Drake wrote:
Sorry that is an extremely misleading statement. SATA RAID is
perfectly acceptable if you have a hardware raid controller with a
battery backup controller.
And dollar for dollar, SCSI will NOT be faster nor have the hard
On 05/08/2006 06:42:18 PM, Tom Lane wrote:
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> I'm having trouble with a dump and restore:
Um ... it looks to me like you're trying to restore into an existing
table that already has the same data loaded ...
Thanks everybody, the problem was in the sch
Vivek Khera <[EMAIL PROTECTED]> writes:
> On May 9, 2006, at 11:51 AM, Joshua D. Drake wrote:
>
>> And dollar for dollar, SCSI will NOT be faster nor have the hard
>> drive capacity that you will get with SATA.
>
> Does this hold true still under heavy concurrent-write loads? I'm
> preparing yet
On May 9, 2006, at 11:51 AM, Joshua D. Drake wrote:
Sorry that is an extremely misleading statement. SATA RAID is
perfectly acceptable if you have a hardware raid controller with a
battery backup controller.
And dollar for dollar, SCSI will NOT be faster nor have the hard
drive capacity
On Mon, 8 May 2006, Blair Lowe wrote:
> Hi,
>
> I have had this problem for a while, and have not been able to find
> anything in the archives or on search engines:
>
> If I want to back up a client's database on our shared web server, I
> would type:
>
> pg_dump
try pgdump -t to just ge
Each distant database works on its own domain of data. Then no conflict should
happen during updates.
One thing I have not specified is that the distant databases don't handle
global data but only data collected at the local level.
Slony-1 seems not to provide replication from multi-partial datab
Good Day I Just want to ask on how to allow a non-local in PostgreSQL without adding it in pg-hba.conf I just want to view a desktop application on Web, yes it works, but you need to allow those I.P. addresses that will gonna connect to postgreSQL. What I want is everyone in the ne
hi all,
I try to solve a litle problem, with PostgreSQL 8.1.3 on windows with UTF8.
I read all the documentation related to psql on windows, I turn my cmd.exe encoding to codepage 1252 with the good font.
When I try a connection to my UTF8 database with psql (with my windows
cp1252 terminal) I h
> First, i have no knowledge of anyone that have implemented full
> disjunctions(ever) aside
> from the theoretical works of my colleagues.
> With the exception of a corner case of it, that I believe was a simulation in
> 96.
> (A. Rajaman and J.D. Ullman Integrating information by outerjoins and
Bruno Wolff III escreveu:
> On Mon, May 08, 2006 at 23:10:31 +0900,
> kmh496 <[EMAIL PROTECTED]> wrote:
> > doesn't that user have to exist since you are using ident method? that
> > means unix username == postgres username.
> > do you have a user named maragato_test on the system?
> > did you
On May 9, 2006, at 8:51 AM, Joshua D. Drake wrote:
("Using SATA drives is always a bit of risk, as some drives are lying
about whether they are caching or not.")
Don't buy those drives. That's unrelated to whether you use hardware
or software RAID.
Sorry that is an extremely misleading st
I have a 7.3.4 cluster that just sigsegv'd. I know an
upgrade is desperately needed. In the meantime, does the
following gdb output provide any clues as to what we might
be able to do to nurse it along until we upgrade?
Thanks,
Ed
PostgreSQL 7.3.4 on hppa2.0w-hp-hpux11.00, compiled by GCC gcc
Tom Lane wrote:
Blair Lowe <[EMAIL PROTECTED]> writes:
On Mon, 2006-08-05 at 16:32 -0700, Joshua D. Drake wrote:
What version of PostgreSQL is this that you are using? Because it
]# rpm -qi postgresql
Name: postgresql Relocations: (not
relocateable)
Version : 7.
On Tue, 2006-09-05 at 12:25 -0400, Tom Lane wrote:
> Blair Lowe <[EMAIL PROTECTED]> writes:
> > On Mon, 2006-08-05 at 16:32 -0700, Joshua D. Drake wrote:
> >> What version of PostgreSQL is this that you are using? Because it
>
> > ]# rpm -qi postgresql
> > Name: postgresql
A word of advice: if there is any chance that a column (e.g. text) contains
an embedded newline, you will be much better off outputting the data in
simple xml, instead of CSV. This works very well with Excel for import. I
just did a simple program for this recently.
Susan
Blair Lowe <[EMAIL PROTECTED]> writes:
> On Mon, 2006-08-05 at 16:32 -0700, Joshua D. Drake wrote:
>> What version of PostgreSQL is this that you are using? Because it
> ]# rpm -qi postgresql
> Name: postgresql Relocations: (not
> relocateable)
> Version : 7.3.4
On 09.05.2006, at 16:52 Uhr, Reid Thompson wrote:
*WebObjects Distribution License
$699 per copy*
WebObjects, the premier web application server used by hundreds of
corporations, is now available for redistribution by web
application developers just like you.
Upon signature by Apple, the
On Tue, 2006-09-05 at 13:19 +1200, Brent Wood wrote:
>
> On Mon, 8 May 2006, Blair Lowe wrote:
>
> > Hi,
> >
> > I have had this problem for a while, and have not been able to find
> > anything in the archives or on search engines:
> >
> > If I want to back up a client's database on our shared we
On 09.05.2006, at 16:31 Uhr, Steve Atkins wrote:
Is that actually true? My understanding was that under the most recent
license changes it was not possible to deploy it to any platform other
than XServe.
Wrong. You are allowed to deploy on any platform you like, but only
Mac OS X Server is o
Hello All
So I have an old database that is ASCII_SQL encoded. For a variety of reasons
I need to convert the database to UNICODE. I did some googling on this but
have yet to find anything that looked like a viable option, so i thought I'd
post to the group and see what sort of advice might a
On Mon, 2006-08-05 at 16:32 -0700, Joshua D. Drake wrote:
> Hello,
>
> What version of PostgreSQL is this that you are using? Because it
]# rpm -qi postgresql
Name: postgresql Relocations: (not
relocateable)
Version : 7.3.4 Vendor: Red H
On Tue, 09 May 2006 10:58:07 -0400
Ryan Suarez <[EMAIL PROTECTED]> wrote:
> Greetings,
>
> I am running postgres 7.4.7 on debian sarge.
>
> I need to run an SQL query and store the results in a file. The
> format needs to be comma separated values (CSV), so I can import this
> later in Excel.
Don't buy those drives. That's unrelated to whether you use hardware
or software RAID.
Sorry that is an extremely misleading statement. SATA RAID is perfectly
acceptable if you have a hardware raid controller with a battery backup
controller.
And dollar for dollar, SCSI will NOT be faster n
On Tue, 2006-05-09 at 04:16, Hannes Dorbath wrote:
> Hi,
>
> I've just had some discussion with colleagues regarding the usage of
> hardware or software raid 1/10 for our linux based database servers.
>
> I myself can't see much reason to spend $500 on high end controller
> cards for a simple R
Dan Armbrust <[EMAIL PROTECTED]> writes:
> I have a java application that is trying to dynamically drop a set of
> tables. Problem is, when it gets to a particular table and I execute
> the "drop table foo cascade" command from a prepared statement, the
> query never returns. It just hangs ind
I have a java application that is trying to dynamically drop a set of
tables. Problem is, when it gets to a particular table and I execute
the "drop table foo cascade" command from a prepared statement, the
query never returns. It just hangs indefinitely. I presume that it is
waiting on a lo
On 05/09/2006 10:24:28 AM, Tom Lane wrote:
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> On 05/08/2006 06:42:18 PM, Tom Lane wrote:
>> Um ... it looks to me like you're trying to restore into an
existing
>> table that already has the same data loaded ...
> I'm not clear on where to start with th
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> On 05/08/2006 06:42:18 PM, Tom Lane wrote:
>> Um ... it looks to me like you're trying to restore into an existing
>> table that already has the same data loaded ...
> That's what I thought at first, except that I had just created
> the db structure wit
Greetings,
I am running postgres 7.4.7 on debian sarge.
I need to run an SQL query and store the results in a file. The format
needs to be comma separated values (CSV), so I can import this later in
Excel.
Any ideas on how to accomplish this?
much appreciated,
Ryan
-
On 05/08/2006 06:42:18 PM, Tom Lane wrote:
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> I'm having trouble with a dump and restore:
> $ pg_dump --format=t --schema=babase --data-only --user babase_admin
> babase_test | pg_restore --data-only --disable-triggers --user
> babase_admin --dbname=ba
On Tue, May 09, 2006 at 12:10:32 +0200,
"Jean-Yves F. Barbier" <[EMAIL PROTECTED]> wrote:
> Naa, you can find ATA &| SATA ctrlrs for about EUR30 !
But those are the ones that you would generally be better off not using.
> Definitely NOT, however if your server doen't have a heavy load, the
> so
Steve Atkins wrote:
On May 8, 2006, at 11:05 PM, Guido Neitzer wrote:
On 09.05.2006, at 0:33 Uhr, Karen Hill wrote:
What is your favorite front end for end users to interact with your
postgresql db? Is it java, .net, web apache + php, MS-Access, ruby on
rails? Why is it your favorite? Which
On 5/9/06, Joe Kramer <[EMAIL PROTECTED]> wrote:
On 5/9/06, Marko Kreen <[EMAIL PROTECTED]> wrote:
> The fact that Fedora pgcrypto is linked with OpenSSL that does not
> support SHA256 is not a bug, just a fact.
It's not Fedora only, same problem with Gentoo/portage.
I think it's problem for all
On May 9, 2006, at 2:16 AM, Hannes Dorbath wrote:
Hi,
I've just had some discussion with colleagues regarding the usage
of hardware or software raid 1/10 for our linux based database
servers.
I myself can't see much reason to spend $500 on high end controller
cards for a simple Raid 1.
On May 8, 2006, at 11:05 PM, Guido Neitzer wrote:
On 09.05.2006, at 0:33 Uhr, Karen Hill wrote:
What is your favorite front end for end users to interact with your
postgresql db? Is it java, .net, web apache + php, MS-Access,
ruby on
rails? Why is it your favorite? Which would you recom
You will need to provide more information about the data requirement- such
as column types, what you need to search for, and the actual queries and
execution plans.
Purely as a guess, it seems like you haven't tried partial indexes:
http://www.postgresql.org/docs/8.1/interactive/sql-createindex.ht
Hello,
for 4 weeks I have imported (text) data of 50 DVD's from a customer
into my PostgreSQL and now I have a very big problem... The maintable
(called 'timeline' is around 350 GByte in size...
...and searching is the hell!
Since I try to redesign my Dat
On Tue, 09 May 2006 10:59:20 +0530
"N Srinivasa" <[EMAIL PROTECTED]> wrote:
> Hi
>
> I downloded postgresql source code, and compile it in windows
> platform, can any body plz tell me that how can i debug the
> sourcecode in windows platform,
> what are the steps are i should go through..
>
> Re
On 5/9/06, Marko Kreen <[EMAIL PROTECTED]> wrote:
On 5/9/06, Joe Kramer <[EMAIL PROTECTED]> wrote:> Thanks, but I need it to work out-of-the-box, with standard installation of> RedHat or Gentoo and standard PostgreSQL rpm.
>> I am developing application with PortgreSQL and I can't tell customer to
hello,
I want to correctly sort English, Hebrew, Russian ...
What is the best encoding for this ? ( utf-8 ? )
In the IRC i been told that utf-8 is not the solution and actually there
is no solution to correctly sort many languages.
Is that true ? Will it matter if each language will be in
On 5/9/06, Joe Kramer <[EMAIL PROTECTED]> wrote:
Thanks, but I need it to work out-of-the-box, with standard installation of
RedHat or Gentoo and standard PostgreSQL rpm.
I am developing application with PortgreSQL and I can't tell customer to
"Recompile PostgreSQL and see if it works then try
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Hannes Dorbath wrote:
> Hi,
>
> I've just had some discussion with colleagues regarding the usage of
> hardware or software raid 1/10 for our linux based database servers.
>
> I myself can't see much reason to spend $500 on high end controller
>
Martijn van Oosterhout wrote:
On Thu, May 04, 2006 at 12:22:01PM +0100, Gavin Hamill wrote:
At a guess rip = return instruction pointer, rsp = return stack point.
The fact that they're all the same seems to rule out hardware.
That's good to hear (in one way... :)
fore starting the se
Thanks, but I need it to work out-of-the-box, with standard installation of RedHat or Gentoo and standard PostgreSQL rpm.
I am developing application with PortgreSQL and I can't tell customer
to "Recompile PostgreSQL and see if it works then try to use non-openssl pgcrypto or try to compile
open
On 5/9/06, Joe Kramer <[EMAIL PROTECTED]> wrote:
Fedora core has OpenSSL 0.9.7 installed by default. And it's not possible to
install 0.9.8 because of glibc conflict.
I suspect pgcrypto looks for SHA256 in OpeSSL lib when it should use
built-in.
SHA256 is working fine on Windows but on Redhat it
On 09.05.2006 12:10, Jean-Yves F. Barbier wrote:
Naa, you can find ATA &| SATA ctrlrs for about EUR30 !
Sure, just for my colleagues Raid Controller = IPC Vortex, which resides
in that price range.
For bi-core CPUs, it might be true
I've got that from pgsql.performance for multi-way opter
Hi Hannes,
Hannes Dorbath a écrit :
> Hi,
>
> I've just had some discussion with colleagues regarding the usage of
> hardware or software raid 1/10 for our linux based database servers.
>
> I myself can't see much reason to spend $500 on high end controller
> cards for a simple Raid 1.
Naa, you
Hello,Pgcrypto SHA 256/384/512 algorithm don't work on RedHat:
db=# SELECT digest('test', 'sha1');
digest
--
\251J\217\345\314\261\233\246\034L\010s\323\221\351\207\230/\273\323
(1 row)
db=# SELECT
Title: RE: [GENERAL] database size grows (even after vacuum (full and analyze))
Ok.
I get the point. I'm using 7.2 because that's the one I got from the original Fedora Core 3 CD's.
I'll upgrade to the most recent.
Thank you all for your support.
jmf
-Original Message-
Fro
i think i make a big misstake by using kill -9 the postmaster .so ,what
should i do when i facing this problem, can someone give advise, cause i
quite new to postgresql.
how to check there is corrupted data in my database?
it there anyway i can do to prevent this error msg come back
again?
ca
Hi,
I've just had some discussion with colleagues regarding the usage of
hardware or software raid 1/10 for our linux based database servers.
I myself can't see much reason to spend $500 on high end controller
cards for a simple Raid 1.
Any arguments pro or contra would be desirable.
From
I realise this is not strictly a Postgresql problem but I wondered if anyone
here was using ha-jdbc. I have tried asking on their mailing list but
apart from two of my questions there has been no traffic for 24 hours
and it appears to be a dead list.
I have a sngle instance of ha-jdbc working ta
95 matches
Mail list logo