[ADMIN] Postgresql takes more time to update

Hi Team, We are using "psql 7.4.2" version of Postgresql, these days all the transactions on the database are taking long time to execute. We are planning to do "ANALYZE" command on the database. Could you please advice us, how much time it takes and what are the conditions we need to keep on a

Re: [ADMIN] Postgresql takes more time to update

+9120 66453213 From: Peter Koczan [mailto:[EMAIL PROTECTED] Sent: Saturday, October 06, 2007 11:00 PM To: Suresh Gupta VG Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgresql takes more time to update We are using "psql 7.4.2" versio

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

0 66453213 From: Peter Koczan [mailto:[EMAIL PROTECTED] Sent: Monday, October 08, 2007 10:01 PM To: Suresh Gupta VG Cc: [EMAIL PROTECTED]; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgresql takes more time to update On 10/7/07, Suresh Gupta VG <[EMAIL PROTECTED]>

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

Batelco Phase II Mo: +91 9890898688 Ph : +9120 66453213 From: Peter Koczan [mailto:[EMAIL PROTECTED] Sent: Monday, October 08, 2007 10:01 PM To: Suresh Gupta VG Cc: [EMAIL PROTECTED]; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgresql takes more time

Re: [ADMIN] Postgresql takes more time to update

To: Suresh Gupta VG Cc: Peter Koczan; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgresql takes more time to update On 10/23/07, Suresh Gupta VG <[EMAIL PROTECTED]> wrote: Hi Peter, 1) We are using "psql 7.4.2" version of Postgresql, need

Re: [ADMIN] Postgresql takes more time to update

: Suresh Gupta VG Cc: [EMAIL PROTECTED]; pgsql-admin@postgresql.org; [EMAIL PROTECTED] Subject: Re: [ADMIN] Postgresql takes more time to update On 10/23/07, Suresh Gupta VG <[EMAIL PROTECTED]> wrote: Hi Peter, 1) We are using "psql 7.4.2" version of Postgresql,

Re: [ADMIN] Postgresql takes more time to update

: +91 9890898688 Ph : +9120 66453213 From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 2:17 AM To: Suresh Gupta VG Cc: Peter Koczan; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgresql takes more time to update On 10/23/07, S

[ADMIN] Need some help in psql Configuration

Hi Team, I am using Postgresql 7.4 version. We are willing to update the version to the latest. Can you pls give some guidelines and provide the link to the software to download. Is it free downloadable or commercial, pls advice us. Secondly, we found there is very less performance with

[ADMIN] Need some info on Postgresql

: [EMAIL PROTECTED]| website: www.zensar.com <http://www.zensar.com/> From: Peter Koczan [mailto:[EMAIL PROTECTED] Sent: Sunday, November 04, 2007 5:09 AM To: Suresh Gupta VG Cc: pgsql-admin@postgresql.org Subject: Re: Postgresql pg_dumpal

[ADMIN] Need source for Solaris 9

Hi Team, I am using 7.4.2 version of Postgresql on "Solaris 9 9/04 s9s_u7wos_09 SPARC". I need to upgrade to pgsql-8.2.5 version. I could not get the source for the solaris-9 on the site(http://www.postgresql.org/download/). I could see only for Solaris-10. Can you please provide me the right

Re: [ADMIN] Need some info on Postgresql

[mailto:[EMAIL PROTECTED] Sent: Friday, January 04, 2008 7:53 AM To: Suresh Gupta VG Cc: Peter Koczan; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Need some info on Postgresql On Jan 3, 2008 5:33 AM, Suresh Gupta VG <[EMAIL PROTECTED]> wrote: > > Hi Team, > > I am usin

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 some info.

Hi Team, We are upgrading the pgsql from 7.4.2 to 8.2.5 on Solaris 9 Spark machine, I had downloaded the sources also. I had gone through the instalation documents too. I could not find the procedure to rollback the new version, if the new version does not support our application. Queries :-

[ADMIN] Cannot bind socket

Hi team, I am using pgsql 8.2.5 on Solaris 9 sparc machine. I had a separate server which contains my application running. I need to connect the database from the application server same configuration Solaris 9. I am trying to add the IP address and net mask number in the "pg_hba.conf" of postg

[ADMIN] Can we have 2 databases on same server

Hi Team, I have Solaris 9 machine with Pgsql 7.4 and want to upgrade to 8.2.5. I don't want to disturb the first version now. I want to install second one separately and need to test with my application. If it works fine, I will activate only the latest one and other version 7.4 will be discard

[ADMIN] Postmasters in sleeping mode

Hi Team, I am on Solaris-9 and Pgsql-7.4.2. This database is running on the live production server. It takes more than 5 minutes to update one single query. This is very horrible and completely not acceptable on the live. We had scheduled Vacuum on daily basis at low traffic time of the day. Du

[ADMIN] Bypass the DB request

Hi Team, Can any one advice me to rectify this error message by postgresql as below? My Scenario: I had 2 servers with Solaris7. ServerA contains my application where it is connected to a database(pgsql-7.1) on the same server. I had installed the pgsql_8.2.5 on the ServerB of Solaris-9. I

[ADMIN] error while extracting the database

Hi Team, I had data dump file of pgsql7.0. I am trying to extract the data on pgsql8.2.5, giving an error in the middle of the extraction of data. I use (/db1/postgresql/bin/psql -d commercelink -f dump_oldprod_db). But I could enter the database and could see the tables created but with no dat

[ADMIN] Processes running without cleaning

Hi Team, I am using Solaris9 and pgsql 8.2.5. Started the DB with the option 50 nodes and 100 blocks as below. pg_ctl start -D /db1/postgresql/data -o "-N 50 -B 100 -i" When started, there are 3 processes running with postgres names. After that when a single transaction comes to the DB,

[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] Latest postgres stable version

Hi Team, I am using Solaris-9 and pgsql-7.4.2. I am going to upgrade my DB to the latest and stable release. 1. May I know what is the stable pgsql release and latest? 2. I heard the version 8.2.5 is stable, but when I searched for the same on site, it has only 8.2.6. May I know

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

Hi team, I am in the testing of my application with the new database 8.2.5 on solaris-9. I get the logs as below when ever any transactions come from my application. What does it really mean? WARNING: there is no transaction in progress LOG: unexpected EOF on client connection Regard

[ADMIN] Error with PG_MODULE_MAGIC macro

Hi List, We are under up gradation of pgsql 7.4.2 to latest version 8.2.25 on Solaris-9. While compiling the source, we found some error with encryption file. As per the pgsql admin team suggestions, we included the macro of PG_MODULE_MAGIC, in the code while creating the 2 functions. An error

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] Copy table to table

Hi List, I want to create a new table with the data and constraints as it is from existing table. I could create a new table with the existing table data as " create table test2 as select * from test1; ". Here the constraints are not copying. Can any one please show me the way. Regards,

[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] 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