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:[EMAIL PROTECTED] Sent: Wed 8/4/2004 12:05 AM To: [EMAIL PROTECTED] 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 +91 80 26588360 / 51197222 xtn. 8211 > Fax No +91 80 26584750 > 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
