Hi ,
I suppose pgdump_all creates a SQL script
that is capable of recreating the entire database
except for large_objects.
However pgdump_all produces one single large
SQL files and is not useful(easy) if one has to restore
a particular table.
For this reason we backup our databases individuall
man pg_dump seems to say it is not possible
-t table
--table=table
Dump data for table only. It is possible for there to be multi-
ple tables with the same name in different schemas; if that is
the case, all matching tables will be
Hi ,
I suppose pgdump_all creates a SQL script
that is capable of recreating the entire database
except for large_objects.
However pgdump_all produces one single large
SQL files and is not useful(easy) if one has to restore
a particular table.
For this reason we backup our databases individua
Hi,
PID 3533 does not exists in the system but its still in pg_stat_activity.
This is PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC gcc
(GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-49). Not sure if its already
known issue , advance apologies if
so.
tradein_clients=# SELECT procpid,query_st
the largest size of file that you can create
becuase that is going to limit the size of the database dump file. to verify
you may use dd command to create a file of say 5GB
$ dd if=/dev/zero of=test.dat bs=1024 count=5242880
$ ls -lh test.dat
Regds
Rajesh Kumar Mallah
On 10/11/05, Will Lewis
Yes
connect using
psql -E
database> \d viewname
observe the query that are used to produce the view defination
Regds
Rajesh Kumar mallah.
On 10/13/05, Colton A Smith <[EMAIL PROTECTED]> wrote:
> Hi:
>
>Can I query the database for the code for a particular view?
>
&
t; AND NOT w."granted" AND (h.relation = w.relation
AND h."database" = w."database" OR h."transaction" = w."transaction");
Can anyone please guide what should be done in such situati
.
Regds
Rajesh Kumar Mallah.
() by psql -c , it returns something
which does not looks like a WAL file.
Q3. tar exits with non zero status for the same reasons as mentioned in docs
is there any better archiving tool for this purpose ? can we use cp -a ?
Regds
Rajesh Kumar Mallah.
database directory not the one for archiving the logs.
when i use tar , it gives warning that the file changed
while it was reading the file, i need a tool that does not
give warning for this kind of activity.
Regds
Rajesh Kumar Mallah.
On 3/28/06, Tom Lane <[EMAIL PROTECTED]> wrote:
&
e – it would
> need heavy testing over a period of backups though to ensure the wrong files
> are not being deleted.
>
>
>
> Q3. tar exits with non zero status for the same reasons as mentioned in
> docs
> is there any better archiving tool for this purpose ?
tem-backup tool
such as tar or cpio. It is neither necessary nor desirable to stop
normal operation of the database while you do this.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
not sure if this info answers your question but
i am describing something that works for me.
regds
Rajesh Kumar Mallah.
> Thanks much
> Salem
>
>
>
> ---(end of broadcast)---
> TIP 2: Don't 'kill -9' th
db server and I see connections from the web server
> that appear and disappear.
> I checked http://my_mod_perl_server/perl-status and it has a link that says
> DBI connections but with no data in it.
> Also I wasn't clear on why you are not using connect_on_init.
> Thanks
> Sa
ster is stopped,
> copy it from oldhost to pg_xlog on newhost.
even if it(STOP WAL) was archived in the new machine ,
you should also copy the last partially filled WAL log from pg_xlog
that was created just after the file refrenced in backup file
was archived.
I think the overall process is fine
On 3/30/06, Grega Bremec <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: RIPEMD160
>
> Rajesh Kumar Mallah wrote:
> |
> | OK i am posting my full script [ its not heavy programming i guess :) ]
> | shall be grateful if you/someone could review i
in the same manner. As long as wal is archived
properly/securly there should not be any doubt.
Regds
Rajesh Kumar Mallah.
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jim C. Nasby
> Sent: Friday, March 31, 2006 10:11 AM
>
On 4/1/06, Grega Bremec <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: RIPEMD160
>
> Rajesh Kumar Mallah wrote:
> | Dear Grega ,
> |
> | Thanks for the useful tips and error spotting,
> | i am incorporating some of them and testing
> |
On 4/2/06, Christopher Browne <[EMAIL PROTECTED]> wrote:
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] ("Andy Shellam") belched out:> Is there an SQL command supported by Postgres to return a list of tables in a database?
Yes, it's called SELECT.There is a standard schema called INFOR
standard which are more likely to behave
the same in all versions of pgsql becoz they are(currently) views on
the sys catalogs.
Regds
Rajesh Kumar Mallah.
> ---(end of broadcast)---
> TIP 4: Have you searched our list archives?
>
On 4/2/06, Grega Bremec <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: RIPEMD160
>
> Rajesh Kumar Mallah wrote:
> |
> | Instead of taking a round about method i am using the content of the
> | file, (This was also suggested by Andy at somepoint)
who are supervising it :)
i only have the machines and situation to run it and seek
suggestions.
Regds
Rajesh Kumar Mallah.
>
>
> Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED]
>
> ClickSpace Interac
> | Do you see any problem in the current approach ?
> | i have seen it working fine till now.
>
> I do, to be honest. The WAL location counter accounts for 4294967295
> positions and while I'm certain that's WAY more than the average number
> of transactions that go into a WAL, quite a number of
e to backup and restore this kind of
> databases?
PITR is recommended for backup of such databases as it does
not involves dumping of entrie data everytime.
rsyncing pgdatadir while refreshing the base backup can minimise
the time for syncing as it has an intelligent algo.
Regds
Rajesh Kumar
> Rajesh Kumar Mallah wrote:
> |>| Do you see any problem in the current approach ?
> |>| i have seen it working fine till now.
> |>
> |>I do, to be honest. The WAL location counter accounts for 4294967295
> |>positions and while I'm certain that
done.
Regds
Rajesh Kumar Mallah.
>
>
> Las mejores tiendas, los precios mas bajos, entregas en todo el mundo,
> YupimMSN Compras: Haz clic aquí
---(end of broadcast)---
TIP 3: Have you checked our extensive F
On 4/13/06, Grega Bremec <[EMAIL PROTECTED]> wrote:> -BEGIN PGP SIGNED MESSAGE-> Hash: RIPEMD160> > Rajesh Kumar Mallah wrote:> > Is cluttering of the wal archive area in cases where that backup
> > had to be re-started for whatever reasons is the *only*
Hi List,
please find below a
1. A script that takes remote base backups of a postgresql database.
it assumes a password less communication between the backup
server and the database server. After taking a base backup it removes
that un neccesary WAL log files from the archive folder. The script
Dear Subhas,
There are many approaches.
1. dump the data to a sql script file , you may use -D option with pg_dump
for max portability
2. use DBI
the exact process depends on the complexity of data , number of tables type
of data etc.
i think you should migrate to a newer version of postgres
On 12/1/06, Manish Pillai <[EMAIL PROTECTED]> wrote:
Hi
I installed 8.1.4 POSTGRESQL RPMS on my system. When I tried to run
/etc/init.d/postgresql start I got this error.
[EMAIL PROTECTED] init.d]# ./postgresql start
Initializing database: mkdir: cannot create directory
`/var/lib/pgsql/data/pg_
On 12/1/06, Aaron Bono <[EMAIL PROTECTED]> wrote:
Recently I have been put on a project that uses DB2 (not my choice). I am
using functions for reports and was told this may not be allowed. They
said:
One gap is the ability to tune the code in the function (not really
static) or to perform re
On 12/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I am new to using postgres. I working on version 8.0.
I have created a number of users in the database but I am not able to log
into it using any of them,
Hi,
Could you please paste the ERROR message you get.
regds
mallah.
where in
On 12/7/06, ron <[EMAIL PROTECTED]> wrote:
Please kindly help me with this problem I am experiencing with starting up a
PostgreSQL 8.0 db service in a Windows 2003 server.
Whenever I attempt to restart the service I always get the message: "The
PostgreSQL Database Server 8.0 on Local Computer s
On 12/8/06, anuradha devi <[EMAIL PROTECTED]> wrote:
Hi
I have a pgdump.sql file and i want to restore it.The postgreSQL database
server is running and i issue the command psql -U postgres pgdump.sql in the
command prompt.
i get the following error.
C:\Program Files\PostgreSQL\8.2\bin>psql -U pos
Hi,
We connected psql 8.2.0 accidently to postmaster ver 8.1.5.
\d tablename does not work.
should psql at least warn like pg_dump does in case
of such client server version mismatches ?
regds
mallah.
---(end of broadcast)---
TIP 9: In versions b
On 12/8/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> We connected psql 8.2.0 accidently to postmaster ver 8.1.5.
> \d tablename does not work.
> should psql at least warn like pg_dump does in case
> of such clie
in other way and are
version specific, becouse the consttruction of information part of
database is not compatible between versions 8.0.x and 8.1.x and 8.2.x
(the first two numbers of a version are signifficant in this case).
Brgds
Adam
Rajesh Kumar Mallah wrote:
> Hi,
>
> We connected psql
Hi,
We have been using tsearch for past couple of years.
we feel that the script tsearch2.sql is only suitable
for adding tsearch2 support to new databases which
doesn not have it already.
for databases that already have older version tsearch2
installed one has to manually tweak tsearch2.sql to
On 12/8/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
my postmaster is on the same machine .. i am pasting the command and its
output here for u :-
% psql -d template1 -U postgres
psql: FATAL: Ident authentication failed for user "postgres"
You will need to modify pg_hba.conf file in the
Hi ,
We recently upgraded from PostgreSQL 8.1.5 to PostgreSQL 8.2.0.
looks like rank_cd function is giving problem .
tradein_clients=> CREATE TABLE test (name text , name_vec tsvector);
CREATE TABLE
tradein_clients=> INSERT INTO test (name ,name_vec) values ('hello
world' , to_tsvector('hello wo
function ?
Oleg
On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote:
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through
On 12/8/06, Oleg Bartunov wrote:
On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote:
> On 12/8/06, Oleg Bartunov wrote:
>> You need to read documentation ! rank_cd accepts the same args as rank()
>> function.
>
> Dear Oleg,
>
> Could you please elaborate a bit
/06, Rajesh Kumar Mallah <[EMAIL PROTECTED]> wrote:
On 12/8/06, Oleg Bartunov wrote:
> On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote:
>
> > On 12/8/06, Oleg Bartunov wrote:
> >> You need to read documentation ! rank_cd accepts the same args as rank()
> >> functio
On 12/8/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> IMHO for major version mismatch psql should not present the
> user with a prompt at all as certain commands are most likely
> not work.
The analogy you're dr
On 12/8/06, Oleg Bartunov wrote:
On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote:
> Dear
>Oleg,
> In local development server. the old functions still exists in
> postgresql catalogs. But probably they are missing in the
> newer version of tsearch2.so that came with 8.
On 12/8/06, Oleg Bartunov wrote:
On Fri, 8 Dec 2006, Tom Lane wrote:
> Oleg Bartunov writes:
>> You need to read documentation ! rank_cd accepts the same args as rank()
>> function.
>
> Nonetheless, dumping core on bad input is not acceptable behavior ...
we already resolved the situation. Th
On 12/8/06, Oleg Bartunov wrote:
On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote:
> On 12/8/06, Oleg Bartunov wrote:
>> On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote:
>>
>> > Dear
>> >Oleg,
>> > In local development server. the old functions sti
Hi,
Go to Start->run -> type cmd
say you get the c: prompt then type
C:\blah\blah> psql -U postgres template1
above assumes psql is in PATH. if it succeeds
you shall get a psql prompt.
once you get the prompt , follow the instructions in text book
to create new database , users etc.
regd
Hi,
Some of our tables have duplicate indexes on same column by different
index names.
Should the database server check for the existance of (effectively)
same index in
a table before creating a new one.
Regds
Mallah.
---(end of broadcast)---
TIP
On 12/9/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> Some of our tables have duplicate indexes on same column by different
> index names.
> Should the database server check for the existance of (effectively)
&
having duplicate indexes.
Regds
mallah.
On 12/9/06, Rajesh Kumar Mallah <[EMAIL PROTECTED]> wrote:
On 12/9/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> > Some of our tables have duplicate indexes on same column by
Hi,
Will it be a good feature to have pg_ctl check the syntaxes of
the config files before sending a SIGHUP to postmaster ?
Suppose a DBA does somes typos in the files, he shall be confused
not to see the changes in server even after pg_ctl reload .
Regds
mallah.
---(en
On 12/9/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> Suppose an index get corrupted. And you need create a new index
> with exact specs and then drop the old index. Is it better to
> have a performing corrupted
Hi List ,
I restored the filesystem backup tar and ran postgres 7.3.8 on the data folder.
there was no problem at all.
DEBUG: FindExec: found "/opt/usr/local/pgsql7.3/bin/postgres" using argv[0]
DEBUG: invoking IpcMemoryCreate(size=1466368)
DEBUG: FindExec: found "/opt/usr/local/pgsql7.3/bin/
On 12/11/06, Shoaib Mir <[EMAIL PROTECTED]> wrote:
I meant "all looks *good* according to the logs" :)
thanks everyone.
regds
mallah.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On 12/12/06, Gábriel Ákos <[EMAIL PROTECTED]> wrote:
go to psql
issue \di+
server closes connection :)
Akos,
Can you please paste the exact message with which
server closes connection. also start psql with -E option
Regds
mallah.
Regards,
Akos
---(end of broadcast)
Hi,
below query crashes 8.2.0
tradein_clients=> SELECT size from general.eyp_listing where size in
(select distinct size from general.eyp_listing ) order by size limit
1;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while
On 12/12/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> below query crashes 8.2.0
> tradein_clients=> SELECT size from general.eyp_listing where size in
> (select distinct size from general.eyp_listing ) order by si
On 12/12/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> Can you *please* tell how to get the fix.
Checkout REL8_2_STABLE branch, not HEAD ...
Thanks!.
regards, tom lane
---
On 12/13/06, Antonios Katsikadamos <[EMAIL PROTECTED]> wrote:
Hi all,
Sorry to bother. I would like to know where postgres stores the created
database and the tables.Can anyone help,
which OS or distribution is it?
look into the startup script that starts postgresql service.
The path is conf
On 12/14/06, Anton P. Linevich <[EMAIL PROTECTED]> wrote:
Hi guys. Can you give me a describe what should i do when get a lot of
slowly queries?
Last week i saw such INFO messages in postgres log:
we too faced the same problem wherin a table was updated very frequently
and with time it used to
On 12/14/06, Anton P. Linevich <[EMAIL PROTECTED]> wrote:
Hi guys. Can you give me a describe what should i do when get a lot of
slowly queries?
btw such questions should go to performance list.
---(end of broadcast)---
TIP 6: explain analyze is y
The cost of preventing every stupid database use is too high.
--
thanks it answers my concern. many a times we face the same
situation with the marketing people of our company. the complexity
of stopping stupid usage can be quite non trivial at times.
regds
mallah.
-
Yes PostgreSQL does support COMMENTing on wide
range of objects in the same manner as Oracle.
rt3=# \h comment
Command: COMMENT
Description: define or change the comment of an object
Syntax:
COMMENT ON
[
TABLE object_name |
COLUMN table_name.column_name |
AGGREGATE agg_name (agg_t
Hi,
Is it possible to log the statements and durations of executed
queries into a special table for later analysis. Or capturing the
logfile and parsing it the only way? In the case of latter is it
possible to use syslog to pipe the lines through a program
can anyone please share the config if he
Hi,
I think its not going to a trivial task to take out only the LOG
duration
lines from a PostgreSQL logfile. We need to extract the duration and
the actual statement. I think i will put a custom delimeters around the
statements for the time being so that the log parser can parse it
unambig
Hi ,
In the explain below are the references
"outer"."?column2?" = "inner"."?column2?"
Ok?
rt3=# SELECT version();
version
PostgreSQL 7.4beta5 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row
Dear ashok,
Looks like you installed pgsql from the RPMS.
I feel the /etc/rc.d/init.d/postgresql script should be more verbose to
tell about the exact problem.
In any case the sure shot method of initialising and starting the postmaster
is to follow the instruction that comes in the INSTALL file
Juan Miguel wrote:
Greetings!
pg_autodoc
http://www.rbt.ca/autodoc/index.html
can produce .dot files that can be charted using
graphviz.
http://www.graphviz.org/
It works pretty well for medium sized databases
but for large it tends to produce a spaghetti.
Check the "Related Sites" in graphviz
Dear Ganesan,
pgautodoc (for dot output) + dot (from graphviz.org , creates
postscript) +
epssplit ( splits the postscript into multipage so that one can create
poster size
diagrams) works well for me.
I have 45 tables in the database though.
Regds
mallah.
Chris Travers wrote:
There is a fre
Greetings,
Can tsearch V1 and V2 exist in the same database simultaneously?
I have read in past that its difficult , but is it possible for the
desperate?
regds
mallah.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Oleg Bartunov wrote:
On Fri, 13 Feb 2004, Rajesh Kumar Mallah wrote:
Oleg Bartunov wrote:
On Tue, 10 Feb 2004, Rajesh Kumar Mallah wrote:
Greetings,
Can tsearch V1 and V2 exist in the same database simultaneously?
I have read in past that its difficult , but is it possible
Greetings,
The function txt2txtidx of tsearch1 crashes the backend
in my installation when it is called with a text where '-' is
immediately followed by a number.
Does any one has any solution for it?
Regds
Mallah.
tradein_clients=# SELECT version();
+--
Dear James,
We have been using mod_perl with PostgreSQL in web environment
without any problems. I hope you are already using Apache::DBI for
connection pooling.
Regds
Mallah
James Taylor wrote:
Hi everyone, using mod_perl with Postgres, postgres is on the same
server as the webserver. Perl is
Greetings!
It takes ages to drop a constraint from one of my tables
[ table details at the end ] I cannot insert into it also.
I know pg_dump is not running and no other query is accessing the
table.
Can anyone help me debugging this problem? Can anyone explain the
following entires in pg_
Greeting,
In my top output in database server many postmaster processes
get into Uninterruptable sleep "D" state and then come back to "S"
state . Is it normal and expected or is anything fishy that i need to
look into?
Regds
mallah.
---(end of broadcast)
Greeting,
i have 2 identical queries. One of that finish faast another takes ages.
there are couble of trigers that run on update. I want to know where
exactly the sencond query takes time.
is there any way to increase debug logging from the psql prompt
so that i can see whats going behind?
Regds
Greetings,
in my database i have both tsearch1 and tsearch2 .
the following sequence of commands lead to this
repeatble problem .
Any solution ?
Regds
mallah.
Welcome to psql 7.4RC2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
Tom Lane wrote:
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
in my database i have both tsearch1 and tsearch2 .
the following sequence of commands lead to this
repeatble problem .
I get a "t" result in 7.4 tip.
Any solution ?
Possibly you should be running some
Oleg Bartunov wrote:
On Tue, 10 Feb 2004, Rajesh Kumar Mallah wrote:
Greetings,
Can tsearch V1 and V2 exist in the same database simultaneously?
I have read in past that its difficult , but is it possible for the
desperate?
quite peacefully, no problem
Thank You,
thats a releif to know
Jhonatas M. Rodríguez wrote:
Hey Everyone:
How are you?... i want to know if PostgreSQL have a
.NET provider for VS.NET with ADO.NET and OleDB.
open source:
http://gborg.postgresql.org/project/npgsql/projdisplay.php
commercial:
http://crlab.com/pgsqlnet/
I'm interesting to develoment with P
Hi,
The harddrive on which i had linked pg_xlog
has been lost. I have all other folders except that
which are in a seperate drive are present.
Can i get my data back using pg_resetxlog ?
Any Help will be greatly appreciated.
Regds
Mallah.
---(end of broadcast)---
?
i am using 7.4.1 btw , shall now try with 7.4.3
Regds
Mallah.
[EMAIL PROTECTED] wrote:
Rajesh Kumar Mallah wrote:
Hi,
The harddrive on which i had linked pg_xlog
has been lost. I have all other folders except that
which are in a seperate drive are present.
Can i get my data back using pg_re
I recovered my database by pg_resetxlog and then did a dump , initdb ,
reload.
one of the tables exhibited this phenomenon. I thought it was worth
mentioning
to the developers.
Regds
mallah.
rt2=# SELECT name from users group by name having count(*) > 1 limit 20;
+--+
| name
Tom Lane wrote:
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
rt2=# SELECT name from users group by name having count(*) > 1 limit 20;
(4 rows)
rt2=# SELECT name from users group by name having count(*) > 1 ;
(0 rows)
Weird. What PG version is this? What doe
|
| Total runtime: 577.212
ms
|
++
(4 rows)
Tom Lane wrote:
Rajesh Kumar Mallah
Tom Lane wrote:
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
It does.
And?
Yep the problem of original posting could be replicated on
disabling hash aggregates. On disabling i could get the repeated rows.
Regds
Mallah.
rt2=# SET enable_hashagg
Tom Lane wrote:
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
Yep the problem of original posting could be replicated on
disabling hash aggregates. On disabling i could get the repeated rows.
Okay. What I suspect is happening is that there are entries in the
Hi,
We run our webserver using mod_perl and perl/DBI/DBD-Pg .
I have observed that most of the pg backends that block other queries
are in ' in transaction' state. Usually sending a -INT or -TERM
to such blocking backends solve the problem.
My question is
1. Are there some precuation to be taken i
to version 7.4.5
A dump/restore is not required for those running 7.4.X
Regds
mallah.
Chris White (cjwhite) wrote:
Will a DB created under 7.4.2 work with 7.4.5, or do I need to back it
up and restore it to a newly created 7.5.4 DB?
Chris White
--
regds
Mallah.
Rajesh Kumar Mallah
ksha Kulkarni
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)---
TIP 8: explain analyze is your friend
--
regds
Mallah.
Rajesh
me.
Regds
Mallah.
Will a DB created under 7.4.2 work with 7.4.5, or do I need to back it
up and restore it to a newly created 7.5.4 DB?
Chris White
--
regds
Mallah.
Rajesh Kumar Mallah
+---+
| Tradeindia.com (3,11,246)
Hi,
Somehow those pids automatically got terminated
and my problem was solved. I did not issue any kill as i
do not have access to the server.
curious how it happened any idea??
Regds
mallah.
Tsirkin Evgeny wrote:
On Mon, 25 Oct 2004, Rajesh Kumar Mallah wrote:
Hi,
We run our webserver using
or
University of Virginia
(434) 924-2846
[EMAIL PROTECTED]
--
regds
Mallah.
Rajesh Kumar Mallah
+---+
| Tradeindia.com (3,11,246) Registered Users |
| Indias' Leading B2B eMarketPlace |
| http://www.tradeindia.com/ |
+---+
solution ?
Most of the servers ( like bind,apache) provide the facitly of accepting
connections only on particular ip addresses / interfaces shud postmaster
also provide the same (in case its not so)?
Regds
mallah.
--
regds
Mallah.
Rajesh Kumar Mallah
Hi,
I have an index on upper(general.cat_url(category_id)) on a table.
when i add a column *with* default value , a query that previously
used to give result does not give results anymore. REINDEX'ing the
table produces correct result. if no default value is giving while adding
the column the que
On 12/16/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> I have an index on upper(general.cat_url(category_id)) on a table.
> when i add a column *with* default value , a query that previously
> used to give resul
Its declared immutable , it queries the same table , its recursive
and it queries another custom function also.
fyi dir_name is a simple plperlu function.
my ($dir) = @_;
$dir =~ s/&/and/g;
$dir =~ s/&/and/g;
$dir =~ s/[^a-zA-Z0-9]+/_/g;
return $dir;
On 12/16/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> On 12/16/06, Tom Lane <[EMAIL PROTECTED]> wrote:
>> What is that nonstandard function you're using in the index?
> Its declared immutable , it quer
> why does ALTER TABLE ADD new_col int default 0 rebuilds
> existing indexes ?
Because it has to rewrite the whole table to insert the default value
in every row. A REINDEX is way more efficient for recovering from that
than any row-by-row update would be.
thanks for explaining.
>> I wond
1 - 100 of 225 matches
Mail list logo
