Ron Johnson wrote:
Dinosaurist?
The big systems we use were last upgraded 5ish years ago, and are
scheduled (eventually) to be replaced with Oracle on Linux.
We've got some pretty new Alpha servers (around a year old) running VMS
8.3 which was released about the same time we got the servers
One approach would be to spool all the data to a flat file and then
pull them into the database as you are able to. This would give you
extremely high peak capability.
On May 11, 2007, at 10:35 PM, Dhaval Shah wrote:
I do care about the following:
1. Basic type checking
2. Knowing failed
I do care about the following:
1. Basic type checking
2. Knowing failed inserts.
3. Non-corruption
4. Macro transactions. That is a minimal read consistency.
The following is not necessary
1. Referential integrity
In this particular scenario,
1. There is a sustained load and peak loads. As lo
Inserting 50,000 rows a second is, uh... difficult to do, no matter
what database you're using. You'll probably have to spool the inserts
and insert them as fast as you can, and just hope you don't fall too
far behind.
But I'm suspecting that you aren't going to be doing much, if any,
ref
Here is the straight dope, one of internal teams at my customer site
is looking into MySql and replacing its storage engine so that they
can store large amount of streamed data. The key here is that the data
they are getting is several thousands of rows in an extremely short
duration. They say tha
"Sorin N. Ciolofan" <[EMAIL PROTECTED]> writes:
> Also I increased the max_locks_per_transaction from 64 to 10 000.
> I still receive the same error form Postgres:
> org.postgresql.util.PSQLException: ERROR: out of shared memory
Did you remember to restart the postmaster after doing that? (pg_
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/11/07 12:08, Joshua D. Drake wrote:
> Geoffrey wrote:
>> Ron Johnson wrote:
>>
>>> Call me elitist, but I've used OpenVMS for so long that if it's not
>>> a VMS-style shared-disk cluster, it's a false usage of the word.
>>
>> Okay, you're an elit
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/11/07 08:31, Geoffrey wrote:
Call me elitist, but I've used OpenVMS for so long that if it's not
a VMS-style shared-disk cluster, it's a false usage of the word.
Compute-clusters excluded, of course.
Hear here!
(I guess
I have a transaction in postgres database as follows:
1 Insert in table xyz
2 trigger fired on table xyz after insert
3 Trigger calls a function func
4 func is an implementation of a client socket in perl
1-4 happens in database environment only
at 4, a socket connection is opened to a unix too
Still looking for a possible (more simple) replacement for Slony in the
background.
1. Seems SkyTools does not have an utility to spread DDL changes among all
the replicas (like slonik does). So, if I want to ALTER TABLE, I have to run
this command manually on each node?
2. The architecture of t
On Thu, May 10, 2007 at 20:43:20 -0500,
John Gateley <[EMAIL PROTECTED]> wrote:
> Sorry if this is a FAQ, I did search and couldn't find much.
>
> I need to make my Postgresql installation fault tolerant.
> I was imagining a RAIDed disk array that is accessible from two
> (or multiple) computers
Tom Lane escribió:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > Why on earth is it talking about MULE_INTERNAL?
>
> IIRC, a lot of the conversions translate through some common
> intermediate charset to save on code/table space. In such cases
> the problem will usually be detected on the back
On Wed, 2007-05-09 at 14:20 +0100, Darren Bird wrote:
> Is there a way of asking Postgresql if a particular table was changed
> without going back through the logs - like a last modified flag or
> even just a changed flag?
If the table change caused a rewrite of the table it will have a new
relfil
Joshua D. Drake wrote:
Geoffrey wrote:
Ron Johnson wrote:
Call me elitist, but I've used OpenVMS for so long that if it's not
a VMS-style shared-disk cluster, it's a false usage of the word.
Okay, you're an elitist...
People still use OpenVMS? ... elitist isn't the word I would choose ;)
Magnus Hagander wrote:
>> I'm using 8.1.8 and I don't find plainto_tsquery in tsearch2.sql
>>
>> What can I do?
>
> Yeah, you need 8.2 for that function. I don't think anybody has tried
> backpatching it, but if you want to you can look at the code in 8.2 and
> see if you can backpatch it yourself
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Why on earth is it talking about MULE_INTERNAL?
IIRC, a lot of the conversions translate through some common
intermediate charset to save on code/table space. In such cases
the problem will usually be detected on the backend conversion...
Geoffrey wrote:
Ron Johnson wrote:
Call me elitist, but I've used OpenVMS for so long that if it's not
a VMS-style shared-disk cluster, it's a false usage of the word.
Okay, you're an elitist...
People still use OpenVMS? ... elitist isn't the word I would choose ;)
Sincerely,
Joshua D. D
Apparently you will need to implement a UNICODE aware JDBC driver
http://archives.postgresql.org/pgsql-general/2004-01/msg01649.php
Martín
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed.
On 09/05/07, Lew <[EMAIL PROTECTED]> wrote:
Felix Kater wrote:
> I am not bound to indexes, however, wonder if foreign keys itself are
> non-atomic functionality. I mean: if foreign keys are based on some
> other lower level functionality like indexes or anything else which I
> could use as a su
Ron Johnson wrote:
Call me elitist, but I've used OpenVMS for so long that if it's not
a VMS-style shared-disk cluster, it's a false usage of the word.
Okay, you're an elitist...
Compute-clusters excluded, of course.
- --
Ron Johnson, Jr.
Jefferson LA USA
--
Until later, Geoffrey
Those
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/11/07 08:31, Geoffrey wrote:
> Ron Johnson wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> On 05/11/07 07:32, Geoffrey wrote:
>>> John Gateley wrote:
Sorry if this is a FAQ, I did search and couldn't find much.
I n
Hello!
I increased significantly the number of shared buffers from 3000 to 100 000
(80Mb)
Also I increased the max_locks_per_transaction from 64 to 10 000.
I still receive the same error form Postgres:
org.postgresql.util.PSQLException: ERROR: out of shared memory
Is this message approp
Martin Marques escribió:
> I have a doubt about the function to_ascii() and what the documentation
> says.
>
> Basically, I passed my DB from latin1 to UTF-8, and I started getting an
> error when using the to_ascii() function on a field of one of my DB [1]:
>
> ERROR: la conversión de codific
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/11/07 07:32, Geoffrey wrote:
John Gateley wrote:
Sorry if this is a FAQ, I did search and couldn't find much.
I need to make my Postgresql installation fault tolerant.
I was imagining a RAIDed disk array that is accessible
Albe Laurenz wrote:
[2]:
http://www.postgresql.org/docs/8.1/interactive/functions-string.html#FTN.AEN7625
Well, the documentation for to_ascii states clearly:
"The to_ascii function supports conversion from LATIN1, LATIN2,
LATIN9, and WIN1250 encodings only."
Sorry, didn't see the footn
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/11/07 07:32, Geoffrey wrote:
> John Gateley wrote:
>> Sorry if this is a FAQ, I did search and couldn't find much.
>>
>> I need to make my Postgresql installation fault tolerant.
>> I was imagining a RAIDed disk array that is accessible from two
> I have a doubt about the function to_ascii() and what the
> documentation says.
>
> Basically, I passed my DB from latin1 to UTF-8, and I started
What do you mean by 'passed the DB from Latin1 to UTF8'?
> getting an error when using the to_ascii() function on a field
> of one of my DB [1]:
>
Martin Marques a écrit :
I have a doubt about the function to_ascii() and what the documentation
says.
Basically, I passed my DB from latin1 to UTF-8, and I started getting an
error when using the to_ascii() function on a field of one of my DB [1]:
ERROR: la conversión de codificación de UT
LEGEAY Jérôme wrote:
for convert my DB, i use this process:
createdb -T "old_DB" "copy_old_DB"
dropdb "old_DB"
createdb -E LATIN1 -T "copy_old_DB" "new_DB_name"
maybe this process will help you.
As I said in my original mail, the DB conversion went OK, but I see some
discrepancies in the do
John Gateley wrote:
Sorry if this is a FAQ, I did search and couldn't find much.
I need to make my Postgresql installation fault tolerant.
I was imagining a RAIDed disk array that is accessible from two
(or multiple) computers, with a postmaster running on each computer.
(Hardware upgrades could
for convert my DB, i use this process:
createdb -T "old_DB" "copy_old_DB"
dropdb "old_DB"
createdb -E LATIN1 -T "copy_old_DB" "new_DB_name"
maybe this process will help you.
regards
Jérôme LEGEAY
Le 14:13 11/05/2007, vous avez écrit:
I have a doubt about the function to_ascii() and what the
I have a doubt about the function to_ascii() and what the documentation
says.
Basically, I passed my DB from latin1 to UTF-8, and I started getting an
error when using the to_ascii() function on a field of one of my DB [1]:
ERROR: la conversión de codificación de UTF8 a ASCII no está soporta
Hi,
On Fri, 2007-05-11 at 06:24 -0400, Bill Moran wrote:
> PGCluster II does this. I don't know if it's out of beta yet.
Mitani is injured (left thumb) and he has been out of touch since 2
months. Last time we talked (1 month before) he said that he would
continue working on PGCluster-II after h
In response to John Gateley <[EMAIL PROTECTED]>:
> Sorry if this is a FAQ, I did search and couldn't find much.
>
> I need to make my Postgresql installation fault tolerant.
> I was imagining a RAIDed disk array that is accessible from two
> (or multiple) computers, with a postmaster running on e
Dave Page wrote:
> novnov wrote:
>> I have python 2.4 installed; python24\lib in the path; why is the PL\python
>> option presented but disabled in 8.2 postgres installer? There must be some
>> conditions under which it (and the other langs) are enabled. The only one of
>> the 7 show that is enable
> how can I set the client_encoding to what I need?
With SQL:
SET client_encoding =
Yours,
Laurenz Albe
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
novnov wrote:
> I have python 2.4 installed; python24\lib in the path; why is the PL\python
> option presented but disabled in 8.2 postgres installer? There must be some
> conditions under which it (and the other langs) are enabled. The only one of
> the 7 show that is enabled is PL/pgsql. I've fou
Tom Lane wrote:
> Ron Johnson <[EMAIL PROTECTED]> writes:
>> On 05/10/07 21:24, Tom Lane wrote:
>>> My instinctive CS-major reply to that is "only if you've found a
>>> solution to the halting problem". However, it's possible that we could
>>> detect this case for a useful subset of real-world fun
Thank reply for me
Can u show me
How will i backup database on Function or proc on Database??
--
View this message in context:
http://www.nabble.com/backup-and-restore-tf3714247.html#a10427265
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
---(e
Ottavio Campana wrote:
> Magnus Hagander wrote:
>> On Mon, May 07, 2007 at 05:31:02PM -0700, Ottavio Campana wrote:
>>> Hi, I'm trying to use tsearch2 for the first time and I'm having a
>>> problem setting up a query
>>>
>>> If I execute
>>>
>>> SELECT * from test_table where ts_desc @@ to_tsquery
anhtin wrote:
Anybody show for me ?
i want backup database and i read on Internet have function
pg_start_backup(C:\Program Files\MicrosoftSQLServer\MSSQL\BACKUP\abc.backup)
but i not run
Some body show me. How will i do run this function ??
Read the documentation!
http://www.postgresql.org
anhtin wrote:
Anybody show for me ?
i want backup database and i read on Internet have function
pg_start_backup(C:\Program Files\MicrosoftSQLServer\MSSQL\BACKUP\abc.backup)
but i not run
Some body show me. How will i do run this function ??
See:
http://www.postgresql.org/docs/8.2/static/co
anhtin wrote:
Anybody show for me ?
i want backup database and i read on Internet have function
pg_start_backup(C:\Program Files\MicrosoftSQLServer\MSSQL\BACKUP\abc.backup)
but i not run
Some body show me. How will i do run this function ??
See:
http://www.postgresql.org/docs/8.2/static/co
Anybody show for me ?
i want backup database and i read on Internet have function
pg_start_backup(C:\Program Files\MicrosoftSQLServer\MSSQL\BACKUP\abc.backup)
but i not run
Some body show me. How will i do run this function ??
--
View this message in context:
http://www.nabble.com/backup-and
Anybody show for me ?
i want backup database and i read on Internet have function
pg_start_backup(C:\Program Files\MicrosoftSQLServer\MSSQL\BACKUP\abc.backup)
but i not run
Some body show me. How will i do run this function ??
--
View this message in context:
http://www.nabble.com/backup-and
45 matches
Mail list logo
