Application crash - pls help !!!

[Pradeepkumar, Pyatalo (IE10)]

Hi all,

In the project that I am working, we have 4-5 components. Recently we had
the integration of the components. Before integrating the postgresql
database component, the application was running for 3-4 days without any
problem. But after integrating the database component with the application,
it works fine for sometime and some other times it crashes, it is not
consistent. I guess it is due to the database. It doesnt give any clue as to
where the problem is. Is there any way to track the problem....where are the
errors logged. The database component uses libpq to interact with the
database. Can anyone help me in this.

With Best Regards
Pradeep Kumar P J
Honeywell_______________________________________
No.151/1, Doraisanipalya, (Opp. to IIMB) Bannerghatta Rd, Bangalore 560
076.
Telephone No [phone] / 51197222 xtn. 8211
Fax No [phone]
Website: Honeywell.com

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Gregory S. Williamson]

Pyatalo,

As a start, perhaps you could provide some more information about what release of postgres, what OS platform and perhaps some more about the connection type (JDBC, perl, PHP, PgAdmin, etc) and some information about the application itself ? I am not knowledgable enough about postgres to be sure what the reference to "libpq" might imply.

The postgres log itslef is defined when postgres is started. For instance, a start command might be (this is a linux version):

su - postgres -c '/apps/pgsql/bin/pg_ctl start -D /data/postgres/databasename -l /home/postgres/log/databasename -o -i'

where the "-l" specifies the log file (we keep ours in a standard system directory -- /home/postgres/log/ -- which we create when we initialize the postgres instance, but there is nothing to keep the log file from being somewhere else that postgres has permissions for).

HTH,

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From: Pradeepkumar, Pyatalo (IE10) [mailto:***@honeywell.com]
Sent: Wed 8/4/2004 12:05 AM
To: pgsql-***@postgresql.org
Cc:
Subject: [ADMIN] Application crash - pls help !!!

Hi all,

In the project that I am working, we have 4-5 components. Recently we had
the integration of the components. Before integrating the postgresql
database component, the application was running for 3-4 days without any
problem. But after integrating the database component with the application,
it works fine for sometime and some other times it crashes, it is not
consistent. I guess it is due to the database. It doesnt give any clue as to
where the problem is. Is there any way to track the problem....where are the
errors logged. The database component uses libpq to interact with the
database. Can anyone help me in this.

With Best Regards
Pradeep Kumar P J
Honeywell_______________________________________
No.151/1, Doraisanipalya, (Opp. to IIMB) Bannerghatta Rd, Bangalore 560
076.
Telephone No [phone] / 51197222 xtn. 8211
Fax No [phone]
Website: Honeywell.com

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend




---------------------------(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