lly able to import table,sequence,indexes,constraints
but data is not able to import. means, i'm not able to see my data.
Can anyone tell what might be the problem?
Thanks,
Praveen
---(end of broadcast)---
TIP 3: if posting/reading through U
advance.
Praveen Malik.
It will better you export and import through network by using following command.
psql -U < schemaname > < databasename> --schema=schemaname | psql -U
postgres -h < IP adddress of system where you are importing data>
- Original Message -
From: Andrew Goodnough
To: pgsql-admin@
Yes you can do this using following commands.
For tables:-
select ' alter table '||tablename||' set tablespace ;'
from pg_tables where schemaname='' and tableowner='<
mention table owner here >';
For index :-
select ' alter index '||indexname||' set tablespace ;'
from pg_indexes where schemanam
* [all] Error 2
Please tell me how I can avoid this kind of error.
Thanks & regard
Praveen kumar.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
I can avoid this kind of error.
Thanks & regard
Praveen kumar.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
" <[EMAIL PROTECTED]>
To: "praveen" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2008 8:19 PM
Subject: Re: Installation Error of postgresql-8.1.5 with perl.
"praveen" <[EMAIL PROTECTED]> writes:
but when I execute comm
Thanks a lot , Tom Lane.
I installed below mentioned RPMs and now it is working
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "praveen" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>;
Sent: Wednesday, November 05, 2008 8:54 PM
Subj
make -C bootstrap all make[2]: Entering directory
`/opt/postgres/postgresql-6.5/src/backend/bootstrap'd
bootparse.ymake[2]: d: Command not foundmake[2]: [bootparse.c] Error
127 (ignored)grep -v "^#" boot.sed > sedfilesed -f sedfile < y.tab.c >
bootparse.c/bin/sh: y.tab.c: cannot openmake[2]: ***
,links and books I should follow for getting
knowledge
about above
mentioned activites.
rgds
Praveen
MalikSoftware Engineer
Extn:1607===Sobha
Renaissance Information Technology Private LimitedAn
SEI-CMM & P-CMM Lev
ation_mast.location_id andtuv_customer_location.location_id=
tuv_location_mast.location_id andtuv_location_mast.location_id=
tuv_location_mast_intl.location_id(+) and tuv_customer_location.cust_id =
tuv_customer_mast.cust_id andtuv_customer_mast.cust_id =
tuv_cu
Hello All,
I have installed Tsearch-Module for full text indexing .But when I search text
using gist(idxFTI) index on table I also found
all data which have same accent.Example
1.If I try search for MANI word it also search for MANY word.
2.If I try search for ANDY word it also search for ANDI w
by user
"praveen".
This user must also own the server process.
The database cluster will be initialized with locale en_US.UTF-8.
The default database encoding has accordingly been set to UTF8.
fixing permissions on existing directory /usr/local/pgsql/Data ... ok
creating directory
.
thanks in anticipation
regards,
--
N Praveen Kumar
Imagination is more important than knowledge...
--Albert Einstein
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
hai folks,
i don't want any mails now, i want to remove my account in u r database
please un subscribe me.
l.v.praveen
_
Using a handphone prepaid card? Reload your credit online!
http://www.msn.com.my/reloadredir/default.asp
hai admin,
un subscribe my account from list,i don't want any mails
_
Download ringtones, logos and picture messages from MSN Malaysia
http://www.msn.com.my/mobile/ringtones/default.asp
---(end of broadcas
hai admin,
I've been recieving a lot of emails about PostgreSql
administration, and I
don't want reciving it anymore, remove my account from your databases
records, please.
praveen
_
Download ringtones, logos a
0
+ TRIGGER_FILE=/home/backup/trigger
++ expr : '.*\(history\)'
expr: syntax error
+ k=
+ '[' '' == backup ']'
+ '[' '!' -f '' -a 0 -eq 0 ']'
+ usleep 10
+ '[' -e /home/backup/trigger ']'
+ TRIGGERED=1
Hello ,
Go through this below mentioned link
http://archives.postgresql.org/sydpug/2006-10/msg1.php
_
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of libra dba
Sent: Friday, February 15, 2008 4:11 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Failover of th
Hello,
If the machine where we have make setup for warm standby database goes
down and we restart this machine again ,then what will be happen for
Our warm standby database ,will it again start applying archive log from
starting point ( archive log generated after taking online backup) or
from
Hello,
When I try to install postgresql-nls-string-8.02 in postgresql-8.2.5 or
in higher version ,it give the following error.
ERROR: incompatible library "/home/local/pgsql/lib/nls_string.so":
missing magic block
HINT: Extension libraries are required to use the PG_MODULE_MAGIC
macro.
ERR
Hi,
I think you have a lot DML operation in your database and you are not
vacuuming your database . So try to execute command vacuum analyze
<>; in your schema where you are facing problem.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Devendra Singh
Raw
22 matches
Mail list logo
