[ADMIN] psql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams

2011-12-28 Thread Suresh Hosur
: symbol lookup error: psql: undefined symbol: PQconnectdbParams once i run it, It showing the same error so, please help me to come out from this problem... -- Regards,* *Suresh Hosur

[ADMIN] Handling of images via Postgressql

2010-04-07 Thread Suresh Borse
images does it cache? Do you suggest having the images in a different database by itself? Regards, Suresh

Re: [ADMIN] ERROR: syntax error at or near "group"

2009-12-28 Thread Suresh Borse
ally stated. Any review, > retransmission, dissemination or other use of, or taking of any action > in reliance upon, this information by persons or entities other than > the intended recipient is prohibited. If you received this email in > error, please contact the sender and delete the em

Re: [ADMIN] Log full with gigabyes of CurTransactionContex

2009-06-15 Thread Suresh Borse
nsactionContext: 8192 total in 1 blocks; 8176 free (5 chunks); > 16 used > CurTransactionContext: 8192 total in 1 blocks; 8176 free (5 chunks); > 16 used > CurTransactionContext: 8192 total in 1 blocks; 8176 free (5 chunks); > 16 used > CurTransactionContex

Re: [ADMIN] Log full with gigabyes of CurTransactionContex

2009-06-15 Thread Suresh Borse
chunks); > 16 used > CurTransactionContext: 8192 total in 1 blocks; 8176 free (5 chunks); > 16 used > CurTransactionContext: 8192 total in 1 blocks; 8176 free (5 chunks); > 16 used > CurTransactionContext: 8192 total in 1 blocks; 8176 free (5 chunks); > 16 used >

Re: [ADMIN] Query related

2009-03-13 Thread suresh gupta
Thanks Ashish, it is working. Regards, G. V. Suresh Gupta GTS - EMEIA, Zensar Technologies Zensar Knowledge Park, Plot#5, MIDC IT Tower, Kharadi, Off Nagar Road, Pune - 411014 Landline : +91-20-66453471 | +91

[ADMIN] Query related

2009-03-13 Thread suresh gupta
combine 2 columns and display together in single columns like |, +, etc. in other databases like Oracle. For example FN = Suresh and LN=Gupta the output of the query should be Suresh Gupta in single column. Is there any similar operator or method on postgresql to get my result. Please advice. Pgsql

[ADMIN] How to migrate from oracle to postgres !!

2009-01-30 Thread Suresh Borse
Dear All, How to migrate existing database which in Oracle to postgres? Please provide me the solution/limitation for triggers , procedure , packages & views while migrating. Thanks & Regards, Suresh Borse (DBA)

Re: [ADMIN] primary key and insert

2008-12-11 Thread Suresh Borse
;$txtStudentAlert', > 'now()' > )"; > > How do I do an insert on this table and have the primary key "id" > update with the record? > > thanks > > Marc Thanks & Regards, Suresh Borse (DBA)

Re: [ADMIN] Heavy postgres process

2008-12-10 Thread Suresh Borse
us checks before opening the e-mail or attachment. Infosys reserves > the > right to monitor and review the content of all messages sent to or from this > e-mail > address. Messages sent to or from this e-ma

Re: [ADMIN] dba and tables spaces questions

2008-12-08 Thread Suresh Borse
"will this be a > valid cmd ? Or other solution to this issues ? > using Pg version 8.3 on Linux > Thank you in advance > Isabella > > > Thanks & Regards, Suresh Borse (DBA) _

Re: [ADMIN] change user passwd

2008-12-01 Thread Suresh Borse
properties & change the password. On Mon, 2008-12-01 at 12:50 -0800, Isabella Ghiurea wrote: > I'm using PG 8.3.4 , what's the method for remote users to change > their PG passwd . > Isabel

[ADMIN] Very Urgent : Db processes are increasing

2008-07-17 Thread Suresh Gupta VG
server to DB server ?? Pls reply your quick response. --Suresh DISCLAIMER: This email may contain confidential or privileged information for the intended recipient(s) and the views expressed in the same are not necessarily the views of Zensar Technologies Ltd. If you are not the intended rec

Re: [ADMIN] query optimization

2008-07-10 Thread Suresh Borse
the result was same. The view contains multi-table joins. Warm Regards, Suresh Borse On Thu, 2008-07-10 at 12:25 +0300, Julius Tuskenis wrote: > Hello, Suresh > > Maybe its taking long for the first time, and then its faster? Did you > noticed any circumstances under witch your

[ADMIN] query optimization

2008-07-10 Thread Suresh Borse
anges for each execution. Can anybody help me for troubleshooting and for resolving the performance issue. Thanks & Regards, Suresh Borse

[ADMIN] What is the difference between Logical link and Foreign Key link in Postgresql

2008-06-16 Thread Suresh Gupta VG
Hi List, Can any one explain me what is the difference between logical link and foreign key link between the tables in postgresql. Does the tables are linked like parent-child relationship? Pls give me an idea about the logical links in the database. Regards, G. V. Suresh Gupta

[ADMIN] Copy table to table

2008-05-23 Thread Suresh Gupta VG
Regards, G. V. Suresh Gupta - Innovative Technology Solutions(ITS), Zensar Technologies Zensar Knowledge Park, Plot#5, MIDC IT Tower, Kharadi, Off Nagar Road, Pun

Re: [ADMIN] postgresql performance tuning tools

2008-03-17 Thread Suresh Gupta VG
Hi Sathiya, I am using Solaris-9 and pgsql 8.2.5. Can you pls provide more details of this tool, if it can be used for my environment? Pls provide link and docs to get more light on this tool. Once again thanks for your information. Regards, G. V. Suresh Gupta

[ADMIN] Error with PG_MODULE_MAGIC macro

2008-03-05 Thread Suresh Gupta VG
t the data on the database. To make this function work properly, we need to create these 2 functions (blowfish_encrypt and blowfish_decrypt). In the pgsql 8.2.5 version, we find this error while including the MAG

[ADMIN] ES7000 Windows 2003 server 64bit processor

2008-02-28 Thread Babu, Gabriel Suresh
32 bit application does not support the ES7000 Windows 2003 server 64bit processor. Can you please help me on this. Regards Suresh

[ADMIN] Meaning of logs of postgresql

2008-02-28 Thread Suresh Gupta VG
Regards, G. V. Suresh Gupta DISCLAIMER: This email may contain confidential or privileged information for the intended recipient(s) and the views expressed in the same are not necessarily the views of Zensar Technologies Ltd. If you are not the intended recipient or have received this e-mail by

[ADMIN] Pgsql 8.2.5 Installation

2008-02-27 Thread Suresh Gupta VG
Hi team, Actually, the installation of the PGSQL is done by root user only. Can it be done with a normal user login? Does the user require any extra permission from server side or DB side? Regards, G. V. Suresh Gupta

[ADMIN] Latest postgres stable version

2008-02-25 Thread Suresh Gupta VG
one cluster it is the DB is shut down, but due to clustering, the DB is not getting stopped complete. Can any one please suggest how to stop the DB server running on the clusters and upgrade the latest pgsql. Pls advice to guide me on this. Regards, G. V. Suresh Gupta

[ADMIN] Log details are displaying on the console

2008-02-19 Thread Suresh Gupta VG
: sorry, too many clients already FATAL: sorry, too many clients already FATAL: sorry, too many clients already FATAL: sorry, too many clients already --Suresh DISCLAIMER: This email may contain confidential or privileged information for the intended recipient(s) and the views

[ADMIN] Processes running without cleaning

2008-02-18 Thread Suresh Gupta VG
when we give the options for blocks and nodes. As a common, we find 3 processes running as parent processes of pgsql. Pls find the list of processes in the attachment.(max_connction = 100 is configured in the postgresql configuration file. Why cleaning up of process is not happening? Pls advice.

[ADMIN] error while extracting the database

2008-02-15 Thread Suresh Gupta VG
ions" CREATE TABLE psql:dump_oldprod_db:328: \connect: FATAL: role "root" does not exist- Pls advice me. Regards, G. V. Suresh Gupta --- Innovative Technology Solutions(ITS), Zensar Technologies Z

[ADMIN] Bypass the DB request

2008-02-14 Thread Suresh Gupta VG
7; next OID: 3834614 LOG: database system was not properly shut down; automatic recovery in progress LOG: record with zero length at 0/1B2F5708 LOG: redo is not required LOG: dat

[ADMIN] Postmasters in sleeping mode

2008-02-05 Thread Suresh Gupta VG
/db1/postgresql/bin/postmaster pgsql 15329 2519S0:21 36:25 10:03:08 /db1/postgresql/bin/postmaster Regards, G. V. Suresh Gupta

[ADMIN] Can we have 2 databases on same server

2008-01-29 Thread Suresh Gupta VG
e the options like switching the database, the 2 databases are compulsory, right?(Thinking only one server is available.) Can you pls advice on this. Regards, G. V. Suresh

[ADMIN] Cannot bind socket

2008-01-18 Thread Suresh Gupta VG
LOG: database system was shut down at 2005-01-25 12:53:20 AST LOG: checkpoint record is at 0/4865778 LOG: redo record is at 0/4865778; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 37753; next OID: 214365 LOG: database system is ready

[ADMIN] Need some info.

2008-01-10 Thread Suresh Gupta VG
ntain old version. Does it solve our problem Pls advice on this. Regards, G. V. Suresh Gupta - Innovative Technology Solutions(ITS), Zensar Technologies Zensar Know

Re: [ADMIN] Need some info on Postgresql

2008-01-08 Thread Suresh Gupta VG
arted recently last 2 days back. No fruitful result has come. Pls advice us why it is happening. And our database is taking more than 5 minutes to execute a simple query directly on the database at the peak timings say (9:00 Am to 11:00 AM). Pls advice and suggest us what to do. Regards, G. V. S

[ADMIN] Need source for Solaris 9

2008-01-04 Thread Suresh Gupta VG
the right link for the download of source for the Solaris-9. Regards, G. V. Suresh Gupta - Innovative Technology Solutions(ITS), Zensar Technologies Zensar Knowledge Park, Plot#

Re: [ADMIN] Need some info on Postgresql

2008-01-04 Thread Suresh Gupta VG
Hi Scott, Thanks for your reply and pls see my inline comments in red color. Regards, G. V. Suresh Gupta - Innovative Technology Solutions(ITS), Zensar

[ADMIN] Need some info on Postgresql

2008-01-03 Thread Suresh Gupta VG
DB? Can you please suggest some thing. We found these days, the database is taking more time to execute any query. We are doing "vacuum Verbose analyze" regularly at low traffic

[ADMIN] Need some help in psql Configuration

2008-01-01 Thread Suresh Gupta VG
#join_collapse_limit = 8# 1 disables collapsing of explicit JOINs Regards, G. V. Suresh Gupta - Innovative Technology Solutions(ITS), Zensar Technologies

Re: [ADMIN] Postgresql takes more time to update

2007-10-29 Thread Suresh Gupta VG
Thanks Scott and Peter, Can we get a part of data from the database based on any rules like date, field value, etc. b'cas I need the dump of data everyday in a separate files. Can you pls suggest me on this. G.V. Suresh Gupta Sr. Software Engineer Batelco Phase II Mo

Re: [ADMIN] Postgresql takes more time to update

2007-10-24 Thread Suresh Gupta VG
Peter, Thanks for your response. with thanks and regards, G.V. Suresh Gupta Sr. Software Engineer Batelco Phase II Mo: +91 9890898688 Ph : +9120 66453213 From: Peter Koczan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 3:18 AM To

Re: [ADMIN] Postgresql takes more time to update

2007-10-24 Thread Suresh Gupta VG
Scott, Thanks for your response. with thanks and regards, G.V. Suresh Gupta Sr. Software Engineer Batelco Phase II Mo: +91 9890898688 Ph : +9120 66453213 From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 2:17 AM

Re: [ADMIN] Postgresql takes more time to update

2007-10-23 Thread Suresh Gupta VG
databases in 2 different servers. What is the best way to go either backup or copy command? 3) Any equivalent command to export and import commands in Oracle/SQL. Can you please give some knowledge on this with thanks and regards, G.V. Suresh Gupta Sr. Software Engineer

Re: [ADMIN] Postgresql takes more time to update

2007-10-18 Thread Suresh Gupta VG
with thanks and regards, G.V. Suresh Gupta Sr. Software Engineer Batelco Phase II Mo: +91 9890898688 Ph : +9120 66453213 From: Suresh Gupta VG Sent: Thursday, October 18, 2007 7:01 PM To: 'Peter Koczan' Cc: [EMAIL PROTECTED]; p

Re: [ADMIN] Postgresql takes more time to update

2007-10-18 Thread Suresh Gupta VG
databases in 2 different servers. What is the best way to go either backup or copy command? Can you please give some knowledge on this. with thanks and regards, G.V. Suresh Gupta Sr. Software Engineer Batelco Phase II Mo: +91 9890898688 Ph : +912

FW: [ADMIN] Postgresql takes more time to update

2007-10-08 Thread Suresh Gupta VG
Bounced this mail, so sending you again. with thanks and regards, G.V. Suresh Gupta Sr. Software Engineer Batelco Phase II Mo: +91 9890898688 Ph : +9120 66453213 From: Suresh Gupta VG Sent: Sunday, October 07, 2007 12:40 PM To: 'Peter K

Re: [ADMIN] Postgresql takes more time to update

2007-10-08 Thread Suresh Gupta VG
nergy. - - - -- Is 8.2 version is not free downloadable? What type of testing is required? Pls advice us. with thanks and regards, G.V. Suresh Gupta Sr. Software Engineer Batelco Phase II Mo: +91 9890898688 Ph :

[ADMIN] Postgresql takes more time to update

2007-10-05 Thread Suresh Gupta VG
s we need to keep on an eye. Can you please tell us whether we had any other commands are available on postgresql to increase the performance of the database and database tools available for Postgresql on Solaris sparc machine? with thanks and regards, G.V. Suresh Gupta Sr. Software

[ADMIN] Installation Docs for Linux and Windows

2004-04-05 Thread Suresh
Hi Team, Any good url which talk about linux and windows installation. Thanks in advance suresh a. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[ADMIN] Doc for Linux & Windows

2004-04-05 Thread Suresh
Hi All, Can any one suggest me a good url for linux and windows from download to configuration. Thanks in advance. Suresh ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] Installation Docs

2004-04-05 Thread Suresh
Hi All, Any nice docs which talk about complete linux & windows installation. Thanks Suresh A. ---(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

[ADMIN] unsubsribe

2003-09-12 Thread suresh prasanna
unsubsribe pgsql-admin __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

[ADMIN]

2003-09-10 Thread suresh prasanna
unsubscribe-digest pgsql-admin __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please s