Esteban Kemp wrote:
I'm starting to develop a production enviroment with Postgres and
Tomcat, And I have to choose between some free linux distribution like:
whitebox
RHEL
Fedora
Suse
Which is the better distribution in terms of postgres? if this has an answer
If you are looking for boxes to r
Tom Lane wrote:
Greg Stark <[EMAIL PROTECTED]> writes:
Egads. So the set of valid Python programs is different depending on what
platform you're on? That's just, uhm, insane.
No quibble here.
Incidentally, are we sure we've diagnosed this correctly? I'm discussing this
with some Python developers
If someone wanted to put arbitrary aggregates into PostgreSQL, I would
suggest something akin to the "RED BRICK" API, or better yet, the ATLAS
API:
http://magna.cs.ucla.edu/atlas/
---(end of broadcast)---
TIP 8: explain analyze is your friend
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> If you're feeling adventurous, you might look at Oracle's documentation
> on their analytic functions and see if you can come up with something
> generic for PostgreSQL.
I think the hard part of doing even a simple implementation is precisely the
poin
Greg Stark <[EMAIL PROTECTED]> writes:
> Egads. So the set of valid Python programs is different depending on what
> platform you're on? That's just, uhm, insane.
No quibble here.
> Incidentally, are we sure we've diagnosed this correctly? I'm discussing this
> with some Python developers and the
On Fri, Jan 21, 2005 at 12:53:45AM -0500, Greg Stark wrote:
> "Vanole, Mike" <[EMAIL PROTECTED]> writes:
>
> > I need to calculate a moving average and I would like to do it with SQL,
> > or a Pg function built for this purpose. I'm on Pg 7.4. Is this possible
> > in Pg without a bunch of self joi
--On Saturday, January 08, 2005 11:14 AM -0300 Esteban Kemp
<[EMAIL PROTECTED]> wrote:
I'm starting to develop a production enviroment with Postgres and Tomcat,
And I have to choose between some free linux distribution like:
whitebox
RHEL
Fedora
Suse
Which is the better distribution in terms of p
Marco Colombo <[EMAIL PROTECTED]> writes:
> Exaclty. Or, one could say: the "standard" text format is the one the
> platform you are running on dictates. Which is what python does.
Egads. So the set of valid Python programs is different depending on what
platform you're on? That's just, uhm, ins
"Vanole, Mike" <[EMAIL PROTECTED]> writes:
> I need to calculate a moving average and I would like to do it with SQL,
> or a Pg function built for this purpose. I'm on Pg 7.4. Is this possible
> in Pg without a bunch of self joins, or is there a funtion available?
Unfortunately moving averages f
On Friday 21 January 2005 07:40, Andrew L. Gould wrote:
We are running a 200 user system off a SUN Fire v40z using SuSE Linux 9.2 for
AMD64.
On average we process a JSP page in 300 ms, country wide and have
approximately 300 tables with over 3 000 000 records in the PostgresQL DB.
I would reco
On Thursday 20 January 2005 09:20 pm, Joshua D. Drake wrote:
> [EMAIL PROTECTED] wrote:
> >Does it have to be linux? I've never had as much success with
> > PostGresql on linux as i have on FreeBSD 5.3
>
> For XFS? I don't think you are going to have with FreeBSD and XFS.
> If IIRC (some freebsd p
Thanks in advance,
I have a situation where i have to make my client synchronize their entries
made in the database locally with the database in the server and viceversa.
Is there any stable application on this. I use postgresql 7.4.1 version
Lakshmi Narayanan
---(end o
Also, if you don't need an exact moving average, you might consider a
weighted mean. Something like:
mean = mean * 0.9 + new_value * 0.1
Much easier to maintain than a moving average.
On Thu, Jan 20, 2005 at 08:40:24PM -0800, Dann Corbit wrote:
> Why not use a cursor?
>
>
>
> P.S.
>
> A mov
Title: Message
Why not use a cursor?
P.S.
A moving average will look much better if
you Hahn the tails.
To do a normal 7 point moving average, you take (x[i]+ x[i+1]+ x[i+2]+ x[i+3]+ x[i+4]+
x[i+5]+ x[i+6])/7 as point xprime[i] and (y[i]+ y[i+1]+ y[i+2]+ y[i+3]+ y[i+4]+
y[i+5]+ y[i+6
On 1/20/05 10:27 PM, "Jonel Rienton" <[EMAIL PROTECTED]> wrote:
> have you tried using /etc/sysctl.conf and saving the shmax value there?
Unfortunately, the -p parameter does not appear to be valid, nor does
'strings -a' show 'conf' in the binary (unlike the RedHat sysctl).
Wes
--
have you tried using /etc/sysctl.conf and saving the shmax value there?
On Thu, 20 Jan 2005 21:51:02 -0600, Wes wrote
> The problem with not being able to set shmmax and shmall in a
> startup script in Mac OS X is not that you are setting them too late
> in the boot process. It is that you can s
[EMAIL PROTECTED] writes:
> I have a table that gets a column added to it for every insert on another
> table.
I think you're going to run into a lot of problems with something like that.
Perhaps you should describe the original problem you're trying to solve and
people would be able to suggest
Hi
Often I find myself
working in a query where I need to select one or two fields from source
table A
as renamed objects (
usually to prevent name duplication with other selected fields from another
joined
source table B ) and
then to also select all the remaining fields from source ta
Mike Cox wrote:
> PostgreSQL 8.0 will be released on Wednesday, Jan 19, 2005. As of
> today, there were 775 people who said they would like a PostgreSQL
> newsgroup in a web poll. See the results here:
>
> http://www.postgresql.org/community/survey.36 .
>
> PostgreSQL 8.0 is a milestone release.
I am having the same problem:
System: the released Postgres 8.0, winXP
Install performed an initDB. Tryed all types of backup/restore
combinations, see below:
Using:
pg_dump --format=t --blobs myDB > DBFile
pg_restore --create -dbname=crm DBFile
Resulted in:
pg_restore: [archiver] unsupported ve
Hi all;
I have recently contributed a wiki to another open source project
(SQL-Ledger) and have received a fair bit of positive feedback and
assistance in getting it going. After reading a lot of the discussion
on Slashdot concerning the 8.0 release, it occurred to me that a wiki
might be a go
Title: Message
Hi,
I need to calculate
a moving average and I would like to do it with SQL, or a Pg function built for
this purpose. I'm on Pg 7.4. Is this possible in Pg without a bunch of self
joins, or is there a funtion available?
Thanks,
Mike
More Info:
If I perform a backup of my database with PGAdmin3. I can restore
the database via the command line pg_restore. It seems as if the
backup created with pg_restore when issued from a winXP command prompt
does not create a file that the pg_restore can read... At least for the
file types C
My friend started a small e-learning company and asked
me to develop the IT solution. The company is now 5
years old and postgresql has been in use for the last
4 years. In the past 4 years NOT ONCE has postgresql
crashed on us. We have had times when the server
utilization was at 100% and swap was
On Wed, 19 Jan 2005, Martijn van Oosterhout wrote:
On Wed, Jan 19, 2005 at 12:20:23PM +0100, Marco Colombo wrote:
I think you're missing that vendors define what a 'text file' is on their
platform, not Guido. Guido just says that a Python program is a text file,
which is a very sound decision, sinc
Alle 14:38, martedì 18 gennaio 2005, Lonni J Friedman ha scritto:
> On Tue, 18 Jan 2005 11:12:34 +0100, [EMAIL PROTECTED]
>
> <[EMAIL PROTECTED]> wrote:
> > At office we have a Win2k LAN to which my freebsd postgresql server box
> > is connected via Samba. On this box I have a script, called 'crono
I've runned your test: 3304 ms (7200 rpm hard disk, pentium3 1Ghz).
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
hi,
> am new to Perl.
> How to connect postgresql database with perl ? here
>is the Perl code follows:
> #!/usr/bin/perl
> use CGI qw(:standard);
> use DBI;
> use strict;
>
> print "Content-type: text/html\n\n";
> use CGI::Carp qw/fatalsToBrowser/;
> $query = new CGI;
> print $query->head
Hi,
You need to create you database with an enconding like LATIN1:
createdb -E latin1 mydb
Alexandre
Juan Jose Siles Salinas wrote:
Cuando subo la base de datos con pg_restore -d mydb < mydb.tar
restablece toda la informacion pero los acentos y ñ muestran caracteres
en otra codificacion como pue
Alle 14:38, martedì 18 gennaio 2005, Lonni J Friedman ha scritto:
> On Tue, 18 Jan 2005 11:12:34 +0100, [EMAIL PROTECTED]
>
> <[EMAIL PROTECTED]> wrote:
> > At office we have a Win2k LAN to which my freebsd postgresql server box
> > is connected via Samba. On this box I have a script, called 'crono
The problem with not being able to set shmmax and shmall in a startup script
in Mac OS X is not that you are setting them too late in the boot process.
It is that you can set them only once. In fact, you can set them from a
terminal window after booting and logging in - as long as they haven't
alr
[EMAIL PROTECTED] wrote:
Does it have to be linux? I've never had as much success with PostGresql on
linux as i have on FreeBSD 5.3
For XFS? I don't think you are going to have with FreeBSD and XFS.
If IIRC (some freebsd person please chime in) that is one thing
that Linux has over FreeBSD whic
David Garamond wrote:
Joshua D. Drake wrote:
Well that isnt exactly true. EXT3 is a bolt on to EXT2 which was always
there. Reiser is also a long time kernel at least from 2.2.
I remember first using reiser3 by patching early 2.4 kernels. IIRC,
reiser was not in linus tree until 2.4.7 or so (not
Oluwatope Akinniyi wrote:
Hi,
Do we have a Windows version of plPHP?
No not currently.
Sincerely,
Joshua D. Drake
Best regards.
Tope.
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564
Does it have to be linux? I've never had as much success with PostGresql on
linux as i have on FreeBSD 5.3
matt
Quoting David Garamond <[EMAIL PROTECTED]>:
> Joshua D. Drake wrote:
> > Well that isnt exactly true. EXT3 is a bolt on to EXT2 which was always
> > there. Reiser is also a long time
Joshua D. Drake wrote:
Well that isnt exactly true. EXT3 is a bolt on to EXT2 which was always
there. Reiser is also a long time kernel at least from 2.2.
I remember first using reiser3 by patching early 2.4 kernels. IIRC,
reiser was not in linus tree until 2.4.7 or so (not sure which release)
a
I have a table that gets a column added to it for every insert on another table.
the general form of these columns are g_c_i_avg where i is the unique
identifyer for the insert that caused the column to be added. I need to use this
column to calculate a new value for another column in the same t
Hello Steve,
El 20/01/2005 5:20 PM, Steve Crawford en su mensaje escribio:
select
zert_title as TITULO,
sum(case when epr_mes=200309 then epr_valor else 0 end) as "200309",
sum(case when epr_mes=200310 then epr_valor else 0 end) as "200310",
sum(case when epr_mes=200311 then epr_valor else
Hi,
Do we have a Windows version of plPHP?
Best regards.
Tope.
--
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can ge
> I have a table that contains this raw data:
>
> epr_procode | epr_tipo | epr_mes | epr_valor | zert_title
> -+--+-+---+
>-- 00C188 | VTA | 200309 | 2116. | Venta
> 00C188 | CTO | 200309 | 1600.0700 | Costo
Hello list,
I have a table that contains this raw data:
epr_procode | epr_tipo | epr_mes | epr_valor | zert_title
-+--+-+---+--
00C188 | VTA | 200309 | 2116. | Venta
00C188 | CTO | 200309 | 1600.0700 | Costo
On Thu, 20 Jan 2005 14:48:40 +0100, Alban Hertroys
<[EMAIL PROTECTED]> wrote:
> I'm trying to insert a record that contains an ô (o circumflex) into a
> table using the psql client.
> I also tried with phppgadmin and pgadmin, but both can't do this. They
> insert a HTML entity and error out respect
Marek Lewczuk wrote:
fryk napisaÅ(a):
Hi,
How to set such variable after (during?) client connection (PHP)?
I want to use it in view - so view could depends on it:
If I could set client's variable i.e. MY_VAR='hello' then I could do
something like this:
CREATE VIEW my_view AS SELECT * FROM pg_table
Am Donnerstag, den 20.01.2005, 06:09 -0800 schrieb J. Greenlees:
> Tino Wildenhain wrote:
> > Hi,
> >
> > Am Mittwoch, den 19.01.2005, 15:02 -0800 schrieb J. Greenlees:
> >
> >>Roman Neuhauser wrote:
> >>
> >>># [EMAIL PROTECTED] / 2005-01-20 01:35:32 +1100:
> >>>
> >>>
> i have a unique inde
Yes.
I was wrong.
Sorry about the noise.
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 20, 2005 12:01 PM
To: Dann Corbit
Cc: Tom Lane; Greg Stark; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Unique Index
On Thu, 20 Jan 2005, Dann Corbi
On Thu, 20 Jan 2005, Dann Corbit wrote:
> Would the constraint not be satisfied if each combination (including
> NULL) were not also forced to be unique?
The constraint would be satisfied, however cases that the constraint is
satisfied for would not be allowed. The case I gave below is one for
w
"Dann Corbit" <[EMAIL PROTECTED]> writes:
> Would the constraint not be satisfied if each combination (including
> NULL) were not also forced to be unique?
>
> I maintain that the constraint is still satisfied.
>
> So, it is satisfied if I stuff thousands of NULL values in there.
>
> And it is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Huh?
... the value of EACH COLUMN in one row is NOT NULL and IS EQUAL to ...
In order for values to be equal in SQL, neither one can be null. For
this condition to hold, it is more than "clear" that at least one row
must contain *NO* *NULL* *VALUES*
Would the constraint not be satisfied if each combination (including
NULL) were not also forced to be unique?
I maintain that the constraint is still satisfied.
So, it is satisfied if I stuff thousands of NULL values in there.
And it is satisfied if I only allow a single NULL value.
With multip
On Thu, 20 Jan 2005, Dann Corbit wrote:
> It is clear to me that only allowing a single null value will not
> violate the explanation below.
Given two rows in T with one column each
(NULL), (NULL)
Find two rows such that the value of each column in one row is non-null
and equal to the value of
fryk napisaÅ(a):
Hi,
How to set such variable after (during?) client connection (PHP)?
I want to use it in view - so view could depends on it:
If I could set client's variable i.e. MY_VAR='hello' then I could do
something like this:
CREATE VIEW my_view AS SELECT * FROM pg_tables WHERE tablename ~*
It is clear to me that only allowing a single null value will not
violate the explanation below.
It would be equally true that allowing multiple null values would not
violate it.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Thursday, Jan
Hi,
How to set such variable after (during?) client connection (PHP)?
I want to use it in view - so view could depends on it:
If I could set client's variable i.e. MY_VAR='hello' then I could do
something like this:
CREATE VIEW my_view AS SELECT * FROM pg_tables WHERE tablename ~* (SELECT
MY_VA
Are there any 'pen tests' that one could run that checks the security
of your Postgresql instance? I don't think postgresql has any default
accounts except for 'postgres' but maybe something that scans for
blank passwords and things like that.
thanks!
~ Troyston Campano ~
---
"Frank D. Engel, Jr." <[EMAIL PROTECTED]> writes:
> I'm sure this won't work for some reason, but something similar might; why not
> create a unique index on a constant where all three are null; something along
> these lines (in addition to the others):
>
> CREATE UNIQUE INDEX foo_trio_index ON f
On Thu, 2005-01-20 at 14:14 +, Jackson Pauls wrote:
> i'm trying to create a connection from a postgres 8.0.0 client to a
> remote server running postgres 7.4.6 that requires ssl.
>
> this connection worked on the client machine when connecting using a
> 7.4.6 postgres client, and still works
On Thu, 2005-01-20 at 06:58, Troyston Campano wrote:
> I guess what I am concerned about *is* running on a production server more
> than a test server. Basically, I'd be taking a couple applications that are
> running on the Oracle database instance, building a Postgresql instance, and
> migrating
> Are there any issues running Postgresql and Oracle on the same
> machine.anything special to know about memory, disk layout, and things
> like
> that? I just want to make sure the two engines play together on this
> same
> server. I had a hard time finding information about this via google.
We cu
On Wed, 2005-01-19 at 23:03, Troyston Campano wrote:
> Hello,
>
> I am an Oracle DBA and I want do a Postgresql âproof of conceptâ at
> the large corporation where I work to test the benefits of using
> Postgresql in our environment. I want to install Postgresql onto a
> âproductionâ server that
On Wed, 2005-01-19 at 22:20, Alex wrote:
>
> Maybe there could be an option in the creation of the index to indicate
> on how to use NULL values.
>
> How do other DBMS handle this?
http://troels.arvin.dk/db/rdbms/
---(end of broadcast)---
TIP 9:
It depends how you have your Oracle instance configured. If you have
it set up so that the total SGA and UGA ammount consume around 80%-90%
of total available memory, then this is obviously only going to leave
postgress with 20% or less of the total available memory. Postgres is
also designed to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm sure this won't work for some reason, but something similar might;
why not create a unique index on a constant where all three are null;
something along these lines (in addition to the others):
CREATE UNIQUE INDEX foo_trio_index ON foo (1) WHERE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Does anyone know if there could be a shared memory issue here?
If there is, then one of the two (postgres or oracle) would simply
refuse to start (it would quit with an error, I'd assume). If this
happens, you would need to either decrease the number
Dawid Kuroczko <[EMAIL PROTECTED]> writes:
> Don't worry about "index bloat". These additional indexes will be used
> only when your main (foo_abc_index) is not used, so there won't be
> any duplicate data in them.
The main index will have _all_ the tuples in them, even where some of the
columns
Greg Stark <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> writes:
>> Not for UNIQUE constraints. SQL92 section 4.10 "Integrity constraints":
>>
>> A unique constraint is satisfied if and only if no two rows in
>> a table have the same non-null values in the unique columns.
> That's
Tom Lane <[EMAIL PROTECTED]> writes:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > Tom Lane <[EMAIL PROTECTED]> writes:
> >> Direct your complaints to the ISO SQL standards committee.
>
> > The SQL standard generally treats NULLs as a escape hatch for constraints.
Huh? I thought I was agreeing wi
I'm not really too concerned about the migration aspect at all. If
need be, we might even throw in some new applications into the
postgresql database. What we're really concerned about is any issues
that may come from running postgresql and oracle on the same box. Do
they play nice together...or do
Hello, all. I have a query that runs perfectly when I run it from
pgAdmin3, but bombs when I run it from ColdFusion using the JDBC
driver. I'm using postgres 7.4. The query uses dblink(), which I assume
is the source of the problem.
Can anyone provide me with any insight about why this would fa
On Thu, Jan 20, 2005 at 02:48:40PM +0100, Alban Hertroys wrote:
> I'm trying to insert a record that contains an ô (o circumflex) into a
> table using the psql client.
> I also tried with phppgadmin and pgadmin, but both can't do this. They
> insert a HTML entity and error out respectively. Not w
^
Is there any evidence of the above claim? I've seen a link to a l-k
bug report about ext3, but apparently it was totally unconfirmed
(and a single bug does not mean a FS is not good - I remember XFS
being hammered heavily before being accepted into Li
[ Cc: list cleaned a bit ]
On Thu, 20 Jan 2005, Alvaro Herrera wrote:
On Thu, Jan 20, 2005 at 08:03:42AM -0500, Troyston Campano wrote:
Basically, we want to take 3 of the 10 applications running on Oracle, move
them to Postgresql on the same computer/server and just make sure it runs
about the sam
Server Box ():
Pentium 3
FreeBSD 5.3
Samba 3.0.7
connection to a windows 2000 LAN
Samba on the freebsd side has the following smb.conf:
[global]
workgroup = MYCO
#
server string = VicBSD
load printers = no
log file = /va
DISMISS MY MESSAGE
Of course, it was a "slip of the tangue"!
Sorry to bother this esteemed ng.
Vittorio
:-- Messaggio originale --
:Date: Thu, 20 Jan 2005 15:10:45 +0100
:From: [EMAIL PROTECTED]
:To: "FreeBSD" ,
: "postgresql"
:Subject: Samba not showing public share et al.
:
:
:Server B
hi,
i'm trying to create a connection from a postgres 8.0.0 client to a
remote server running postgres 7.4.6 that requires ssl.
this connection worked on the client machine when connecting using a
7.4.6 postgres client, and still works when connecting from a 3rd
machine with 7.4.6. so i think tha
Tino Wildenhain wrote:
Hi,
Am Mittwoch, den 19.01.2005, 15:02 -0800 schrieb J. Greenlees:
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2005-01-20 01:35:32 +1100:
i have a unique index on a table over multiple columns. If now one of
the records has a null value in one of the indexed columns i can
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I think you forget the origins of the XFS filesystem. XFS was
originally created for SGI's IRIX operating system, and specifically
designed for handling large files and filesystems at high speeds. It
is very fast, and quite well tested: it was in h
I'm trying to insert a record that contains an ô (o circumflex) into a
table using the psql client.
I also tried with phppgadmin and pgadmin, but both can't do this. They
insert a HTML entity and error out respectively. Not what I had in mind...
Supposedly I should be able to type:
INSERT INTO t
Jiří Němec wrote:
Hello all,
I wrote a function which counts price of product from retail price and
discount. It works. But I need to count price with tax of same
product. The best way is to use counted price and add only a tax. I
would like to do by this way:
SELECT count_price(retail, discount) A
On Thu, Jan 20, 2005 at 08:03:42AM -0500, Troyston Campano wrote:
> Basically, we want to take 3 of the 10 applications running on Oracle, move
> them to Postgresql on the same computer/server and just make sure it runs
> about the same (really speed, memory usage, and space are the big issues).
>
what should i put in /etc/pam.d/postgresql ?
i dont know how works pam, i'll read about it, but not enough time for
now, i added theses lines to /etc/pam.d/postgresql file:
authrequiredpam_unix.so nullok_secure
account requiredpam_unix.so
it works, auth via my unix users, is
Hello all,
I wrote a function which counts price of product from retail price and
discount. It works. But I need to count price with tax of same
product. The best way is to use counted price and add only a tax. I
would like to do by this way:
SELECT count_price(retail, discount) AS price, count_p
Greg Stark <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> writes:
>> Direct your complaints to the ISO SQL standards committee.
> The SQL standard generally treats NULLs as a escape hatch for constraints.
Not for UNIQUE constraints. SQL92 section 4.10 "Integrity constraints":
Basically, we want to take 3 of the 10 applications running on Oracle, move
them to Postgresql on the same computer/server and just make sure it runs
about the same (really speed, memory usage, and space are the big issues).
I'm not concerned with how hard the migration will be and things like that
I guess what I am concerned about *is* running on a production server more
than a test server. Basically, I'd be taking a couple applications that are
running on the Oracle database instance, building a Postgresql instance, and
migrating them to that postgresql database instance. I'm just wondering
On Thu, Jan 20, 2005 at 04:32:37PM +0900, Michael Glaesemann wrote:
>
> On Jan 20, 2005, at 16:03, David Garamond wrote:
>
> >Dann Corbit wrote:
> >>True, but the standard says nothing about the creation of an index, so
> >>you can make it behave in any way that you see fit.
> >
> >But I thought
Alle 10:09, giovedì 20 gennaio 2005, Bruno Almeida do Lago ha scritto:
> I still opt for Slackware simplicity and stability. Nothing better than a
> well configured Slackware box with XFS file system and PostgreSQL! =)
>
> C Ya,
> Bruno
For a generic use of postgresql, binary packages in any linu
On Wed, Jan 19, 2005 at 07:06:49PM -0500, Frank D. Engel, Jr. wrote:
> Uh, does the Python doc specify "platform" line endings, or "normal
> (\n)" line endings? It sounded to me like it always wanted the
> UNIX-style \n line endings, so that using those would result in
> portability...
That's
I think the filesystem you choose depends what you are looking for.
Ext3 is by far the most tested and most stable out the file systems
available. It is basically just ext2 with journalling stuck on top
(and a few other niceities). XFS may well be faster but is perhaps not
so well tested or as stab
On Thu, 20 Jan 2005 [EMAIL PROTECTED] wrote:
Troyston Campano <[EMAIL PROTECTED]> wrote on 20.01.2005,
06:03:28:
I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the
large corporation where I work to test the benefits of using Postgresql in
our environment. I want to install Post
On Wed, 19 Jan 2005, Joshua D. Drake wrote:
Martijn van Oosterhout wrote:
No difference whatsoever from PostgreSQL's point of view. Use whichever
distribution is easiest for you to administer. After all, there's no
point installing Postgres on a machine you don't know how to maintain
or tune :)
Act
I still opt for Slackware simplicity and stability. Nothing better than a
well configured Slackware box with XFS file system and PostgreSQL! =)
C Ya,
Bruno
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ron Mayer
Sent: Wednesday, January 19, 2005 3:3
Troyston Campano <[EMAIL PROTECTED]> wrote on 20.01.2005,
06:03:28:
> I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the
> large corporation where I work to test the benefits of using Postgresql in
> our environment. I want to install Postgresql onto a "production" server
> th
On Thu, 20 Jan 2005 15:20:26 +1100, Alex <[EMAIL PROTECTED]> wrote:
> I actually just wanted to know if there is a way around this problem.
> Obviously it is implemented that way for whatever reason.
Well, if you really need it, partial indexes are your friends! :)
For clarity, let's say you have
On Wed, Jan 19, 2005 at 06:07:24PM +0100, Hans-Michael Stahl wrote:
> It is from a very large production example. I have to work a bit to trim
> this down to a small example. I'llt try to provide an example. I now
> also remember that the problem *only* occurs with dynamically prepared
> statem
On Thu, 20 Jan 2005 00:03:28 -0500, Troyston Campano
<[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the
> large corporation where I work to test the benefits of using Postgresql in
> our environment. I want to install Postgresql onto
95 matches
Mail list logo
