Re: [ADMIN] Query related

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

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] Very Urgent : Db processes are increasing

Hi List, I am using pgsql 7.4.2 on solaris-9. When I start the postgres with "-i" option as below, the processes of the postgres are increasing drastically. pg_ctl start -D /db1/postgresql/data -o "-i" If I exclude "-I" option, my application couldn't connect the DB server at all. Here are my q

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

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

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

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

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] Meaning of logs of postgresql

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

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

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

Hi All, All the logging details of pgsql are displaying on the console itself. Pls see the below output. Is there any option in the configuration files to disable it.? bash-2.05$ ps -ef |grep postgres pgsql 17915 17913 0 12:51:13 ?0:00 /db1/postgresql/bin/postgres -D /db1/postg

[ADMIN] Processes running without cleaning

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

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

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

/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

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

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.

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

dline : +91-20-66453471 | +91-9890898688 Email : [EMAIL PROTECTED]| website: www.zensar.com -Original Message- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Monday, January 07, 2008 10:17 PM To: Suresh Gupta VG Cc: Peter Koczan;

[ADMIN] Need source for Solaris 9

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

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

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

#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

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

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

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

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

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

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

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

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

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