Hi ,
The 'problem' was remedied to certain extent by increasing
max_standby_streaming_delay=30 # values in milliseconds
I set it to 5 mins which is acceptable to our application.
regds
Rajesh Kumar Mallah.
On Thu, Oct 7, 2010 at 9:55 AM, Rajesh Kumar Mallah
wrote:
> Dear
. Is it possible?
regds
Rajesh Kumar Mallah.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
current_query
--+---
myapp| SELECT application_name,current_query from
pg_stat_activity where application_name='myapp';
(1 row)
t=>
On Thu, Oct 7, 2010 at 11:49 PM, Scott Marlowe wrote:
> On Thu, Oct 7, 2010 at 9:33 PM, Rajesh Kumar
Dear Carlos,
In old version of postgresql attnum colmn of pg_catalog.pg_attribute
system catalog
could be modified to get desired results. I am not sure if it should
be done anymore.
Rajesh Kumar Mallah.
On Wed, Oct 13, 2010 at 2:06 PM, Carlos Mennens
wrote:
> On Wed, Oct 13, 2010 at 2:04
Dear Andrus,
Quick & Dirty Soln:
SELECT * from table where regexp_replace( col , '[-\\s+]' , '' ,
'g') ilike '%search_term%' ;
note above sql will not use any index if you have to search 10000s of
rows use alternate
approaches.
regds
Rajesh Ku
Dear Carlos,
application code should not depend on column positions.
the requirement is not good.
regds
rajesh kumar mallah.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Dear Griper!,
fortunately someone showed a easy 'fix'
ALTER DATABASE foo SET bytea_output='escape' ;
Regds
Rajesh Kumar Mallah.
On Wed, Oct 13, 2010 at 5:03 PM, ljb wrote:
> r...@iol.ie wrote:
>>...
>> In fairness, it *is* flagged in the release note -
Hi,
We have a setup Streaming Replication with max_standby_streaming_delay=120s
if statements are getting canceled with on the standby server with
messages like below:
FATAL: terminating connection due to conflict with recovery
DETAIL: User query might have needed to see row versions that must
Dear List ,
if we simply do select count(*) and not specify any table then it gives 1
eg:
bric=# SELECT count(*) from job ;
count
---
2380
(1 row)
bric=# SELECT count(*) job ;
job
-
1
(1 row)
bric=# SELECT count(*) ;
count
---
1
(1 row)
bric=# SELECT count(*) j
Wed, Mar 9, 2011 at 11:20 PM, Bill Moran wrote:
> In response to Rajesh Kumar Mallah :
>
> > Dear List ,
> >
> > if we simply do select count(*) and not specify any table then it gives 1
> > eg:
> >
> > bric=# SELECT count(*) from job ;
> > count
>
Dear Friends,
While taking online basebackup we ignore tar exit codes of 1 .
However under certain circumstances tar exits we code '2' which
stands for 'Fatal Errors' . Eg in case of "Cannot stat: No such file or
directory"
encountered while taking backup of the pgdatadir . My question is
can we
rds.
Warm Regds
-mallah.
On Tue, Mar 15, 2011 at 1:42 PM, John R Pierce wrote:
> On 03/15/11 12:30 AM, Alban Hertroys wrote:
>
>> On 15 Mar 2011, at 7:46, Alban Hertroys wrote:
>>
>> On 15 Mar 2011, at 3:06, Rajesh Kumar Mallah wrote:
>>>
>>> Dear Fr
can you post output of netstat -lnp when run on the machine
running postgresql server ?
On Tue, Mar 15, 2011 at 9:54 PM, general_lee wrote:
> Hi,
>
> Thanks for the reply.
>
> Nope, not a Firewall problem.
>
> I also get connection refused if I telnet by IP address on the Postgres
> server.
>
> I
Dear List,
There are many opensource applications that support postgresql
(eg , gforge , bricolage , dspam ..) but does not use schemas(namespaces)
as a result of which you are forced to use/create a new database and loose
the
advantage of linking the application data with your existing database.
thanks that sounds like a really easy & neat solution.
On Sun, Sep 13, 2009 at 11:02 PM, Stefan Kaltenbrunner
wrote:
> Rajesh Kumar Mallah wrote:
>
>> Dear List,
>>
>> There are many opensource applications that support postgresql
>> (eg , gforge , bricolage ,
'md56dx' ;
ALTER ROLE pdns SET search_path TO pdns;
in above line the 'pdns' namespace does not exists yet.
regds
Rajesh Kumar Mallah.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
oops! sorry for the noise
it was an innocuous 'NOTICE' not ERROR as claimed.
thanks for your time.
regds
mallah.
On Fri, May 13, 2011 at 7:59 PM, Tom Lane wrote:
> Rajesh Kumar Mallah writes:
>> We migrated to 9.1beta1 from 9.0.x in our development environment.
>&g
Hi ,
Can PostgreSQL run fast ( within 80% of DAS) with iSCSI sotrage
connected via 10GbE ?
regds
mallah.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
range as
compared to the situation
of DAS (Direct Attached Storage). Has anyone tried like this before ?
regds
mallah.
On Thu, Sep 22, 2011 at 9:44 AM, Craig Ringer wrote:
> On 09/22/2011 03:49 AM, Rajesh Kumar Mallah wrote:
>>
>> Hi ,
>>
>> Can PostgreSQL run fast ( wi
Dear List ,
It is been found that the entry
local all all trust
does not renders below redundant in pg_hba.conf
local replication replicator01 trust
regds
mallah.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
setval etc unless the session is
in a transaction
mode . ie they should be preceded by an explicit "BEGIN work;". This shall
immensely help
us to prevent many bugs in the migration.
Is there any way to accomplish that ? Any help shall be greatly appreciated.
regds
Rajesh Kumar Mallah.
A gem it was i just needed that . Thanks! I tested and it serves my purpose.
On Mon, Oct 1, 2012 at 8:54 AM, David Johnston wrote:
> On Sep 30, 2012, at 22:22, Rajesh Kumar Mallah
> wrote:
>
> > Hi ,
> >
> > We are a PerlDBI shop and and are doing a code
insert: rel 1663/16399/303892827; tid 1503/119
LOG: startup process (PID 20693) exited with exit code 1
LOG: terminating any other active server processes
I confess that i have not RT(Fine)M yet .
Regds
Rajesh Kumar Mallah.
pg_last_xlog_replay_location
--
0/200
(1 row)
Regds
Rajesh Kumar Mallah.
Dear Farber,
Is there anything that stops you from upgrading to a more respectable
release number?
Eg 9.0 or at least latest 8.4.X
Regds
Rajesh Kumar Mallah.
or sending the records ?
anticipating your enlightening answers
your respectfully
Rajesh Kumar Mallah.
Dear Masao,
I would also like to inform that i observed the phenomenon only once. And i
am still not
too clear on the correct setup.
Regds
Rajesh Kumar Mallah.
>
> This looks like the bug of HS. But I'm not sure why KnownAssignedXids
> overflowed.
>
> Regards,
>
>
Dear Sai,
Why do you want to update at nite only. You can setup streaming replication
with pgsql9.0 and
have it updated almost instantly.
However if you would want it that way only read about various backup
options in
the link that was provided.
regds
mallah.
On Mon, Oct 4, 2010 at 4:02 PM, Sa
On Tue, Oct 5, 2010 at 12:09 AM, Fujii Masao wrote:
> On Tue, Oct 5, 2010 at 2:57 AM, Rajesh Kumar Mallah
> wrote:
> > I am currently aiming to setup only SR between 2 servers only.
>
> "only SR" means that you don't need Hot Standby (i.e., you don't
Mallah.
On Tue, Oct 5, 2010 at 5:08 AM, Simon Riggs wrote:
> On Sat, 2010-10-02 at 12:02 -0400, Rajesh Kumar Mallah wrote:
> > FATAL: too many KnownAssignedXids
>
> That's a bug.
>
> I've a few guesses about that, but I'll put some better instrumentation
> in t
Dear Rob ,
this will give warning:
SELECT co_name from foo where co_name ilike '%\\_%' limit 10;
and this will not:
SELECT co_name from foo where co_name ilike E'%\\_%' limit 10;
regds
Rajesh Kumar Mallah.
or a database table is missing or corrupt
Regds
Rajesh Kumar Mallah.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
matches '_' in strings.
two backslash is required so that ilike gets \_
it is the rule of quoting literal values in sql.
if you can add E you can get rid of the warnings.
Regds
Rajesh Kumar Mallah.
On Tue, Oct 5, 2010 at 2:18 PM, Rob Richardson
wrote:
> Thank you very much! Your ex
g in these queries
are not frequently updated ones. Can anyone suggest how can we
debug the situation.
Regds
Rajesh Kumar Mallah.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
both servers are on same gigabit switch.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi ,
We have a set of partitioned tables and we run the query on main table
the query is
select uniq_id ,profile_id from general.profile_log where
profile_id=3528336 order by uniq_id desc limit 5;
there is a index on profile_id on the child tables of profile_log. The
query on profile_id does no
Hi,
In 7.4.6 there is only plpgsql under pl where as 7.4.5
includes it in the main distribution
can anyone tell from where plperl for 7.4.6
can be got?
Regds
mallah.
--
regds
Mallah.
Rajesh Kumar Mallah
+---+
| Tradeindia.com (3,11,246) Registered
Jenny Zhang wrote:
Jenny,
although this is old but i find it worth mentioning tom's
comment on it. I hit your comment on facing similar issue.
The cited example is pretty iffy since it assumes that the valid array
entries are all > 0. In recent PG version you can use the array_upper
and array_lo
Greetings!
It is found that pg_dump does not dump function referred in CHECK
constraint definations before dumping the table defination . As a result
the tables
do not get restored due to lack of defined functions.
Is it something that will be worked upon in future ?
regds
mallah.
-
Rajesh Kumar Mallah wrote:
Tom Lane wrote:
It is found that pg_dump does not dump function referred in CHECK
constraint definations before dumping the table defination . As a result
the tables
do not get restored due to lack of defined functions.
Is it something that will be worked upon
t
This is relatively harmless to me at least,
but the point is to have pg_dump work without requiring
any manual editing of the dumpfiles :)
Regds
Mallah.
Rajesh Kumar Mallah wrote:
Rajesh Kumar Mallah wrote:
Tom Lane wrote:
It is found that pg_dump does not dump function referred in CHECK
co
Does postgresql takes advantage of hugetlb feature of
linux kernel 2.6 ?
http://otn.oracle.com/pub/notes/technote_rhel3.html
regds
mallah.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-no
Tom Lane wrote:
<[EMAIL PROTECTED]> writes:
I feel lock_timeout it will be a nice feature . Lemme know what would be
the solution of the above problem from existing set of features.
AFAICS statement_timeout would work just fine for that; or you could
use NOWAIT.
ok, you mean we should p
Hi,
Looks like alter table does not tells about the indexes it dropped
PG version: 7.4.3
Regds
mallah.
tradein_clients=# \d general.membership_status
Table "general.membership_status"
++---++
| Column
?
do you have the database backups?
Regds
Mallah.
Thanks,
Ramesh
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
--
regds
Mallah.
Rajesh Kumar Mallah
broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if
your
joining column's datatypes do not match
--
regds
Mallah.
Rajesh Kumar Mallah
+---+
| Tradeindia.com (3,11,246) Registered
egards,
Christian
---(end of
broadcast)---
TIP 8: explain analyze is your friend
--
regds
Mallah.
Rajesh Kumar Mallah
+---+
| Tradeindia.com (3,11,246) Registered Users |
|
Regds
Mallah.
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
---(end of broadcast)---
T
On Friday 27 Jun 2003 12:14 pm, Tom Lane wrote:
> Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
> > Shudnt' messages like
> > ERROR: value too long for type character varying(5)
> > Indicate which column and table the server is talking about .
>
&
stall 7.4dev soon
and use it to find the improvements.
Regds
Mallah.
>
> regards, tom lane
>
> ---(end of broadcast)---
> TIP 8: explain analyze is your friend
--
Rajesh Kumar Mallah,
Project Manager (Development)
I
On Saturday 28 Jun 2003 8:50 pm, Jan Wieck wrote:
> Rajesh Kumar Mallah wrote:
> > Hi Folks,
> >
> > Shudnt' messages like
> >
> > ERROR: value too long for type character varying(5)
>
> Maybe, yes. It's just not that trivial to do.
>
> &
kay-uwe.genz wrote:
Hi @ all,
i've a little problem with two tables and FOREIGN KEYs. I've read
about this long time ago, but didn't remember me where. Well, I hope
you can help me.
I've create two TABLEs "counties" and "cities". "Countries" have a row
"capital" is REFERENCEd "cities". "citie
Stephan Szabo wrote:
On Mon, 28 Jul 2003, kay-uwe.genz wrote:
i've a little problem with two tables and FOREIGN KEYs. I've read about
this long time ago, but didn't remember me where. Well, I hope you can
help me.
I've create two TABLEs "counties" and "cities". "Countries" have a
Yes i may drop the indexes even , but is it quite usual
to take these work arounds in doing major upgrades.
Regds
Mallah.
Alvaro Herrera wrote:
On Mon, Nov 10, 2003 at 01:36:20AM +0530, Rajesh Kumar Mallah wrote:
PS: i do not want to edit the (splitted) dump file , my
Tom Lane wrote:
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
I face the following problem in transferring data from
pgsql 7.3.4 to pgsql 7.4 RC1 . I am piping the output of
pg_dumpall from 7.3 to 7.4 running on different port.
The problem is there is a gist index on txtidx type on
It did solve my problem
now its dumped like:
SET search_path = archives, pg_catalog;
SET
CREATE INDEX site_search_gist ON site_search USING gist (keywordidx
public.gist_txtidx_ops);
CREATE INDEX
thanks
regds
mallah.
Tom Lane wrote:
Rajesh Kumar Mallah <[EMAIL PROTECTED]>
select ref_code from tab_b where not exists (select * from tab_a where
item_id = tab_b.item_id);
make sure u have index on item_id in tab_a .
the above sql is quite efficient , other method is to use left join.
Alex wrote:
Hi,
I have two tables,
Table A: item_id
Table B: item_id, ref_c
Hi,
We need to implement following logic efficiently.
SELECT * from some_table where [ Query 1 ]
IF rows_matched = 1 THEN
use the single row that matched.
ELSIF
loop thru the results of [Query 1]
END IF;
Currently i am doing select count(*) for getting rows_matched
in
Hi ,
Looks like ADD UNIQUE( some_fuc( some_feild) ) is not supported with add constraint.
the only way is to add the constriant is using UNIQUE INDEX .
Is it a bug or intended behaviour?
Regds
Mallah.
in 7.3.4
tradein_clients=# ALTER TABLE general.email_master ADD CONSTRAINT
e
Hmmm... am i doing anything really silly?
tradein_clients=# CREATE INDEX profile_master2 on profile_master (lower( btrim(email)
) );
ERROR: parser: parse error at or near "(" at character 61
tradein_clients=#
Regds
mallah.
---(end of broadcast)---
On Tuesday 11 Nov 2003 2:00 pm, Stephan Szabo wrote:
> On Tue, 11 Nov 2003, Rajesh Kumar Mallah wrote:
> > Hmmm... am i doing anything really silly?
>
> Functional indexes on 7.3 and earlier only allow a function over one or
> more columns (which would disallow the below as
How come pgsql7.3.4 Was allowing me to delete the master record while
referencing records were present in slave table?
The problem was detected when the database was migrated to 7.4 and
deletions were being refused.
Regards
Mallah
tradein_clients=# \d user_services
Table "public.user_serv
Jan Wieck wrote:
Rajesh Kumar Mallah wrote:
Hi ,
I noticed that an entry in pg_stat_activity was existing for a
long duration > 2 mins while its backend ( process corresponding
to that procpid) was not running.
how can it be possible ?
version: 7.3.4
There was a bug that caused a crash
Tom Lane wrote:
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
How come pgsql7.3.4 Was allowing me to delete the master record while
referencing records were present in slave table?
The only explanation I can think of is that the referencing row shown as
be
Peter Eisentraut wrote:
Rajesh Kumar Mallah writes:
*1.* Suppose varchar(30) turns out to be too small oneday
and we want to increase it to varchar(100) , what do i do ?
This is no different from the problem of changing a column type in place.
It's still
ic.branding_sp_category USING (company_id)
WHERE (category_id = 1142 OR category_id = 1143 OR category_id = 1145
OR category_id = 1259 OR category_id = 1161) AND old_company_id = 0 AND
status::text = 'a'::character varying::text AND email::text !~~*
'%.trade-india.com'::text AND email IS NOT NULL
ORDER BY company_id;
--
Rajesh Kumar Mallah,
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
Hi ,
I think one of the usage patterns of DOMAINS is
to have size specifications and validity constraints
at one place for easy administration of Database.
Eg, instead of declaring email to be varchar(30) in
10s of tables and putting a CHECK constraint for
presence of '@' we could dec
Is dump-->initdb-->reload
required for RC2 --> 7.4 ?
Regds
Mallah.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Hi,
How come numeric(10,2) accepting value 10.011 and truncating the .001
part ? Shudnt' it be complaining , i am not sure.
Regds
Mallah.
tradein_clients=# CREATE TABLE t_a ( a numeric (10,2) );
CREATE TABLE
tradein_clients=#
tradein_clients=#
tradein_clients=# \d t_a
Table "publ
69 matches
Mail list logo
