On Tue, Jan 22, 2008 at 11:52:08AM +, cinu wrote:
> Even though these errors are existing, at the end the
> latest version is getting downloaded and when I do a
> regression testing it goes through. Can anyone give me
Regression tests have to test error handling too, so some errors might
exac
On 22 jan, 22:46, [EMAIL PROTECTED] ("Jamiil Abduqadir") wrote:
> I am trying to install PosgreSQL using postgresql-8.3-dev1 on my WindowsXP
> machine, but I get a message that reads
>
> Fail to create a temporary directory
>
> Does anyone know why I am getting this error message?
>
> Thank in adva
On 1/23/08, Luis Alberto Pérez Paz <[EMAIL PROTECTED]> wrote:
> I'm working in a project which is using postgres (great database!, I love
> it)
>
> We're in a stage where I need to implement a mechanism to prevent the data
> modification.
>
> I'm thinking on 'Digital Signatures' (maybe RSA) in each
On 22 jan, 05:02, [EMAIL PROTECTED] (Julio Cesar
Sánchez González) wrote:
> Jon Hancock wrote:
> > The INSTALL file for postgresql 8.3rc1 lists the following install
> > instructions:
>
> > ./configure
> > gmake
> > su
> > gmake install
> > adduser postgres
> > mkdir /usr/local/pgsql/data
> > chown
I'm working with someone who is about to upgrade from (I believe) pg 7.4
to pg 8.1.
What would be the best resource to read to look for "gotchas"? Release
notes? At the moment, we don't care about performance problems, only
things that might break.
---(end of broa
Am 2008-01-18 16:54:17, schrieb Hannes Dorbath:
> Sean Davis wrote:
> >150-200MB/s writing and somewhat faster for reading
>
> That actually seems dead slow. Whatever RAID level you configured, there
> is no sane way for it to be that slow. Is this a RAID 5/6 array? Did you
> forgot to align you
hello everybody:
im trying to reconfigure a warm-standby server. the problem is that
for some reason, one day the standby server stopped recovering the
archives. this leaded to a full disk on that server, so i turned off
(commented) the archive_command on the main server.
i want to restart the pr
Rick Schumeyer <[EMAIL PROTECTED]> writes:
> I'm working with someone who is about to upgrade from (I believe) pg 7.4
> to pg 8.1.
> What would be the best resource to read to look for "gotchas"? Release
> notes? At the moment, we don't care about performance problems, only
> things that migh
Erik Jones wrote:
On Jan 10, 2008, at 6:01 AM, Simon Riggs wrote:
On Thu, 2008-01-10 at 11:18 +0100, Gábor Farkas wrote:
Simon Riggs wrote:
also, even if it is wrong, can an 'idle-in-transaction' connection
that
was opened today block the vacuuming of rows that were deleted
yesterday?
Y
Tom Lane wrote:
Rick Schumeyer <[EMAIL PROTECTED]> writes:
I'm working with someone who is about to upgrade from (I believe) pg 7.4
to pg 8.1.
What would be the best resource to read to look for "gotchas"? Release
notes? At the moment, we don't care about performance problems, on
=?ISO-8859-1?Q?G=E1bor_Farkas?= <[EMAIL PROTECTED]> writes:
> and this is still a mystery for me, because i understand that
> idle-in-transaction is wrong, but even so, a process that i start today,
> in my opinion simply cannot block the recovery of dead rows, that were
> deleted yesterday.
We
On Jan 23, 2008, at 9:28 AM, Roberto Scattini wrote:
hello everybody:
im trying to reconfigure a warm-standby server. the problem is that
for some reason, one day the standby server stopped recovering the
archives. this leaded to a full disk on that server, so i turned off
(commented) the arch
On Jan 23, 2008, at 10:26 AM, Tom Lane wrote:
Reading the release notes is good, but you really really should test
the
application(s) against a test 8.1 installation before you go live ...
be sure to run *every* query your system uses through 8.1. the most
common problems you will run in
We're in a stage where I need to implement a mechanism to prevent the
data modification.
I'm thinking on 'Digital Signatures' (maybe RSA) in each row. If
there's a modification, the signature doesn't verify.
Like all such solutions, the key (lame pun intended) is how to do you
manage the key
Vivek Khera <[EMAIL PROTECTED]> writes:
> On Jan 23, 2008, at 10:26 AM, Tom Lane wrote:
>> Reading the release notes is good, but you really really should test
>> the
>> application(s) against a test 8.1 installation before you go live ...
> be sure to run *every* query your system uses through
Rick Schumeyer wrote:
Tom Lane wrote:
Rick Schumeyer <[EMAIL PROTECTED]> writes:
I'm working with someone who is about to upgrade from (I believe) pg
7.4 to pg 8.1.
What would be the best resource to read to look for "gotchas"?
Release notes? At the moment, we don't care about per
Very interesting point of view.
Yes, you're right about the manage key problem.
The grant database access looks like a real solution.
Thanks a lot for your advice.
Best Regards,
Luis Alberto Perez Paz
On Jan 23, 2008 11:20 AM, David Wall <[EMAIL PROTECTED]> wrote:
>
> > We're in a stage wher
I have a table with four columns that will either be null or hold the value
'true'.
I want to obtain the count of these columns, within a particular row, that
have 'true' as a value (0 to 4).
I have attempted the Select count method but it seems that I need something
more.
If anyone has an
Steve Crawford wrote:
BTW, why not upgrade to the latest version?
Cheers,
Steve
Mostly because its not my server :-) I've suggested that, we'll see.
I appreciate the comments regarding type casting. I'll be sure to look
out for that.
---(end of broadcast)
Bob Pawley wrote:
I have a table with four columns that will either be null or hold the
value 'true'.
I want to obtain the count of these columns, within a particular row,
that have 'true' as a value (0 to 4).
I have attempted the Select count method but it seems that I need
something more.
Hi all
I interesting in the protect my applications that use postgresql as is
database backend from Sql Injections attacks, can any recommend me best
pratices or references to protected postgres from this kind of malicious
users.
Thanks in advanced
José Manuel, Gutíerrez de la Concha Martínez.
On Wed, 2008-01-23 at 10:50 -0800, Bob Pawley wrote:
> I have a table with four columns that will either be null or hold the value
> 'true'.
>
> I want to obtain the count of these columns, within a particular row, that
> have 'true' as a value (0 to 4).
>
> I have attempted the Select count me
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Bob Pawley
> Sent: 23 janvier 2008 13:51
> To: PostgreSQL
> Subject: [GENERAL] Count
>
>
> I have a table with four columns that will either be null or hold the
value
> 'true'.
>
> I want to obtain the coun
Hello everybody. I hope your week's going well so far.
I built our data mine in postgreSQL around 3 months ago and I've been
working with it since. Postgres is great and I'm really enjoying it, but
I've hit a bit of a hitch. Originally (and against pgAdmin's good
advice, duh!) I set up the dat
On 1/23/08, Luis Alberto Pérez Paz <[EMAIL PROTECTED]> wrote:
> Very interesting point of view.
> Yes, you're right about the manage key problem.
>
> The grant database access looks like a real solution.
Eh, for some reason I imagined you have have some good reason
why simple solutions are not eno
Bob Pawley wrote:
I have a table with four columns that will either be null or hold the
value 'true'.
Any reason why the NULL values aren't instead FALSE? NULL != FALSE.
I want to obtain the count of these columns, within a particular row,
that have 'true' as a value (0 to 4).
SELECT
(C
pepone.onrez wrote:
Hi all
I interesting in the protect my applications that use postgresql as is
database backend from Sql Injections attacks, can any recommend me
best pratices or references to protected postgres from this kind of
malicious users.
Thanks in advanced
José Manuel, Gutíerrez
On Jan 23, 2008, at 2:18 PM, Roberto Scattini wrote:
On Jan 23, 2008 2:28 PM, Erik Jones <[EMAIL PROTECTED]> wrote:
You don't. The main server should not be keeping archived WAL files
directly in pg_xlog/. As it queues WAL files to be archived it puts
them in pg_xlog/archive_status/ with fi
pepone.onrez wrote:
Hi all
I interesting in the protect my applications that use postgresql as is
database backend from Sql Injections attacks, can any recommend me best
pratices or references to protected postgres from this kind of malicious
users.
What are you using on the application side?
On Jan 23, 2008 2:28 PM, Erik Jones <[EMAIL PROTECTED]> wrote:
>
> You don't. The main server should not be keeping archived WAL files
> directly in pg_xlog/. As it queues WAL files to be archived it puts
> them in pg_xlog/archive_status/ with file names suffixed with .ready,
> once they are arch
In response to pepone.onrez <[EMAIL PROTECTED]>:
> Hi all
>
> I interesting in the protect my applications that use postgresql as is
> database backend from Sql Injections attacks, can any recommend me best
> pratices or references to protected postgres from this kind of malicious
> users.
http:
I didn't see this come through the first time, so I'm retrying. I
apologize if this comes through twice.
--
Hello everybody. I hope your week's going well so far.
I built our data mine in postgreSQL around 3 months ago and I've been
working with it since. Postgres is great and
Tom Hart wrote:
Hello everybody. I hope your week's going well so far.
I built our data mine in postgreSQL around 3 months ago and I've been
working with it since. Postgres is great and I'm really enjoying it,
but I've hit a bit of a hitch. Originally (and against pgAdmin's good
advice, duh!)
Tommy Gildseth wrote:
Tom Hart wrote:
Hello everybody. I hope your week's going well so far.
I built our data mine in postgreSQL around 3 months ago and I've been
working with it since. Postgres is great and I'm really enjoying it,
but I've hit a bit of a hitch. Originally (and against pgAdmi
"pepone.onrez" <[EMAIL PROTECTED]> writes:
> Hi all
>
> I interesting in the protect my applications that use postgresql as is
> database backend from Sql Injections attacks, can any recommend me best
> pratices or references to protected postgres from this kind of malicious
> users.
I strongly u
On Wed, 2008-01-23 at 18:18 -0200, Roberto Scattini wrote:
> the standby server had filled his disk with archives
> received but not proccesed
Sounds like your standby has fallen badly behind. You should always
monitor the lag between primary and standby.
You will need to take steps to ensure th
Thanks all you, i will use prepared queries for all my functions after now.
BTW i using Qt-4 postgres drivers from c++ not php. I launch this question
because i read that each day more are more applications are compromised with
this class of attacks.
Thanks again.
On Jan 23, 2008 9:45 PM, brian
Tommy Gildseth wrote:
Tom Hart wrote:
Hello everybody. I hope your week's going well so far.
I built our data mine in postgreSQL around 3 months ago and I've been
working with it since. Postgres is great and I'm really enjoying it,
but I've hit a bit of a hitch. Originally (and against pgAdmi
Tom Hart <[EMAIL PROTECTED]> writes:
> Tommy Gildseth wrote:
>> Try editing your dump-file and change the line which reads "SET
>> client_encoding = 'SQL_ASCII';" to "SET client_encoding = 'LATIN1';"
>>
> I tried making the changes you specified with notepad, wordpad, gVim,
> vim and emacs and i
Martin Gainty wrote:
character encoding is implemented at Database level not the table
http://www.postgresql.org/docs/8.2/interactive/sql-createdatabase.html
CREATE DATABASE name
[ [ WITH ] [ OWNER [=] dbowner ] [ TEMPLATE [=] template ]
[ ENCODING [=] encoding ]
Tom Hart <[EMAIL PROTECTED]> writes:
> Also, it's taking around an hour and a half for a message to go from my
> computer to being posted on the list. Is there a problem with the
> mailing list software?
Yeah, every so often the PG mail servers get kinda clogged up.
I pinged Marc about this inst
Hello,
How do i find the constraints on a table in SQL? my database is linux
based, and I cant seem to find the command. Thanks
On 24/01/2008 00:09, Dominique Bessette - Halsema wrote:
How do i find the constraints on a table in SQL? my database is linux
based, and I cant seem to find the command. Thanks
In psql,
\d
will show the constraints.
Ray.
---
On Wed, 23 Jan 2008, Roberto Scattini wrote:
the problem that im having is that i have A LOT of
archive files on pg_xlog dir, and thats because the archive_command
keeps failing (the standby server had filled his disk with archives
received but not proccesed), so now, i dont know how i can remov
On Wed, 23 Jan 2008 21:34:31 +
Gregory Stark <[EMAIL PROTECTED]> wrote:
> "pepone.onrez" <[EMAIL PROTECTED]> writes:
>
> > Hi all
> >
> > I interesting in the protect my applications that use postgresql
> > as is database backend from Sql Injections attacks, can any
> > recommend me best prat
On Thursday 24. January 2008, Dominique Bessette - Halsema wrote:
>Hello,
>
>How do i find the constraints on a table in SQL? my database is linux
>based, and I cant seem to find the command. Thanks
You should really read the psql documentation:
http://www.postgresql.org/docs/8.2/static/app-psql
Dominique Bessette - Halsema asked:
>
> Hello,
>
> How do i find the constraints on a table in SQL? my database is linux
> based, and I cant seem to find the command. Thanks
>
>From the psql prompt, \d works for me:
billing=# \d work.clients
Table "work.clients"
On Jan 23, 2008 3:34 PM, Gregory Stark <[EMAIL PROTECTED]> wrote:
> "pepone.onrez" <[EMAIL PROTECTED]> writes:
>
> > Hi all
> >
> > I interesting in the protect my applications that use postgresql as is
> > database backend from Sql Injections attacks, can any recommend me best
> > pratices or refe
Is there any real difference between PGCon and Postgresql Conference
East/West or is it the same idea in different places?
My question is actually which people should go to which conference?
Thank you
Sim
---(end of broadcast)---
TIP 4: Have you
49 matches
Mail list logo
