On Wed, 8 Jun 2011 21:07:12 +0200, Isak Hansen wrote:
On Wed, Jun 8, 2011 at 11:43 AM, Radosław Smogura
wrote:
You should actually only consider safty of storing of such passwords
in
database. If with md5 the password isn't digested like in DIGEST
HTTP auth,
and only md5 shortcut is transffe
On Wed, 8 Jun 2011 14:43:16 +0430, Arash pajoohande wrote:
hello
i have a lot of files in microsoft word format. each file consists of
text and images (other text formatting like font is not important).
i want to store this documents in Postgresql, and documents must
display on web page when corr
If you rewrite your function in plperlu , you can store data in shared memory.
2011/6/9, Clemens Schwaighofer :
> Hi,
>
> I have a plpgsql function where I read data from a table in a loop and
> update data in a different table.
>
> Is it possible to see the updated data from a different access du
I can try this, but I have never done anything with plperl yet.
2011/6/9 pasman pasmański :
> If you rewrite your function in plperlu , you can store data in shared memory.
>
> 2011/6/9, Clemens Schwaighofer :
>> Hi,
>>
>> I have a plpgsql function where I read data from a table in a loop and
>> u
On 9/06/2011 2:41 PM, Clemens Schwaighofer wrote:
Hi,
I have a plpgsql function where I read data from a table in a loop and
update data in a different table.
Is it possible to see the updated data from a different access during
the run of this function? Or is this impossible because the functi
Hi,
If anybody have setup this thing earlier or have any idea about how to
setup this, Please let me know. I am newbie in setting up database servers .
Regards,
Sanjay Rao
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.
2011/6/9 Craig Ringer :
> On 9/06/2011 2:41 PM, Clemens Schwaighofer wrote:
>>
>> Hi,
>>
>> I have a plpgsql function where I read data from a table in a loop and
>> update data in a different table.
>>
>> Is it possible to see the updated data from a different access during
>> the run of this func
>on 06/08/11 11:14 PM, Andrea Peri wrote:
>Hi,
>
>
>Is possible the limit the size of an user (quota user) as space allocated
in a tablespace ?
>I don't find this option in the 9.0 version of PG,
>so I think it is not available.
>
>Perhaps it should be possible to simulate it using triggers.
>
>
On Mon, May 16, 2011 at 10:19 AM, Robert Klemme
wrote:
> On Fri, May 13, 2011 at 9:04 PM, Robert Haas
> wrote:
> Separating index and tables might not be a totally good idea
> generally. Richard Foote has an excellent article about Oracle but I
> assume at least a few things do apply to PostgreS
Hi, I have performance issues on very large database(100GB). Reading from
the database is no problem, but writing(or heavy writing) is a nightmare.
I have tried tuning postgresql, but that does not seem to improving the
writing performance.
To improve the write performance, what are my options?
-
In response to Craig Ringer :
> On 09/06/11 03:07, Isak Hansen wrote:
>
> > While MD5 is considered broken for certain applications, it's still
> > perfectly valid for auth purposes.
>
> MD5 rainbow tables can be calculated quickly using services easily
> available to anyone (eg: EC2) and rainbo
2011/6/9 Håvard Wahl Kongsgård :
> To improve the write performance, what are my options?
add more ram. add more checkpoint segments. get faster disks. reduce
the number of indexes you have. split your big tables into smaller
partitions.
which of these may work depends on your exact problem. we
On Thu, Jun 9, 2011 at 4:46 AM, Craig Ringer
wrote:
> On 9/06/2011 2:41 PM, Clemens Schwaighofer wrote:
>>
>> Hi,
>>
>> I have a plpgsql function where I read data from a table in a loop and
>> update data in a different table.
>>
>> Is it possible to see the updated data from a different access d
> Hi, I have performance issues on very large database(100GB). Reading from
> the database is no problem, but writing(or heavy writing) is a nightmare.
> I have tried tuning postgresql, but that does not seem to improving the
> writing performance.
> To improve the write performance, what are my op
Hi,
I have an embedded application retrieving data from a postgres database using
the ECPG client interface. One process acts as an intermediary for other
tasks for r/w operations.
When the the pg interface task retrieves a row into a sql descriptor and
inspects the column types for a decl
Merlin Moncure writes:
> On Thu, Jun 9, 2011 at 4:46 AM, Craig Ringer
> wrote:
>> (as far as I know) It's not possible for a function to see data committed by
>> other transactions since that function began executing, whether or not those
>> other transactions have committed.
> This is not corre
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Andrea Peri
Sent: Thursday, June 09, 2011 6:05 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Adding "quota user limit" using triggers
>on 06/08/11 11:14 PM, Andrea Peri wrote:
>Hi,
>
>
>Is p
On June 9, 2011 05:15:26 AM Håvard Wahl Kongsgård wrote:
> Hi, I have performance issues on very large database(100GB). Reading from
> the database is no problem, but writing(or heavy writing) is a nightmare.
> I have tried tuning postgresql, but that does not seem to improving the
> writing perfor
how to add a replication connection entry in pg_hba.con file ? I am
getting this error at standby server
2011-06-09 20:37:16 IST FATAL: could not connect to the primary server:
FATAL: no pg_hba.conf entry for replication connection from host
"192.168.4.145", user "postgres", SSL off
-Sanj
Le mercredi 08 juin 2011 à 14:43 +0430, Arash pajoohande a écrit :
> and documents must display on web page when corresponding user
> requests occurs.
I wonder why that is? is there any reason you can't just store and serve
the binary content as is, simply letting the proper application (Word in
On 09/06/2011 16:08, Sanjay Rao wrote:
how to add a replication connection entry in pg_hba.con file ? I am
getting this error at standby server
2011-06-09 20:37:16 IST FATAL: could not connect to the primary server:
FATAL: no pg_hba.conf entry for replication connection from host
"192.168.4.145"
Bill Moran Thursday 09 of June 2011 14:44:31
> In response to Craig Ringer :
> > On 09/06/11 03:07, Isak Hansen wrote:
> > > While MD5 is considered broken for certain applications, it's still
> > > perfectly valid for auth purposes.
> >
> > MD5 rainbow tables can be calculated quickly using serv
On Thu, Jun 9, 2011 at 5:46 AM, Craig Ringer
wrote:
> On 09/06/11 03:07, Isak Hansen wrote:
>
>> While MD5 is considered broken for certain applications, it's still
>> perfectly valid for auth purposes.
>
> MD5 rainbow tables can be calculated quickly using services easily
> available to anyone (e
On 06/09/2011 08:15 AM, Håvard Wahl Kongsgård wrote:
Hi, I have performance issues on very large database(100GB). Reading
from the database is no problem, but writing(or heavy writing) is a
nightmare.
I have tried tuning postgresql, but that does not seem to improving
the writing performance.
On 06/09/11 2:45 AM, Sanjay Rao wrote:
Hi,
If anybody have setup this thing earlier or have any idea about how to
setup this, Please let me know. I am newbie in setting up database
servers .
frankly, for high availabilty first thing I'd do would be to take
windows out of the picture, it j
Hello!
I have a code (libpq):
char textbuffer[120];
res = PQexec(conn, "COPY
table_name(\"serial_column",\"int_column",\"bytea_column\") FROM STDIN");
if(PQresultStatus(res) == PGRES_COPY_IN)
{
for(int n=0; n < 10; n++) {
sprintf(textbuffer, "1\t%i\t'text'\n", n);
int copydatares = PQputCopyData
2011/6/9 Tom Lane :
> Merlin Moncure writes:
>> On Thu, Jun 9, 2011 at 4:46 AM, Craig Ringer
>> wrote:
>>> (as far as I know) It's not possible for a function to see data committed by
>>> other transactions since that function began executing, whether or not those
>>> other transactions have comm
Bosco Rama wrote:
> Hey folks,
>
> We're using PG 8.4.7 on two servers that are geographically
> distant from each other. We run WAL-shipping replication
> (i.e. constant recovery mode replication) between the two
> servers. These are the only two servers involved in the
> setup. When we do the
28 matches
Mail list logo
