[GENERAL] user restriction

2007-05-31 Thread Ashish Karalkar
Hi All, I want to create a user in Postgres Database. And I want to restrict that user with some privileges. And also I want that user should be specific to particular database. He should not be able to do the following 1) Connect to any other database. 2) Connect to System da

Re: [GENERAL] failing to start posgresql.

2007-06-07 Thread Ashish Karalkar
check under $PGHOME/data/pg_log directory. Usually $PGHOME=/usr/local/pgsql if u have not changed this path during installation With Reagrds Ashish... - Original Message - From: phillip To: pgsql-general@postgresql.org Sent: Thursday, June 07, 2007 2:21 PM Subject: [GENE

[GENERAL] Managing Kernal resource

2007-06-08 Thread Ashish Karalkar
Hello All, I think I am little bit lost in congiguration of SHMMAX parameter. As per documantation on : http://www.redhat.com/docs/manuals/database/RHDB-7.1.3-Manual/admin_user/kernel-resources.html Name Description Reasonable Values SHMMAX Maximum size of shared memory segment (by

[GENERAL] sql server to postgreSQL

2007-06-13 Thread Ashish Karalkar
Hello All, I have a long list of sql server queries that needs to me remoulded in to postgres format can anyone please suggest me any tool that will convert sqlserver query into postgresql query except SwisSQL - SQLOne Console 3.0 Thanks in advance With regards Ashish Karalkar

[GENERAL] function to find difference between in days between two dates

2007-06-14 Thread Ashish Karalkar
ance With regards Ashish Karalkar

[GENERAL] Auto Vaccume- Time based

2007-06-27 Thread Ashish Karalkar
Hello all, I want to set Auto vaccunme in such a way that it will start in the Mid night (12:00 A.M.) Is there any way to do this except Cron Job for Linux Thanks In advance With Regards ashish ...

Re: [GENERAL] Auto Vaccume- Time based

2007-06-27 Thread Ashish Karalkar
Thnkas Richard for your replay. Actually ,I was looking for some setting in postgresql.conf file Is there any one? With Regards Ashish - Original Message - From: "Richard Huxton" <[EMAIL PROTECTED]> To: "Ashish Karalkar" <[EMAIL PROTECTED]> Cc: Sent:

[GENERAL] Create user

2007-06-29 Thread Ashish Karalkar
Hello All, I am trying to create a user and i dont understand why it is showing me any massage even after giving parameter -e to the command. command : C:\Program Files\PostgreSQL\8.2\bin>createuser ashish -S -d -R -l -P -E -e -U postgres Enter password for new role: Enter it again: Passwor

[GENERAL] assigning password from script

2007-07-01 Thread Ashish Karalkar
Hello All, I want to create a user through script and dont want user to assign password interactively, I want it to be assigned through some file or anything else some this like createuser -P * OR createuser -P Is there any way? Thanks in Advance With Regards Ashish...

[GENERAL] Tables not created in proper schema

2007-07-01 Thread Ashish Karalkar
Hello All, I am trying to create databse with script. I run this script from root prompt with command $ su - postgres -c 'path to script.sql' In the script I follow following steps 1) create user xyz 2) create database xyz -O xyz 3) create schema xyz 4) {PG_PATH}/psql -d xyz -U xyz -f /usr/l

Re: [GENERAL] assigning password from script

2007-07-01 Thread Ashish Karalkar
Thanks for your replay Scott, I am using just sql script and there is no option like pwd with createuser command With Regards Ashish... - Original Message - From: "Scott Marlowe" <[EMAIL PROTECTED]> To: "Ashish Karalkar" <[EMAIL PROTECTED]> Sent

Re: [GENERAL] Tables not created in proper schema

2007-07-02 Thread Ashish Karalkar
schmer" <[EMAIL PROTECTED]> To: Sent: Monday, July 02, 2007 2:28 PM Subject: Re: [GENERAL] Tables not created in proper schema am Mon, dem 02.07.2007, um 11:13:54 +0530 mailte Ashish Karalkar folgendes: Hello All, I am trying to create databse with script. I run this script from root

Re: [GENERAL] assigning password from script

2007-07-02 Thread Ashish Karalkar
- Original Message - > 2007/7/2, Ashish Karalkar <[EMAIL PROTECTED]>: Hello All, I want to create a user through script and dont want user to assign password interactively, I want it to be assigned through some file or anything else some this like createuser -P

Re: [GENERAL] how to: psql -U user --password password ?

2007-07-03 Thread Ashish Karalkar
Hello Stefan, Recently I Have faced this problem and solved by .pgpass file approch Take alook on http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html With Regards Ashish... - Original Message - From: "Stefan Zweig" <[EMAIL PROTECTED]> To: Sent: Tuesday, July 03, 2007

[GENERAL] pgpass.conf

2007-07-10 Thread Ashish Karalkar
Hello All, I am trying tu run a script to create database from a batch programme and dont want to supply password everytime. So i tried to setup pgpass.conf file. File is kept in user profile/application data i.e C:\Documents and Settings\postgres\Application Data\postgresql\pgpass.conf file co

Re: [GENERAL] pgpass.conf

2007-07-10 Thread Ashish Karalkar
- Original Message - From: "Raymond O'Donnell" <[EMAIL PROTECTED]> To: "Ashish Karalkar" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, July 10, 2007 3:51 PM Subject: Re: [GENERAL] pgpass.conf On 10/07/2007 08:47, Ashish Karalkar wrote: Still the

Re: [GENERAL] pgpass.conf

2007-07-10 Thread Ashish Karalkar
- Original Message - From: "Dave Page" <[EMAIL PROTECTED]> To: "Ashish Karalkar" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, July 10, 2007 4:25 PM Subject: Re: [GENERAL] pgpass.conf Ashish Karalkar wrote: Hello All, I am trying tu run a script to create

[GENERAL] redirecting output of pg_dump

2007-07-18 Thread Ashish Karalkar
Hello all, I want to take backup from one server and save it to another machine hard drive. The backup will be taken through a shell script attached to a cron job. something like: pg_dump -d postgres -U postgres -f is there any way? With regards ashish...

[GENERAL] PgAdmin GUI on the Linux Server

2007-07-24 Thread Ashish Karalkar
Hello All, I am having PostgreSQL server 8.2.0 running on Redhat Linux . I want to install PgAdmin GUI on the Linux Server. can anybody please guide me to the appropriate documantation and the prerequisite required for the same . Thanks In Adavnce With Reagrds Ashish...

[GENERAL] Problem With gunzip backup

2007-08-01 Thread Ashish Karalkar
Hello All, I am having following PostgreSQL & Linux version PostgreSQL 8.2.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.3 20041212 (Red Hat 3.4.3-9.EL4) I am trying to create the backupfile using gunzip utility pg_dump qsweb | gzip > /usr/local/backup/backup.gzBut when I run this comm

Re: [GENERAL] Accessing tables in other databases, through functions

2007-08-16 Thread Ashish Karalkar
take a look at dblink in contrib module With Regards Ashish... - Original Message - From: "Phoenix Kiula" <[EMAIL PROTECTED]> To: "Postgres General" Sent: Thursday, August 16, 2007 6:18 PM Subject: [GENERAL] Accessing tables in other databases, through functions Probably an optimist

[GENERAL] Read Access to database

2007-08-27 Thread Ashish Karalkar
Hello all, I have a database abc with owner c . I want to grant only read access on this DB abc to user d. More specificaly to a schema abcs in the databse abc. Is ther any way to do so? I have more than 1000 table so dont want to list all the table name in the grant command. Thanks in advan

[GENERAL] Export data to MS Excel

2007-09-01 Thread Ashish Karalkar
Hello All, I want to export data from PostgreSQL tables to MS Excel. Is there any way? Thanks in advance... With Regrads Ashish...

[GENERAL] invalid byte sequence for encoding "UTF8": 0xff

2007-09-03 Thread Ashish Karalkar
Hello All, I have a data script which runs fine from PgAdmin SQL Editor,but when I run this from command prompt I get following error: test=# \i /usr/local/pgsql/qsweb1/QSWEB_100_4_Default_Data.sql psql:/usr/local/pgsql/qsweb1/QSWEB_100_4_Default_Data.sql:1: ERROR: invalid byt e sequence fo

Re: [GENERAL] invalid byte sequence for encoding "UTF8": 0xff

2007-09-03 Thread Ashish Karalkar
- Original Message - From: "Ashish Karalkar" <[EMAIL PROTECTED]> To: "Albe Laurenz" <[EMAIL PROTECTED]> Sent: Monday, September 03, 2007 4:09 PM Subject: Re: [GENERAL] invalid byte sequence for encoding "UTF8": 0xff - Original M

Re: [GENERAL] invalid byte sequence for encoding "UTF8": 0xff

2007-09-03 Thread Ashish Karalkar
- Original Message - From: "Albe Laurenz" <[EMAIL PROTECTED]> To: "Ashish Karalkar *EXTERN*" <[EMAIL PROTECTED]> Cc: Sent: Monday, September 03, 2007 4:54 PM Subject: RE: [GENERAL] invalid byte sequence for encoding "UTF8": 0xff Ashish K

[GENERAL] Column ordering

2007-09-10 Thread Ashish Karalkar
Hello All, I am having a table with 5 columns. I want to add another column by altering the table at 2nd position constraint is that I can not drop and recreate the table as column ordering is of importance. Is there anyway to do so. Thanks in advance. With regards Ashish... ---

[GENERAL] Column Ordering

2007-09-10 Thread Ashish Karalkar
Hello All, I am having a table with 5 columns. I want to add another column by altering the table at 2nd position constraint is that I can not drop and recreate the table as column ordering is of importance. Is there anyway to do so. Thanks in advance. With regards Ashish...

Re: [GENERAL] Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug?

2007-09-24 Thread Ashish Karalkar
As per as I think this is not bug, in first case when u update the first row In first case: M1= 1+1 =2 conflict with the second row. in second case: M1=3+1=4 no conflict with second row I hope this will help. With reagrds Ashish - Original Message - From: Anoo Sivadasan P

[GENERAL] PgpoolAdmin installation

2007-09-25 Thread Ashish Karalkar
Dear list member, I am trying to install pgpooladmin tool and the documantation talks about following parameter pcp_attach_node command pass /usr/local/bin/pcp_attach_node pcp_detach_node command pass /usr/local/bin/pcp_detach_node pcp_node_count command pass /usr/local/bin/

Re: [GENERAL] PgpoolAdmin installation

2007-09-25 Thread Ashish Karalkar
It is confirmed that the function of php_mstring and php_pgsql is effective. a.. "Multibyte Support" is "enabled". b.. "PostgreSQL Support" is "enabled". " But I dont see any phpinfo.php file in the install directory. What may be the reason? With Re

Fw: [GENERAL] PgpoolAdmin installation

2007-09-25 Thread Ashish Karalkar
- Original Message - From: Ashish Karalkar To: Devrim GÜNDÜZ Sent: Tuesday, September 25, 2007 4:30 PM Subject: Re: [GENERAL] PgpoolAdmin installation I got the answer for the same and is sloved it is just a file which gives information about the php installations. I have verified

[GENERAL] pgpoolAdmin:No such file or directory in /var/www/html/pgpoolAdmin-1.0.0/libs/Smarty.class.php on line 1258

2007-09-26 Thread Ashish Karalkar
Hello All, I have installed pgpoolAdmin on linux box. first pgpool configuration setting pages work properly after that when I try to login nothing happens. Following is the error in the apache server log PHP Warning: fetch(templates_c/%%6A^6A5^6A537DD8%%login.tpl.php): failed to open stream:

Re: [GENERAL] multiple row insertion

2007-10-04 Thread Ashish Karalkar
INSERT INTO qsweb.core_board(board_name, entry_user_id, entry_date) VALUES ('a',1,now()),('b',1,now()); - Original Message - From: test tester To: pgsql-general@postgresql.org Sent: Thursday, October 04, 2007 4:49 PM Subject: [GENERAL] multiple row insertion In MySQL, I

[GENERAL] Error while database creation

2007-10-04 Thread Ashish Karalkar
Hello All, I am getting following error when trying to create new database. createdb: database creation failed: ERROR: could not create directory "base/1923827": No space left on device can anybody please tell me what is going wrong. Thanks in advance. With regards Ashish

[GENERAL] cp: cannot stat `/mnt/server/archivedir/00000001.history': No such file or directory

2007-11-27 Thread Ashish Karalkar
Hello List Member, I am trying to setup recovery from WAL, recovery is done properly but there are some alerting messages in the log file log file : * 2007-11-27 14:08:04 IST LOG: database system was

[GENERAL] WAL Recovery

2007-11-27 Thread Ashish Karalkar
Hello List Members, I have PostgreSQL 8.2.4 on Suse Linux Whne I am doing recovery from WAL archives I see in the logger that "01.history file not found" infact server has not created such file insted it created 01.backup file which contains the history which documents also suggest is

Re: [GENERAL] WAL Recovery

2007-11-28 Thread Ashish Karalkar
Thanks Simon for your replay, Yes I have followed the same instruction givn on the link, still it is happining , should i ignore this message too? With Regards Ashish Simon Riggs <[EMAIL PROTECTED]> wrote: On Wed, 2007-11-28 at 06:05 +0000, Ashish Karalkar wrote: > I have PostgreSQL

Re: [GENERAL] SQL Query

2007-12-05 Thread Ashish Karalkar
"A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Wed, dem 05.12.2007, um 10:24:04 +0000 mailte Ashish Karalkar folgendes: > Hello List member, > > Iha a table containing two columns x and y . for single value of x there are > multiple values in y e.g > > X

[GENERAL] SQL Query

2007-12-05 Thread Ashish Karalkar
Hello List member, Iha a table containing two columns x and y . for single value of x there are multiple values in y e.g XY 1ABC 2PQR 3 XYZ 4 LMN 1 LMN 2 XYZ I want a query that will give me following output 1ABC:LMN 2

[GENERAL] Query

2007-12-10 Thread Ashish Karalkar
Hello there, I am having data in table something like below: user_idtype_id 11 12 21 33 43 51 1 10 76 What i want is the co

[GENERAL] very slow query

2007-12-12 Thread Ashish Karalkar
Hi, I am having PostgreSQL 8.2.4 on Suse 10.3 Server is not using the index insted it chooses to take seq scan path. table is having @ 120 million rows here is the output from planner: Nested Loop IN Join (cost=0.00..5030217.97 rows=2 width=106) -> Seq Scan on sms_new (cost=0.00..5027902.0

Re: [GENERAL] very slow query

2007-12-12 Thread Ashish Karalkar
"A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Wed, dem 12.12.2007, um 12:44:09 +0000 mailte Ashish Karalkar folgendes: > > Do you have an index on "mobile"? Can you show us the table definition > > and the output from EXPLAIN ANALYSE? >

Re: [GENERAL] very slow query

2007-12-12 Thread Ashish Karalkar
Alvaro Herrera <[EMAIL PROTECTED]> wrote: Ashish Karalkar wrote: > Thanks for your answer actually that was the part of full query here is the > actuall plan I think you are confusing this for "here is a completely different plan for a completely different query that

Re: [GENERAL] very slow query

2007-12-12 Thread Ashish Karalkar
Alvaro Herrera <[EMAIL PROTECTED]> wrote: Ashish Karalkar wrote: > Thanks for your answer actually that was the part of full query here is the > actuall plan I think you are confusing this for "here is a completely different plan for a completely different query that

Re: [GENERAL] very slow query

2007-12-12 Thread Ashish Karalkar
"A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Wed, dem 12.12.2007, um 12:25:20 +0000 mailte Ashish Karalkar folgendes: > > here is the output from planner: > > Nested Loop IN Join (cost=0.00..5030217.97 rows=2 width=106) > > -> Seq Scan on sm

Re: [GENERAL] very slow query

2007-12-12 Thread Ashish Karalkar
"A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Wed, dem 12.12.2007, um 11:44:58 +0000 mailte Ashish Karalkar folgendes: > Hi, > I am having PostgreSQL 8.2.4 on Suse 10.3 > > Server is not using the index insted it chooses to take seq scan path. table > is > h

Re: [GENERAL] Planner ignoring to use INDEX SCAN

2007-12-14 Thread Ashish Karalkar
Thanks Richard for your replay, here is the output.. Richard Huxton <[EMAIL PROTECTED]> wrote: Ashish Karalkar wrote: > > Richard Huxton wrote: Ashish Karalkar wrote: >> query which was taking seconds on the join of these two table >> suddenly started taking 20/25 m

Re: [GENERAL] Planner ignoring to use INDEX SCAN

2007-12-14 Thread Ashish Karalkar
Richard Huxton <[EMAIL PROTECTED]> wrote: Ashish Karalkar wrote: > query which was taking seconds on the join of these two table > suddenly started taking 20/25 min Show the EXPLAIN ANALYSE of your problem query and someone will be able to tell you why. Here is the output from exp

[GENERAL] WAL Sequence

2008-01-07 Thread Ashish Karalkar
Dear list member: I have small problem, below is the output from ls -larth command for listing WAL segments. As far as my understanding every new WAL segment created is numerically greater than the previous one,but below out show the WAL 13 is created after wal 14,15,16,17,18,19 checked by creat

[GENERAL] Insert waiting for update?

2008-01-09 Thread Ashish Karalkar
Dear list members,I am having table with 4M rows.I am trying to update all these rows with statementupdate mytable set mycolumn=0;At the same time there are insert happening on the table.but all these insert are in waiting mode. does update is locking the table for insert?does insert and update con

Re: [GENERAL] Insert waiting for update?

2008-01-09 Thread Ashish Karalkar
--- On Wed, 9/1/08, Ashish Karalkar <[EMAIL PROTECTED]> wrote:From: Ashish Karalkar <[EMAIL PROTECTED]>Subject: [GENERAL] Insert waiting for update?To: "pggeneral" Cc: [EMAIL PROTECTED]Date: Wednesday, 9 January, 2008, 4:29 PMDear list members,I am having table with 4M rows

Re: [GENERAL] Insert waiting for update?

2008-01-09 Thread Ashish Karalkar
Thanks for the replayI think you missed on second detail mail :For more details:I have two tables master,child.with child having fk to master.Now that master table contains 4M rows . while I update them (Master table) the inserts are going into waiting mode on child table.Update  acquired row exclu

[GENERAL] ERROR: shared buffer hash table corrupted

2008-01-14 Thread Ashish Karalkar
Hello list members,I hav a table with 140M rows. While I am trying to select the count from the tableI am getting following errorERROR:  shared buffer hash table corruptedCan anybody please suggest me wht had gone wrong and how to fix it?PostgreSQL 8.2.4OS:Suse 10.3With RegardsAshish... Sa

Re: [GENERAL] newbie question - delete before insert

2010-11-20 Thread Ashish Karalkar
isting row? >> > > You can simply send the UPDATE, if nothing was updated, it's safe to > send the INSERT > > Regards > Thomas > > > something on the line of http://www.postgresql.org/docs/8.4/interactive/plpgsql-control-structures.html *Example 38-2. Exceptions with UPDATE/INSERT* -- With Regards Ashish Karalkar

Re: [GENERAL]

2013-07-28 Thread Ashish Karalkar
wow! http://cochesclasicosparabodas.com/cnn.com_world.html mjfamywelicjnyqepohu -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] shared buffer hash table corrupted

2008-02-19 Thread Ashish Karalkar
Hello List membersI have just upgraded the PostgreSQL server from 8.2.4 to 8.3 on Suse 10.3 64 bit.While inspecting the log i see this errorERROR: shared buffer hash table corruptedCan anybody please help me in getting into details of it?With regardsAshish... Unlimited freedom, unlimited s

[GENERAL] Problem with Constraint Exclusion ON

2010-08-11 Thread Ashish Karalkar
e is an example: http://pgsql.privatepaste.com/74d558e05f Any help would be much /appreciated./ -- With Regards Ashish Karalkar

Re: [GENERAL] Defining permissions for tables, schema etc..

2009-12-10 Thread Ashish Karalkar
On 12/10/2009 01:00 PM, dipti shah wrote: > Hi, > > We have started using PostGreSQL for more than 3 months and it looks > awesome. Currently, we have been suing superuser by default as login > account. Now, the users are getting increased and we want to go away > with using superuser by default.

Re: [GENERAL] Load Testing

2009-02-13 Thread Ashish Karalkar
Ashish Karalkar wrote: Abdul Rahman wrote: Hi all, Can any body tell me about tool for PostgreSQL load testing preferably freeware. Regards, Abdul Rehman. I am not sure its a freeware or not but looks promising http://bristlecone.continuent.org/HomePage --Ashish And ofcourse the

Re: [GENERAL] Load Testing

2009-02-13 Thread Ashish Karalkar
Abdul Rahman wrote: Hi all, Can any body tell me about tool for PostgreSQL load testing preferably freeware. Regards, Abdul Rehman. I am not sure its a freeware or not but looks promising http://bristlecone.continuent.org/HomePage --Ashish -- Sent via pgsql-general mailing list (pgsql-g

Re: [GENERAL] hi all

2009-02-17 Thread Ashish Karalkar
Kusuma Pabba wrote: when creating tables, in my sql i have used create table CREATE TABLE `users` ( `user_id` int(11) NOT NULL auto_increment, `user_name` varchar(50) NOT NULL, `first_name` varchar(50) default NULL, `middle_name` varchar(50) default NULL, `last_name` varchar(50) default NUL

Re: [GENERAL] Restore DB

2009-02-25 Thread Ashish Karalkar
Shahbaz A. Tyagi wrote: Hi, We are using Postgres 8.3. We have backed up our db and while trying to restore, its not able to. We are using PgAdminIII for the same. What all other ways we have to restore the db. We have both the old data directory as well as backed up data. Sh

Re: [GENERAL] Restore DB

2009-02-25 Thread Ashish Karalkar
Shahbaz A. Tyagi wrote: Hi, We are using Postgres 8.3. We have backed up our db and while trying to restore, its not able to. We are using PgAdminIII for the same. What all other ways we have to restore the db. We have both the old data directory as well as backed up data. Sh

Re: [GENERAL] Restore DB

2009-02-25 Thread Ashish Karalkar
. Tyagi Sphere Networks -Original Message- From: Ashish Karalkar [mailto:ashis...@synechron.com] Sent: Wednesday, February 25, 2009 4:38 PM To: Shahbaz A. Tyagi Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Restore DB Shahbaz A. Tyagi wrote: Hi, We are using Postgres 8.3

Re: [GENERAL] Getting time-dependent load statistics

2009-02-26 Thread Ashish Karalkar
ö, Torsten. If I understood you correctly you might get help from following: http://pgfouine.projects.postgresql.org/ With Regards Ashish Karalkar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Connection refused (0x0000274D/10061).

2009-02-26 Thread Ashish Karalkar
najmuddin hassan wrote: Hi, I just installed a program called moteview by crossbow technologies. It uses postgreSQL 8.0.0-rc1 for its database. There is something wrong as when I launched the program it automaticly gives me an error that the database is not available. The postgreSQL database

Re: [GENERAL] Shared Buffers

2009-03-02 Thread Ashish Karalkar
Siddharth Shah wrote: Hello All, How Postgres Maintains data in Shared Buffer Does It maintains queried data in memory or table data and Next time how postgres fetch data from memory rather than disk Which algorithm is used for storing data how data is indexed in shared buffers Thanks Sidd

[GENERAL] PostgreSQL template for cacti

2009-03-05 Thread Ashish Karalkar
Hello list, I was wondering is there any postgresql template for cacti to monitor PostgreSQL server. can anybody plz point me to the same? Thanks in advance --Ashish -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.pos

Re: [GENERAL] PostgreSQL template for cacti

2009-03-05 Thread Ashish Karalkar
Ashish Karalkar wrote: Hello list, I was wondering is there any postgresql template for cacti to monitor PostgreSQL server. can anybody plz point me to the same? Thanks in advance --Ashish That worked from google, sorry for making noise... http://forums.cacti.net/about23300.html

Re: [GENERAL] commit/rollback in postgre 8.2

2009-03-09 Thread Ashish Karalkar
transaction. With Regards Ashish Karalkar EnterpriseDB -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Database separation for backup

2009-03-12 Thread Ashish Karalkar
Nagalingam, Karthikeyan wrote: Hi, Is there any way to keep each database in separate partition ie) separate folder for each database. I would like to do the dabase level backup in storage side, for that If I am able to separate the database in folderwise, I can allocate separate partition

Re: [GENERAL] PostgreSql with or without Plus?

2009-03-17 Thread Ashish Karalkar
Joshua D. Drake wrote: On Tue, 2009-03-17 at 18:23 +0100, Jennifer Trey wrote: Which one should one install? Is there any difference? They are both free right? And both has fulltext support, right? It depends on your requirements. I always suggest using a version that natively supp

Re: [GENERAL] PostgreSql with or without Plus?

2009-03-18 Thread Ashish Karalkar
Simon Riggs wrote: On Wed, 2009-03-18 at 11:19 +0530, Ashish Karalkar wrote: Postgres Plus does support Linux and it includes all the PostgreSQL features as well as have many other additional useful features.One of which is its dyna tune module. You can check through the webpage http

Re: [GENERAL] Report all Comments

2009-03-18 Thread Ashish Karalkar
pd.objoid AND pc.relname=ic.table_name AND ic.ordinal_position=pd.objsubid AND pc.relnamespace=pn.oid AND pn.nspname in ('public') ORDER BY pn.nspname,pc.relname,ic.ordinal_position; With Regards --Ashish Karalkar - Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

[GENERAL] Please help.-- unable to load xxid.so

2006-11-28 Thread Ashish Karalkar
ql/xxid.so: failed to map segment from shared object: Permission denied Function xxid.so is there in the /usr/lib/pgsql directory stil its unable to load. Can any one please help me which shared object it is refering to... With Regards Ashis

Re: [GENERAL] Please help.-- unable to load xxid.so

2006-11-28 Thread Ashish Karalkar
Thanks Chris , I ahve checked the permissions on the xxid.so file and it ids having all permission i.e. 0777 I think its not getting the permission from the object which xxid.so is refering, any idea which object it is refering With Regards Ashish Karalkar --- Chris <[EMAIL PROTECTED]>

Re: [GENERAL] Please help.-- unable to load xxid.so

2006-11-29 Thread Ashish Karalkar
shared object -permission denied)function was refering ? with regards Ashish Karalkar --- Chris <[EMAIL PROTECTED]> wrote: > Ashish Karalkar wrote: > > Thanks Chris , > > I ahve checked the permissions on the xxid.so file > and > > it ids having all permission i.e. 07

[GENERAL] Please help... syntax Error in create set ..

2006-11-30 Thread Ashish Karalkar
I want to create new set, I am running create set command as follows create set (id=2, origin=1, comment='All tables'); but it gives error syntax error near unexpected token `(' can anybody tell me where i am doing wrong With regards Ashish _

Re: [GENERAL] [Slony1-general] Please help... syntax Error in create set ..

2006-11-30 Thread Ashish Karalkar
into which i will merge it later on. If yes, how to do it coz with the slonik script it gives me error cluster already exists. Please help. Thanks --- Devrim GUNDUZ <[EMAIL PROTECTED]> wrote: > Hi, > > On Thu, 2006-11-30 at 00:12 -0800, Ashish Karalkar > wrote: > > >

[GENERAL] Erorr in running create set command

2006-11-30 Thread Ashish Karalkar
1 ); > _EOF_ :1: ERROR: syntax error at or near MERGE thanks & regards ashish karalkar Yahoo! Music Unlimited Access over 1 million songs. http://music.yahoo.com/unlimited --

[GENERAL] pg_log missing

2006-12-07 Thread Ashish Karalkar
Hello all, I have build 8.2 version from source code on redhat linux 4.0 but i am not able to figure out why directory pg_log is missing... and as it is missing then where are the log file.' can anybody help.. Thanks & Regards Ashish

[GENERAL]

2006-12-08 Thread Ashish Karalkar
Can we have Auto Backup facility to schedule backup of PostgreSQL Database I am using version 8.2.0 With Regads Ashish Karalkar Want to start your own business? Learn how on Yahoo! Small Business. http

[GENERAL] Auto Backup facility?

2006-12-08 Thread Ashish Karalkar
Can we have Auto Backup facility to schedule backup of PostgreSQL Database I am using version 8.2.0 With Regads Ashish Karalkar Have a burning question? Go to www.Answers.yahoo.com and get answers from

[GENERAL] 8.2.0 Installation Problem

2006-12-11 Thread Ashish Karalkar
oing wrong With Regards Ashish Karalkar Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail beta. http://new.mail.yahoo.com ---(end of broadcast)---

[GENERAL] PostgreSQL Connections?

2007-01-09 Thread Ashish Karalkar
Hello All, I am running PostgresSQL 8.2 on Redhat Linux 4. When I look for the processes that are using postgres using ps aux|more I got lots of Idle processes with servers own IP address. Can anybody please tell me why this is happening. Also there are multiple processes for my single client(same

[GENERAL] SP in PostgreSQL

2007-01-10 Thread Ashish Karalkar
uot;commit": SPI_ERROR_TRANSACTION Thanks in advance!!! With Regards Ashish Karalkar __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(e

[GENERAL] Foreign Key Identification

2007-01-10 Thread Ashish Karalkar
? where Foreign key = TableAPK and this should list me TableB TableC is there any way to get this? Thanks in advance With Regards Ashish Karalkar Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail

Re: [GENERAL] Foreign Key Identification

2007-01-11 Thread Ashish Karalkar
have strict nameing convention for foreign key and primary key in order to arive at table name.. Reece pgutil is excellent to get the all required information on foreign key tables and primary key tables. With Regards Ashish Karalkar --- Reece Hart <[EMAIL PROTECTED]> wrote: >

[GENERAL] Select Query

2007-01-11 Thread Ashish Karalkar
Hello List, I am having list of tables , what I want to do is to filter this list of table for a particular value of its column, the column which i will be searching is common accross all tables in list any clues?? With regards Ashish Karalkar

[GENERAL] error in open cursor

2007-01-12 Thread Ashish Karalkar
Hello all, I am getting a syntax error near open cursor, can anybody please point me what is missing. i am using Postgresql 8.2 CREATE OR REPLACE FUNCTION sp_gen_foreign_keys_tables(OUT par_result integer, OUT par_childtables text, IN par_colname character varying , IN par_colvalue integer) AS $BO

Re: [GENERAL] PostgreSQL Connections?

2007-01-12 Thread Ashish Karalkar
--- Shoaib Mir <[EMAIL PROTECTED]> wrote: > Can you show us the output for: > > ps auxwww | grep ^postgres > > that should explain a little more... > > - > Shoaib Mir > EnterpriseDB (www.enterprisedb.com) > > On 1/10/07, Ashish Karalkar > &l

Re: [GENERAL] PostgreSQL Connections?

2007-01-13 Thread Ashish Karalkar
, we are using jboss as web application server. Point of worry is that my server has many idle process on its own IP . With regards Ashish Karalkar --- Shane Ambler <[EMAIL PROTECTED]> wrote: > Ashish Karalkar wrote: > > Hi Shoaib > > > > Following is the output for p

[GENERAL] Need help on SP

2007-01-16 Thread Ashish Karalkar
#x27; VOLATILE; it is giving me error in select statment, Thanks in advance With Regards Ashish Karalkar Never miss an email again! Yahoo! Toolbar alerts you the instant new Mail arrives. http://tools.searc

[GENERAL] Cursor body?

2007-01-17 Thread Ashish Karalkar
lect into (variable)" but it gives me error "Execute of select into is not implemented yet" I am using postgreSQL 8.2. Thanks in advance With Regards Ashish Karalkar ___

[GENERAL] Automating databse creation

2007-02-09 Thread Ashish Karalkar
Hello list, I want to automate database creation, user creation,table creation via script. this script will be run by an external programme to postgresql server. is there any way? what i want to do is as follows: #!/bin/sh su - postgres TIMEDUMP=`date +%Y%m%d"_"%H%M` PG_PATH=/usr/local/pgsql

[GENERAL] How to append tables in a view

2007-02-13 Thread Ashish Karalkar
Hello List, I want to append column of two different tables in a single column of a view . data type of tow column of two diffrent tables will be same. WHAT I WANT TO DO IS: Table 1 ID DESC 1 A 2 B 3 C

[GENERAL] user input during runtime

2007-02-15 Thread Ashish Karalkar
Hello All, I want to prompt user to input some value and do some action on that value in runtime of a sql script. Is there any psql command to do this ?? I can use \echo do display massage but to take input what is the command? Thanks in advance With Regards Ashish Karalkar

[GENERAL] PLpgSQL debugger

2007-03-15 Thread Ashish Karalkar
Hello All, I have downloaded the PLpgSQl Debugger tarball edb-debugger-20061107-src.tar.gz after issuing gmake it gives me list of errors. But not getting how to install it. Can anybody tell me what are the steps to install it. Thanks in advance With Regards Ashish..

Re: [GENERAL] Configuring phpPgAdmin and pg_ctl reload

2007-03-21 Thread Ashish Karalkar
Try pg_ctl -D /path to pg data home e.g. pg_ctl -D /usr/local/pgsql/data Hope this will help - Original Message - From: "John Meyer" <[EMAIL PROTECTED]> To: "postgresql-general" Sent: Thursday, March 22, 2007 8:31 AM Subject: [GENERAL] Configuring phpPgAdmin and pg_ctl reload

  1   2   >