Ok , i do see there is already the handling of application_name in the
trigger ,
this is quite sufficient for my current needs.
regds
mallah.
On Wed, May 10, 2017 at 10:58 PM, Rajesh Mallah
wrote:
> Hi Scott / List ,
>
> Thanks for the response,
>
> the application_name usage s
) pgaudit seems to be logging only with
no possibility
of knowing the old record.
I think audit trail of tables is something that is frequently required , it
would be
nice if some inbuilt (core) feature comes someday in postgresql for auditing
regds
mallah.
On Wed, May 10, 2017 at 1:17 AM, Scott
res
custom variable during the database connection and reading it inside the
trigger
and storing it in the audit log table.
I am curious how others deal with the same issue , is there better or more
inbuilt solutions
to store the application level user in the audit trail records.
Regds
mallah.
( https://www.redgrape.tech )
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
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.
postgresql at this
moment which is 9.1.1
can any one please suggest , I think autovaccum is on.
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
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
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
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
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
'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
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
e file system backup tools emit warnings or errors if the files they are
trying to
copy change while the copy proceeds." , it only says about "change" not
disappearance.
Since i have deep respect for the excellent documentation quality of
PostgreSQL project
i read and interpret it by wo
atadir . My question is
can we ignore such errors of "vanishing files" ? is it normal ?
I think the situation is arising because some table which were created
before start of backup were dropped during the backup. But that is
quite normal also.
regds
mallah.
tar: Removing leadi
i "discovered" it as a result of typo :)
we usually select expressions without tables
eg select 1+2 ; etc and the results are as expected,
somehow i failed to stretch the analogy to count(*)
which is mostly used over tables or table expression.
thanks anyways.
regds
mallah.
On
(*) job_non_exist ;
job_non_exist
---
1
(1 row)
bric=# SELECT count(*) jo1b ;
jo1b
--
1
(1 row)
bric=# SELECT count(*) none ;
ERROR: syntax error at or near "none"
LINE 1: SELECT count(*) none ;
I fail to see any progression ?
regds
mallah.
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 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 -
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 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 1s of
rows use alternate
approaches.
regds
Rajesh Ku
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
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
. 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
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
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
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
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
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
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.
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
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
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
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,
>
>
or sending the records ?
anticipating your enlightening answers
your respectfully
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.
pg_last_xlog_replay_location
--
0/200
(1 row)
Regds
Rajesh Kumar Mallah.
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.
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 ,
y DDL / DML done to public schema of rt3 database
is redirected to rt3 namespace of the existing database maindb's rt3 schema.
regds
mallah.
Very sorry
had downloaded the -base package by mistake.
Regds
mallah.
> Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
>> In 7.4.6 there is only plpgsql under pl where as 7.4.5
>> includes it in the main distribution
>
> When complaining about a packaging pr
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
fine for me though
Regds
mallah
test=# \d t_b
Table "public.t_b"
Column | Type | Modifiers
+-+---
a | integer |
Tablespace: "space"
test=# ALTER TABLE t_b SET TABLESPACE pg_default;
ALTER TABLE
t
The beta link under ftp://ftp3.us.postgresql.org/pub/postgresql/
and possible all mirrors leads to nowhere. I guess many people
would click there.
Regds
mallah.
Gaetano Mendola wrote:
Marc G. Fournier wrote:
After almost 9 months of development, the PostgreSQL Global
Development Group is proud
?
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
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"
++---++
|
k ? In former case
the query will get cancelled for an invalid reason.
Regds
mallah.
regards, tom lane
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
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
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
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
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
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
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
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
he
constraint defs on a domain .
information_schema.domain_constriants does not have the
definations just the names are present.
Regards
Mallah.
Its really nice to see/read the pretty printing of
VIEW definations!! in 7.3 it was a
nightmare to see definations of long views.
Kudos to the TEAM.
Regds
Mallah
tradein_clients=# \d XYZ
View XYZ
Column | Type | Modifiers
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
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
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
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
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
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
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
point out section in
the standard docs that discuss this issue.
Regds
Mallah.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
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
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]>
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
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
think you need to be running in a single transaction
(although they could be grouped inside a function or as a trigger for
example).
But isnt' foreign key constraints deferrable inside transactions?
i vaugely remember doing it . istn' it the best way of doing it?
[ if at all it work
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
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.
>
> &
wondering how to rephrase this to fit in the
> recently-agreed-to message style guidelines. I think the
> (col names)=(values) part must go into errdetail, but I'm
> fuzzy beyond that. Comments?
Even this message would be a great relief.
not in a position to comment I will in
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 .
>
&
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
73 matches
Mail list logo
