I am using Pgpool II 2.3.3 with Postgresql 8.3.8 in replication mode with
SSL support.
I am facing problem in lob object replication. I found that lobj_lock_table
is required.
What should be the structure of lobj_lock_table?
I'm sorry I have to come back at this, but the solution the list gave helped,
but didn't fully solved my problems...
To sum up:
I have a simple table that has indexes on 2 integer columns.
Data is inserted very often (no updates, no deletes, just inserts): at
least 4000/5000 rows per second.
On Thu, May 6, 2010 at 10:00 PM, AI Rumman rumman...@gmail.com wrote:
I am using Pgpool II 2.3.3 with Postgresql 8.3.8 in replication mode with
SSL support.
I am facing problem in lob object replication. I found that lobj_lock_table
is required.
What should be the structure of
I am using Pgpool II 2.3.3 with Postgresql 8.3.8 in replication mode with
SSL support.
I am facing problem in lob object replication. I found that lobj_lock_table
is required.
What should be the structure of lobj_lock_table?
From the pgpool-II doc:
pgsql pg...@lavabit.com writes:
Tom Lane wrote:
Um, that's not too helpful, we want to see the string it's pointing at.
Sorry about that. All statements are calling one of two pl/pgsql
functions. While that information already helps me a lot, it'll take me
a while to step through the code.
Hi! I was searching for a command like pg_dumpall but with the difference
that I don't want a single file for all databases, i would like to have a
file for each one.
I couldn't fins such command, so the only option I see is to write a shell
script with a loop for all the DBs. The problem is
-- Forwarded message --
From: Nicholas I nicholas.domni...@gmail.com
Date: Wed, May 5, 2010 at 8:35 AM
Subject: help
To: pgsql-...@postgresql.org
Hi,
I have a table in which the data's are entered like,
Example:
One (1)
Two (2)
Three (3)
I want to extract the data which is
-- Forwarded message --
From: Nicholas I nicholas.domni...@gmail.com
Date: Thu, May 6, 2010 at 8:18 PM
Subject: Need a help in regexp
To: pgsql-...@postgresql.org
Hi,
Need a help in regexp!
I have a table in which the data's are entered like,
Example:
One (1)
Two (2)
Three
On 6 May 2010 15:52, Nicholas I nicholas.domni...@gmail.com wrote:
-- Forwarded message --
From: Nicholas I nicholas.domni...@gmail.com
Date: Wed, May 5, 2010 at 8:35 AM
Subject: help
To: pgsql-...@postgresql.org
Hi,
I have a table in which the data's are entered like,
On 6 May 2010 08:57, Jaume Calm ja...@isac.cat wrote:
Hi! I was searching for a command like pg_dumpall but with the difference
that I don’t want a single file for all databases, i would like to have a
file for each one.
I couldn’t fins such command, so the only option I see is to write a
Hi all,
Yesterday I ran into two backend crashes and then an autovacuum launcher
process crash. The autovacuum log was:
LOG: database system is ready to accept connections
LOG: autovacuum launcher process (PID 3788) was terminated by exception
0xC142
HINT: See C include file
On Thu, May 6, 2010 at 3:57 AM, Jaume Calm ja...@isac.cat wrote:
Hi! I was searching for a command like pg_dumpall but with the difference
that I don’t want a single file for all databases, i would like to have a
file for each one.
I couldn’t fins such command, so the only option I see is
On 5/6/2010 2:57 AM, Jaume Calm wrote:
Hi! I was searching for a command like pg_dumpall but with the
difference that I don’t want a single file for all databases, i would
like to have a file for each one.
I couldn’t fins such command, so the only option I see is to write a
shell script with a
On 6 May 2010 16:15, Andy Colson a...@squeakycode.net wrote:
On 5/6/2010 2:57 AM, Jaume Calm wrote:
Hi! I was searching for a command like pg_dumpall but with the
difference that I don’t want a single file for all databases, i would
like to have a file for each one.
I couldn’t fins such
Excerpts from Dave Vitek's message of jue may 06 10:44:34 -0400 2010:
Hi all,
Yesterday I ran into two backend crashes and then an autovacuum launcher
process crash. The autovacuum log was:
LOG: database system is ready to accept connections
LOG: autovacuum launcher process (PID 3788)
On Thu, May 6, 2010 at 17:42, Alvaro Herrera alvhe...@alvh.no-ip.org wrote:
Excerpts from Dave Vitek's message of jue may 06 10:44:34 -0400 2010:
Hi all,
Yesterday I ran into two backend crashes and then an autovacuum launcher
process crash. The autovacuum log was:
LOG: database system is
On 6 May 2010 16:52, Scott Mead scott.m...@enterprisedb.com wrote:
On Thu, May 6, 2010 at 11:30 AM, Thom Brown thombr...@gmail.com wrote:
On 6 May 2010 16:15, Andy Colson a...@squeakycode.net wrote:
On 5/6/2010 2:57 AM, Jaume Calm wrote:
Hi! I was searching for a command like pg_dumpall
On Thu, May 6, 2010 at 11:30 AM, Thom Brown thombr...@gmail.com wrote:
On 6 May 2010 16:15, Andy Colson a...@squeakycode.net wrote:
On 5/6/2010 2:57 AM, Jaume Calm wrote:
Hi! I was searching for a command like pg_dumpall but with the
difference that I don’t want a single file for all
Le 06/05/2010 17:56, Thom Brown a écrit :
On 6 May 2010 16:52, Scott Mead scott.m...@enterprisedb.com wrote:
On Thu, May 6, 2010 at 11:30 AM, Thom Brown thombr...@gmail.com wrote:
On 6 May 2010 16:15, Andy Colson a...@squeakycode.net wrote:
On 5/6/2010 2:57 AM, Jaume Calm wrote:
Hi! I
Dear all -
I am writing function to handle the passwords. Currently the
crypt is being used to store the password in the database. what I need to do
is, when the user wants to change the password, I need to check if that
password is not being used before up to 5 times, If not then
On May 5, 6:16 pm, alvhe...@alvh.no-ip.org (Alvaro Herrera) wrote:
Excerpts from Joshua D. Drake's message of mié may 05 15:37:05 -0400 2010:
On Wed, 2010-05-05 at 09:40 -0700, Nikola wrote:
I looked at the pg_class table and noticed that its size is 1010Mb and
index size is 1137Mb,
Guillaume Lelarge wrote:
And rather than checking the database name, I usually prefer to filter
with datallowconn.
It'll save template1 and postgres, but the script won't give me an error
on template0.
Template databases are labeled as such, so this excludes both template0
and template1
The video archive for the 02/09 SFPUG meeting, Hot Standby and
Streaming Replication, is now available:
http://thebuild.com/blog/2010/05/06/sfpug-hot-standby-and-streaming-replication/
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list
Hi,
I have a query that some values could be NULL, how can I deal with this
problem?
[code]
EXECUTE 'INSERT INTO '
|| quote_ident(pNOME_VIEW)
|| '('
|| quote_ident(pCHAVE_1)
|| ', DAT_INICIO, DAT_FIM, COMENT) values ('
|| quote_literal(pVAL_CHAVE_1)
I'm running into this issue again:
psql --version
psql (PostgreSQL) 8.3.7
COPY items_extended TO '/dev/null';
ERROR: missing chunk number 0 for toast value 25693266 in pg_toast_25497233
Unfortunately, I do not know where these are coming from and I cannot
replicate the data in at least one of
Hi
Null + 1=null.
and
null + 'a' = null.
I expect that pVAL_COMENT is null (as you say).
===
create test environment.
===
create table nulltest (col1 varchar(10),col2 varchar(10));
insert into nulltest (col1,col2) values ('A','B');
insert into
On 7/05/2010 2:31 AM, akp geek wrote:
Dear all -
I am writing function to handle the passwords. Currently
the crypt is being used to store the password in the database. what I
need to do is, when the user wants to change the password, I need to
check if that password is not
On 7/05/2010 12:01 PM, Craig Ringer wrote:
craig= create or replace function extract_salt(text) returns text as $$
craig$ select (regexp_matches($1, E'^(\\$[^\\$]+\\$[^\\$]+)\\$'))[1];
craig$ $$ language sql immutable;
Upon re-reading the pgcrypto documentation I see that this is unnecessary.
Howe, Jeffrey a écrit:
Due to increase in phishing attacks, we are currently working to improve on
the security of all Email Accounts as we periodically review certain
Vincenzo Romanovincenzo.rom...@notorand.it writes:
It sounds either like phishing or like an automated response due to
some
Andre Lopes lopes80an...@gmail.com writes:
I have a query that some values could be NULL, how can I deal with this
problem?
PG 8.4 and up have a function quote_nullable() that would do what I
think you're looking for. On an older version, you could define such a
function for yourself.
30 matches
Mail list logo
