ICE: drop cascades to function gtsq_same(gtsq,gtsq,internal)
DROP TYPE
ROLLBACK
My Question is is it safe to drop that type and migrate ?
Regds
mallah
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
subroutine autovac_start can be modfied to
for the said feature. In case it does not have negative implication
can i submit a patch ?
regds
-- mallah.
>
>regards, tom lane
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make cha
the memory is left for kernel disk buffer cache ? is
fetching from
kernel disk buffer cache significantly expensive compared to getting from
shared buffer cache ?
regds
mallah.
On Thu, Feb 5, 2009 at 6:48 PM, Rajesh Kumar Mallah
wrote:
> Hi ,
>
> I have following setting in my postgr
420610048 121
regds
mallah.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Tue, Jul 22, 2008 at 5:54 PM, Achilleas Mantzios
<[EMAIL PROTECTED]> wrote:
> Στις Tuesday 22 July 2008 15:17:42 ο/η Rajesh Kumar Mallah έγραψε:
>> Hi,
>>
>> We want to log all SQLs that has been executed by using psql client.
>> we do not want to use .psql_his
long as 1 year even)
regds
Mallah.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
'pg_dict','pgsql');
-[ RECORD 1 ]
lexize | NULL
lexize | NULL
The expected result is
lexize| {postgres}
lexize| {postgres}
can any one pls tell where things might have gone wrong?
regds
mallah
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ll I add it.
Please advise.
you can do ./configure --with-perl again and do make install .
just make sure postgres is shut down before make install.
need not do initdb
its just like you would have done in case of minor upgrade. hope it helps.
regds
mallah
Regar
On 4/5/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> A friend of mine getting following error
> Error: xlog flush request 0/797FED50/ is not satisfied -- flushed only
> to 0/797FC1D8
> CONTEXT: writing block 681 o
certain
situation.
regds
mallah.
---(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 to the mailing list cleanly
Dear Subash,
follow the link given below,
spend 1 minute to read the instructions and another 15 secs to act.
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&func=lists-long-full&extra=pgsql-admin
Cheers
mallah.
---(end of b
have you used the verbose option by adding a couple of -v with
pg_dump or pg_dumpall ? try it it may give a hit
regds
mallah
On 3/7/07, Karthikeyan Sundaram <[EMAIL PROTECTED]> wrote:
Hi,
I am using 8.1.0 for my production. The pg_dumpall was working fine on
all these days. Su
for toast value 697890392
pg_dump: SQL command to dump the contents of table "bad_emails"
failed: PQendcopy() failed.
pg_dump: Error message from server: ERROR: missing chunk number
0 for toast value 697890392
regds
mallah.
tradein_clients=# VACUUM full verbo
free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
the code compiles fine under linux gcc (version not sure)
can anyone please suggest how to prevent this warning.
regds
mallah
changes.
this is easily accomplised by using your own functions that wrap the call
to contrib/xml2 functions. hope you get the point.
regds
mallah.
If you could help me!!
Thanks in advance.
___
Yahoo! Mail - Sempre a melhor opção para v
to contrib folder. read the README file for instructions.
still if you have problem come back here.
sorry i do not know of a tutorial at the moment , but its easy.
PS: please stick to the discussion on the list only.
regds
mallah.
Thanks for your help.
Rajesh Kumar Mallah escreveu:
&
On 1/23/07, Kranti <[EMAIL PROTECTED]> wrote:
Hey Guys,
This is my first email to list. Hope i will get the solution quickly.
Hi,
please use pg_dump -n option to select schema. Read manual
pages of pg_dump.I am not sure how to do it in pgadminIII
all said it is doable.
regds
malah.
I am wor
On 1/22/07, Alexander B. <[EMAIL PROTECTED]> wrote:
Hi,
I need to install XML on Postgres 8.1.
XML support is provided in PostgreSQL via a contrib module xml2.
look for xml related folders in contrib folder after untarring the pgsql
source. go through the README files on contrib modules to
know
AFAICS, log_statement and friends are much cheaper than any other
alternative could be.
Dear Sir,
thanks for the reply and clarifying.
regds
mallah.
regards, tom lane
---(end of broadcast)---
TIP 7: You can help
On 1/22/07, Umesh Shastry <[EMAIL PROTECTED]> wrote:
This may help you...
thanks for reply.
but thats for slow queries. Blocked queries are different
regds
mallah.
http://archives.postgresql.org/pgsql-announce/2006-01/msg7.php
---(end of bro
that was logging all statements which was
probably not a good idea in production environment. Can some
one suggest if anything else is readily available.
regds
mallah.
---(end of broadcast)---
TIP 4: Have you searched our list archives
we always avoid creating the extra index on a ie,
create index a on t(a); (does other databases also behave
similar?)
Regds
mallah.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
On 12/27/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> tradein_clients=> \o db.lst
> tradein_clients=> \l (till this point, there is nothing in file db.lst)
> tradein_clients=> \q (now it saves) (also save
Nagios is not suitable for above, its monitoring and alerting tool mainly.
You may consider writing custom software using rrdtools for archiving
historical data.
Regds
mallah.
Thank you.
--
Ivo Nascimento
Iann tech - Desenvolvendo soluções com performance e segurança
ecific reason of not doing it.
Regds
mallah.
From my application end I get "Sorry too many clients" error.
Refering the FAQ I maximized the DB session limit to 200.
I think the logs are not enabled in my DB. So I set the following options
in postgresql.con file
log_timestamp= true
log_
>
> Dunno till what extent this behavior is justified.
Maybe it is writing, just not fflushing?
Alvaro,
i am reporting as an enduser. I feel many would consider it buggy.
regds
mallah.
--
Alvaro Herrera
http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
Hi,
this is psql8.2 client and server.
tradein_clients=> \o db.lst
tradein_clients=> \l (till this point, there is nothing in file db.lst)
tradein_clients=> \q (now it saves) (also saves if another \o is issued)
Dunno till what extent this behavior is justified.
regds
mallah.
help you better.
regds
mallah.
psql>\dT *.trigger
List of data types
++---+-+
| Schema | Name| Description |
++---+-+
| pg_catalog | "trigger" | |
++---+-----+
(1
Sandy,
SELECT typowner from pg_type where typname='trigger';
check if typeowner exists in the column usesysid of pg_user
by doing
SELECT * from pg_user ;
if typeowner does not exists there is a problem.
regds
On 12/21/06, Sandy Spence <[EMAIL PROTECTED]> wrote:
Hi All,
I get the followin
ons of Trident Systems Inc.
-Original Message-
From: Rajesh Kumar Mallah [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 19, 2006 1:26 PM
To: Tom Kalafut
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] multiple postgres instances from RPM install
On 12/19/06, Tom Kalafut <[EMAIL P
On 12/19/06, Tom Kalafut <[EMAIL PROTECTED]> wrote:
I am getting ready to set up 2 postgres instances, but I'm somewhat new to
postgres. I've used RPM to list out all the files that are installed, and I
think I've isolated all the executables of which I need to make separate
copies, but I wa
On 12/19/06, Arnau <[EMAIL PROTECTED]> wrote:
Hi Jeff,
> On Tue, 19 Dec 2006, Arnau wrote:
>
>> I've got a DB in production that is bigger than 2GB that dumping it
>> takes more than 12 hours.
thats strange , we dump +20GB data in 2 hrs or so.
I have a new server to replace this old one
>>
erar Rajesh Kumar Mallah <[EMAIL PROTECTED]>:
---(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 to the mailing list cleanly
take intermediate path of upgrading
7.4-->8.0.x-->8.1.x -->8.2.0
where x denotes the last minor release of a major
release.
regds
mallah.
On 12/19/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi Rickard!
As far as i know you will have to dump and restore the databases for the
NDUSTRIAL_BRAKES_AND_CLUTCHES
580 OFFICE_SUPPLIES/PHOTOGRAPHY_AND_OPTICS/TIME_RECORDING
836 CHEMICALS/FINE_CHEMICALS_ALL
i think i should also change the function type to STABLE instead of
IMMUTABLE . (it does not have impact on this issue though)
Regds
mallah.
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
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:
> 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
n the query continues to give proper result.
Regds
mallah.
tradein_clients=> SELECT category_id from
general.web_category_masterwhere upper(
general.cat_url(category_id)::text) = 'AGRICULTURE';
+-+
| category_id |
+-+
| 1 |
+-+
(1 row
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
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
ll the proper solution to it.
regds
mallah.
LOG: duration: 8144.361 ms statement: update videos set
watched=watched+1, last_view_date='1166057431' where id='106980'
LOG: duration: 7825.637 ms statement: update videos set
watched=watched+1, last_view_date='1166057431
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/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/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
or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
tradein_clients=> \q
Regds
mallah.
backtrace is below:
(gdb) bt
#0 0x40098d71 in kill () from /lib/i686/libc.so.6
#1 0x40098af5 in raise () from /lib/i686/libc.so.6
#2 0x4009a1e0 in abort () fro
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 bro
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
ta seems to be there.
I think postgres was not starting for some peripheral issues
not because that data folder was corrupted.
BTW
when i first started postmaster it gave an error related to
too liberal permissions. Probably the original poster was doing
the same mi
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,
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
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
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)
&
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
users etc.
regds
mallah.
On 12/8/06, Philippe Salama <[EMAIL PROTECTED]> wrote:
I just installed Postgresql for windows.
There is an elephant headed icon, which seems to be the way to get to the
command line prompt. I have a textbook which assumes that you can
communicate with postgres throu
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
e scritps not drop the
old functions. just a thought , this situation could arise in general not just
tsearch2.so .
Regds
mallah.
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.r
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, 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
/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, 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
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
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
stall all 192.168.0.100/32 md5
(same a above but allows connection from said address range)
you can choose any config based on your requirement but make
sure it secure enough eventually.
Regds
mallah.
---(end of broadcast)---
TIP 2
on
as cascading drops , drops existing columns of database.
Regds
mallah.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
mbers.
IMHO for major version mismatch psql should not present the
user with a prompt at all as certain commands are most likely
not work.
Regds
Mallah.
I got binary psql from 8.0.x
and run. Psql program is a client program, that uses libpq library, so
it is (I think) no difference until th
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
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
ynot) be running in the machine. Make sure that
the server is running. see if the process postmaster is running.
once the server is running the command to restore is
the command to run a sql script file is :
psql -U postgres -f pgdump.sql
(you missed the -f)
Regds
mallah.
ccount to a limited account.
OR
create a new user postgres and do not give administrative rights
while creating. Run postgres using that user.
I havent' run postgresql on windows yet so i cannot give very specific
instructions but i hope you got the point.
Regds
mallah
Need bad
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.
YSE (of main SQL using the function) in postgresql cannot
provide the realtime analysis of the performace of queries inside the
function.
probably such a limitation may exists in db2 also.
I think the gap is genuine.
regds
mallah.
I normally use PostgreSQL for all my applications (this bei
ase help me
you should 'su - postgres' instead of 'su postgres' and try again.
probably PGDATA is not getting set because of that.
regds
mallah.
from man page of su
---
su is used to become another user during a login session. Invoked without a
u
postgresql like 8.1.5 or
the upcoming 8.2 version instead of oracle.
regds
mallah.
On 10/31/06, SUBASH CHANDRA MOHAPATRA <[EMAIL PROTECTED]>
wrote:
Hi All,
Please help me how to migrate from the postgresql 7.4 to oracle 9i .
Please let me know the process and the script also
Regards,
Subash
.
# Contributions: Grega Bremec ([EMAIL PROTECTED]) ,
#
Alvaro Herrera ([EMAIL PROTECTED])
# Preliminary Version: Mallah ([EMAIL PROTECTED])
##
if [ $# -ne 3 ]
then
echo "Usage: $0
"
exit 1
fi
H
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*
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
> 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
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
> | 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
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
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)
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, 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
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
> |
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 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
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
since it is not a postgresql issue
i think we should not discuss it over here.
i may persue it on pvt emails.
regds
mallah.
On 3/30/06, Salem Berhanu <[EMAIL PROTECTED]> wrote:
> Rajesh,
> Thanks for the suggestion. I tried what you told me. In my startup script I
> did
> u
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
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.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
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 ?
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:
&
() 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.
.
Regds
Rajesh Kumar Mallah.
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
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?
>
&
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
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
individually
using custom format and use pg_restore to restore
individual objects as when required.
My doubt is are the individual database backup files
created through -Fc options along with an SQL file
created using "pgdump_all -g " sufficient to recreate
the entire database ?
Re
1 - 100 of 272 matches
Mail list logo